1.创建UserBeen.java
package com.media.been;
public class UserBeen {
private String username;
private String password;
private int gender;
private int age;
private int status;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getGender() {
return gender;
}
public void setGender(int gender) {
this.gender = gender;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public int getStatus() {
return status;
}
public void setStatus(int status) {
this.status = status;
}
}
2.创建home.jsp
<%@page import="java.sql.Connection" %>
<%@page import="java.sql.Statement" %>
<%@page import="java.sql.DriverManager" %>
<%@page import="com.media.been.UserBeen" %>
<%@ page import="java.sql.ResultSet" %>
<%--
Created by IntelliJ IDEA.
User: j
Date: 2020/10/7
Time: 8:01
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/book";//数据库连接地址
Connection connection=DriverManager.getConnection(url,"root","root");//第一个root为数据库的用户名，第二个root为数据库的密码
//使用Statement对象执行sql语句
Statement stmt=connection.createStatement();
//stmt.executeUpdate()执行增删改操作的函数
String sql="select * from user";
ResultSet rs=stmt.executeQuery(sql);//执行查询的函数 返回结果集
while (rs.next()){
out.print(rs.getString("usename")+"-"+rs.getString(3)+"<br>");
}
%>
</body>
</html>
4.运行结果
http://localhost:8080/untitled3_war_exploded/home.jsp
