<%@ page language=“java” contentType=“text/html; charset=UTF-8” pageEncoding=“UTF-8”%> <%@ page language=“java” import=“java.sql.Connection” %> <%@ page language=“java” import=“java.sql.Statement” %> <%@ page language=“java” import=“java.sql.ResultSet” %> <%@ page language=“java” import=“java.sql.DriverManager” %> <%@ page language=“java” import=“java.sql.SQLException” %>
<% Connection con=null; Statement sql=null; ResultSet rs=null; String url=“jdbc:mysql://localhost:3306/student1”;//（数据库名字） String pass="******";//（数据库密码） String name=“root”; try { con=DriverManager.getConnection(url,name,pass);//连接数据库 } catch (SQLException e) {
e.printStackTrace();}
try { sql = (Statement) con.createStatement(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }
rs=sql.executeQuery(“select * from studentinfo”); while(rs.next()){ String name1=rs.getString(1); String pass1=rs.getString(2); String sex=rs.getString(3); String num=rs.getString(4); out.print(name1);out.print(" “); out.print(pass1);out.print(” “); out.print(sex);out.print(” “); out.println(num);out.print(” "); %> 姓名：<%=name1 %> 密码：<%=pass1 %> 性别：<%=sex %> 学号：<%=num %>
<% } %>
<% con.close();%>
