new48.jsp
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@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>
<%
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
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=utf-8";
request.setCharacterEncoding("utf-8");
try
{
Class.forName(driverName);
conn = DriverManager.getConnection(url,userName,userPwd);
String sql = "select * from stu_info";
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
rs.last();
out.print("查询学生表,共有" + rs.getRow() + "条记录!");
rs.beforeFirst();
out.print("<table border='1' style='width:60%'>");
out.print("<tr><td>编号</td><td>姓名</td><td>性别</td><td>年龄</td><td>体重</td><td>身高</td></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.getInt("age") +"</td>");
out.print("<td>" + rs.getFloat("weight") +"</td>");
out.print("<td>" + rs.getFloat("height") +"</td>");
out.print("</tr>");
}
out.print("</tbale>");
}
catch(Exception e)
{
out.print(e.getMessage());
}
finally
{
if(rs != null)
{
rs.close();
}
if(pstmt != null)
{
pstmt.close();
}
if(conn != null)
{
conn.close();
}
}
%>
</body>
</html>