new34.jsp
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
String driverName = "com.mysql.jdbc.Driver";
String userName = "root";
String userPwd = "mysql123";
String dbName = "test";
String url = "jdbc:mysql://localhost:3306/" + dbName + "?useUnicode=true&characterEncoding=utf8";
Class.forName(driverName);
Connection conn = DriverManager.getConnection(url,userName,userPwd);
String sql = "select * from stu_info where weight >=? and weight <=?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, 60);
pstmt.setInt(2, 80);
ResultSet rs = pstmt.executeQuery();
rs.last();
out.print("查询体重在60到80斤之间的学生有" + rs.getRow() +"条记录。<br>");
rs.beforeFirst();
out.print("<table border='1' style='width:60%;text-align:center;'>");
out.print("<tr>");
out.print("<td>编号</td><td>姓名</td><td>性别</td><td>年龄</td><td>体重</td><td>身高</td>");
out.print("</tr>");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+ rs.getInt("id") + "</td>");
out.print("<td>"+ rs.getString("name") + "</td>");
out.print("<td>"+ rs.getString("sex") + "</td>");
out.print("<td>"+ rs.getString("age") + "</td>");
out.print("<td>"+ rs.getString("weight") + "</td>");
out.print("<td>"+ rs.getString("height") + "</td>");
out.print("</tr>");
}
out.print("</table>");
if(rs != null)
{
rs.close();
}
if(pstmt != null)
{
pstmt.close();
}
if(conn != null)
{
conn.close();
}
%>
</body>
</html>
