<%@ page import="java.sql.ResultSet" %>
<%@ page import="com.mole9630.DBUtil" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
显示学生信息
<%
String sql = "select * from student_info";
DBUtil db = new DBUtil();
ResultSet rs = db.querySql(sql);
out.print("" +
"学生信息");
out.print("" +
"| 学号 | " +
"姓名 | " +
"性别 | " +
"生日 | " +
"
");
while (rs.next()){
out.print("" +
"| "+rs.getInt(1)+" | " +
""+rs.getString(2)+" | " +
""+rs.getString(3)+" | " +
""+rs.getString(4)+" | ");
}
out.print("
");
try{
if (rs!=null) rs.close();
}catch (Exception e){
e.printStackTrace();
}
%>