<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>查询页面提交页面</title>
</head>
<body>
请选择查询条件<hr width="100%" size="3">
<form action="查询条件2.jsp">
性别:男<input type="radio" value="男" name="sex" checked="checked">
女<input type="radio" value="女" name="sex"><br><br>
体重范围:<p>    
最小<input type="text" name="w1" value="0"><br><br>
    
最大<input type="text" name="w2" value="150"><p>
<input type="submit" value="提交">
       
<input type="reset" value="取消">
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>由提交页面获取查询条件并实现查询的页面</title>
</head>
<body>
<center>
<%
String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String user="sa";
String password="zqb19971023";
String url="jdbc:sqlserver://localhost:1433;DatabaseName=666";
Connection conn=null;
try{
Class.forName(driver);
conn=DriverManager.getConnection(url, user, password);
System.out.println("连接成功");
}catch(Exception e)
{
System.out.println("连接失败");
}
request.setCharacterEncoding("UTF-8");
String sex=request.getParameter("sex");
float weight1=Float.parseFloat(request.getParameter("w1"));
float weight2=Float.parseFloat(request.getParameter("w2"));
String sql="select * from stu1 where sex=? and weight>=? and weight<=?";
PreparedStatement pstmt=conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
pstmt.setString(1, sex);
pstmt.setFloat(2, weight1);
pstmt.setFloat(3, weight2);
ResultSet rs=pstmt.executeQuery();
rs.last();
%>
你要查询的学生数据表共有
<font size="5" color="red"><%=rs.getRow() %></font>人
<table border="2" bgcolor="ccceee" width="650">
<tr bgcolor="CCCCCC" align="center">
<td>记录条数</td><td>学号</td><td>姓名</td><td>性别</td>
<td>年龄</td><td>学体重</td><td>身高</td>
</tr>
<%
rs.beforeFirst();
while(rs.next()){ %>
<tr align="center">
<td><%=rs.getRow() %></td>
<td><%=rs.getString("id") %></td>
<td><%=rs.getString("name") %></td>
<td><%=rs.getString("sex") %></td>
<td><%=rs.getString("age") %></td>
<td><%=rs.getString("weight") %></td>
<td><%=rs.getString("hight") %></td>
</tr>
<%
} %>
</table>
</center>
<%
if(rs!=null) rs.close();
if(pstmt!=null) pstmt.close();
if(conn!=null) conn.close();
%>
</body>
</html>