//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>//截图
