Untitled

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
    <%@ page import="java.sql.*" %>
    <%@page import ="java.sql.Date" %>
    <%@page import =  "java.text.*" %>
<%@ page import="java.io.*" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<link rel="stylesheet" type="text/css" href="css/style.css">
<title>Insert title here</title>
</head>
<h4 align="center">Hotel Reservation Statistics</h4>
<body>
<ul>
  <li><a class="active" href="home.html">Home</a></li>
</ul>

<sql:setDataSource
    var="DS"
    driver="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost:3306/hotel"
    user="root" password="Thunder0!"
/>

<%
String checkIn = request.getParameter("bday");

SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy");

java.util.Date dt = sdf.parse(checkIn);

java.sql.Date sqlD = new Date(dt.getTime());
pageContext.setAttribute("in_date", sqlD);
out.println("after sql " + sqlD); %>

<%
String checkOut = request.getParameter("eday");


SimpleDateFormat sdff = new SimpleDateFormat("MM/dd/yyyy");

java.util.Date dtt = sdff.parse(checkOut);

java.sql.Date sqlDD = new Date(dtt.getTime());
pageContext.setAttribute("out_date", sqlDD);
out.println("after sql " + sqlDD);
%>

<c:set var = "in" value = "${in_date}"/>
<c:set var = "out" value = "${out_date}"/>

<sql:query var="list_rooms" dataSource="${DS}">
Select bType, max(total) as final
from (SELECT bType, Avg(rating) AS total
    FROM Review Rv, Reservation Rs
    where Rs.InDate BETWEEN  ? and ?
        <sql:param value = "${in}"/>
        <sql:param value = "${out}"/>
        and Rs.OutDate Between ? and ?
        <sql:param value = "${in}"/>
        <sql:param value = "${out}"/>
         and Rv.Room_no=Rs.Room_no
    and Rs.HotelID=Rv.HotelID and isBreakfastReview = 1
Group by bType) as T1
group by bType
order by
    total desc
limit 1;
</sql:query>

</body>
</html>