Untitled

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<!DOCTYPE html>

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Search Cars</title>
    <link href="" type="text/css" rel="stylesheet">
    <style>
    table, th, td {
        border: 1px solid black;
    }
</style>
  </head>
  <body>
    <h1>Search Cars</h1>
    <form action= "" method="POST">
      <center>
        Car Make:
      <select name="cartype" id="cartype" onchange="this.form.submit();">
        <option value="0">Select Car Make</option>
        <%
          String carmod= null;
          try{
            String Query="Select * FROM auction_items GROUP BY cartype";
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/auction","root","cenk");
            Statement st= conn.createStatement();
            ResultSet rs= st.executeQuery(Query);
            while(rs.next()){
           %><option value ="<%=rs.getInt("ProductID")%>"

            <%
              if(request.getParameter("cartype") !=null){
                if(rs.getInt("ProductID")==Integer.parseInt(request.getParameter("cartype")))
               {
                  out.print("Selected");
                  carmod=rs.getString("cartype");
                }
            }

            %>><%=rs.getString("cartype")%></option><%

          }

        }catch(Exception e){
          e.printStackTrace();
        }

        %>
      </select>
    </p>
   Car model:
      <select name="carmodel" id="carmodel" onchange="this.form.submit();">
        <option value="0">Select Car Model</option>
        <%
        try{
            String query="Select * FROM auction_items WHERE cartype=? Group by carmodel";
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            Connection con= DriverManager.getConnection("jdbc:mysql://localhost/auction","root","cenk");
            PreparedStatement psmt=con.prepareStatement(query);
            psmt.setString(1,carmod);
            ResultSet rs = psmt.executeQuery();
            while(rs.next()){
            %><option value ="<%=rs.getInt("ProductID")%>"  <%
              if(request.getParameter("carmodel") !=null){
                if(rs.getInt("ProductID")==Integer.parseInt(request.getParameter("carmodel")))
               {
                  out.print("Selected");
               }
            }
            %>><%=rs.getString("carmodel")%></option><%
          }
        }catch(Exception e){
            e.printStackTrace();
          }%>
      </select>

      </p>

      <table class="table table-bordered table-striped" style="width: 90%">
      <tr>
          <th>CarID</th>
          <th>Image</th>
          <th>Car Make</th>
          <th>Car Model</th>
          <th>Car Description</th>
          <th>Start Date</th>
          <th>End Date</th>

      </tr>

      <%

      try{
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection con= DriverManager.getConnection("jdbc:mysql://localhost/auction","root","cenk");
        String Query3 ="SELECT ProductID,images,cartype,carmodel,cardetails,startDate,enddate FROM `auction_items` WHERE ProductID=?";
        PreparedStatement psmt=con.prepareStatement(Query3);
            psmt.setString(1,request.getParameter("carmodel"));
            ResultSet rs = psmt.executeQuery();

            while(rs.next()){
            %>
              <tr>
                <td><%=rs.getInt("ProductID")%></td>
                <td><%=rs.getString("images")%></td>
                <td><%=rs.getString("cartype")%></td>
                <td><%=rs.getString("carmodel")%></td>
                <td><%=rs.getString("cardetails")%></td>
                <td><%=rs.getString("startDate")%></td>
                <td><%=rs.getString("enddate")%></td>
              </tr>
            <%

          }
      }
      catch(Exception e){
        e.printStackTrace();
    }


      %>


    </table>

    </center>
    </form>

  </body>
</html>