源码下载:https://download.csdn.net/download/johnfht/12201202
一,准备
1,工具
IDE:IntelliJ IDEA
数据库:mysql
数据库操作工具:Navicat for MySQL
2,数据表
3,项目结构
二,后端代码
1,数据库工具 DBUtil.java
package com.util;
import java.sql.*;
/**
* 数据库工具
*/
public class DBUtil {
private static String dbUrl = "jdbc:mysql://localhost:3306/javawebdemo"; //数据库地址
private static String dbUser = "root"; //数据库用户
private static String dbPwd = "123456"; //数据库密码
private static String dbDriver = "com.mysql.jdbc.Driver"; //数据库驱动
private static Connection conn = null;
//获取连接
public static Connection getConn(){
if(null == conn){
try {
Class.forName(dbDriver);
conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
return conn;
}
/*//测试
@Test
public void test(){
if(getConn() != null){
System.out.println("数据库连接成功");
}else{
System.out.println("数据库连接失败");
}
}*/
}
2,实体类 User.java
package com.domain;
/**
* 用户实体类
*/
public class User {
private int id;
private String username;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
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;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}
3,数据库交互 dao层 UserDao.java
package com.dao;
import com.domain.User;
import com.util.DBUtil;
import org.junit.Test;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
/**
* 数据库交互 dao层
*/
public class UserDao {
public List<User> getAllUser(){
List<User> list = new ArrayList<>();
Connection conn = DBUtil.getConn();
String sql = "select * from user";
try {
PreparedStatement pst = conn.prepareStatement(sql);
ResultSet rs = pst.executeQuery();
while(rs.next()){
User user = new User(