<form action="second.jsp" method="post">
<select name="type">
<option value="moto">moto</option>
<option value="nokia">nokia</option>
</select>
<input type="text" name="a" οnfοcus="new WdatePicker(this)">
<input type="text" name="b" οnfοcus="new WdatePicker(this)">
<input type="submit" value="ok">
</form>
---------------------------------------B-----------------------------------------------
<%
String a=request.getParameter("a");
String b=request.getParameter("b");
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=shop","sa","sa");
Statement stmt=con.createStatement();
String sql="select * from users where users_date between '"+a+"' and '"+b+"'";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
out.print(rs.getString(2));
}
}
catch(Exception e){
e.printStackTrace();
}
%>
</body>