<%-- Created by IntelliJ IDEA. User: Jason Date: 2022/4/6 Time: 10:22 To change this template use File | Settings | File Templates. --%> <%@ page language="java" import="java.sql.Connection" contentType="text/html; charset=UTF-8" pageEncoding="GB18030" import="java.sql.*"%> <% String driverClass="com.mysql.jdbc.Driver"; String url="jdbc:mysql://localhost:3306/data";//<数据库名称> String user="root"; String password="123456"; try{ Class.forName(driverClass); Connection conn; conn=DriverManager.getConnection(url, user, password); Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery("select * from student"); while(rs.next()){ %> <% } stmt.close(); conn.close(); }catch (Exception ex){ System.out.println("找不到驱动"); ex.printStackTrace(); } %>

code	sex	name	age
<%=rs.getString("code")%>	<%=rs.getString("sex")%>	<%=rs.getString("name")%>	<%=rs.getString("age")%>