日期:2014-05-16 浏览次数:20458 次
<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" onfocus="new WdatePicker(this)"> <input type="text" name="b" onfocus="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>
?