//home.jsp作业(index、userbean与register一样)
<%@ page import="java.sql.ResultSet" %><%--
Created by IntelliJ IDEA.
User: 和
Date: 2020/10/7
Time: 8:02
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<%
//加载数据库驱动
Class.forName("com.mysql.jdbc.Driver" ) ;
//建立数据库连接
String url="jdbc:mysql://localhost:3306/whd";//数据库链接地址
Connection connection= DriverManager.getConnection(url,"root","root");
//使用Statement对象执行sql语句
Statement stmt=connection.createStatement();
//stmt.executeUpdate() 执行曾删改操作的函数
String sql="select * from whd";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
out.print(rs.getString("username")+"-"+rs.getString(3)+"<br>");
}
%>
</body>
</html>
//截图