jsp page

This is the jsp page where the drop down list option had been applied to retrieve and add set of values

   <tr>
    <td>&nbsp;</td>
    <td width="25%">Vehicle Type :-</td>
    <td width="25%">
      <select value="${veh_type}" style="width:115px;" name="slct_V_type" id="slct_V_type">         
        <option>Select a Type</option>
        <option value="Wagon">Wagon</option>
        <option value="Truck">Truck</option>
        <option value="Bus">Bus</option>
        <option value="SUV">SUV</option>
        <option value="Sedan">Sedan</option>
        <option value="Minivan">Minivan</option>
        <option value="Luxury">Luxury</option>
        <option value="Hybrid">Hybrid</option>
        <option value="Hatchback">Hatchback</option>
        <option value="Coupe">Coupe</option>
      </select></td>
    <td width="25%">&nbsp;</td>

    </tr>

     <td width="25%"><input style="width:100px;" type="submit" name="bttnsrch" id="bttnsrch" value="Search" /></td>

Servlet

ere is the servlet search button coding which will pass the data to the database

 if(request.getParameter("bttnsrch")!=null)
        {
            int Reg=Integer.parseInt(request.getParameter("Reg_number"));
            ResultSet rs=SQL.CaptureVehicleInfo(Reg);
            while(rs.next())
            {

                String veh_type=rs.getString(1);
                request.setAttribute("veh_type", veh_type);

                String reg_num=rs.getString(2);
                request.setAttribute("reg_num", reg_num);

                String veh_brand=rs.getString(3);
                request.setAttribute("veh_brand", veh_brand);

                String veh_model=rs.getString(4);
                request.setAttribute("veh_model", veh_model);

                String veh_man_year=rs.getString(5);
                request.setAttribute("veh_man_year", veh_man_year);

                String no_of_seat=rs.getString(6);
                request.setAttribute("no_of_seat", no_of_seat);

                String trasm=rs.getString(7);
                request.setAttribute("trasm", trasm);

                String air_con=rs.getString(8);
                request.setAttribute("air_con", air_con);
            }
            request.getRequestDispatcher("Vehicle_Information.jsp").forward(request, response);
            response.sendRedirect("Vehicle_Information.jsp");
        }

DB Connection

This the SQL statement I created to search vehicle information from the database.

     public ResultSet CaptureVehicleInfo(int Register_number)
   {
       ResultSet rs;
       try
       {
           SQL=createConnection();

           PreparedStatement ps;
           String str="SELECT * FROM vehicle_information WHERE Register_number=?";
           ps=SQL.prepareStatement(str);

           ps.setInt(1, Register_number);


            rs=ps.executeQuery();
            return rs;

       }
       catch(Exception e)
       {
           rs=null;
           return rs;
       }
   }