JSP + Servlet + JDBC + Mysql 简单实现增删改查

源码下载：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(