Servlet实现简单的注册和删除

配置Tomcat，导入jar包并使用

创建数据库

在IDEA里建立user实体类

package com.zr0629.model;

public class User {
   
    private int id;
    private String name;
    private String password;
    private String age;

    public int getId() {
   
        return id;
    }
    public void setId(int id) {
   
        this.id = id;
    }
    public String getName() {
   
        return name;
    }
    public void setName(String name) {
   
        this.name = name;
    }
    public String getPassword() {
   
        return password;
    }
    public void setPassword(String password) {
   
        this.password = password;
    }
    public String getAge() {
   
        return age;
    }
    public void setAge(String age) {
   
        this.age = age;
    }

    @Override
    public String toString() {
   
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", password='" + password + '\'' +
                ", age='" + age + '\'' +
                '}';
    }


}

建立DBUtil方法类

package com.zr0629.util;

import java.sql.*;

public class DBUtil {
   
    public static Connection getConnection() throws SQLException, ClassNotFoundException {
   
        Class.forName("com.mysql.jdbc.Driver");
        System.out.println("连接数据库");
        //创建连接
        Connection connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/testtt?useSSL=false","root","123456");
        return connection;
    }

    public static void closeAll(ResultSet rs, Statement stmt,Connection conn) throws SQLException {
   
        if (rs!=null){
   
            rs.close();
        }
        if (stmt!=null){
   
            stmt.close();
        }
        if (conn!=null){
   
            conn.close();
        }
    }


}

建立Userdao方法类

package com.zr0629.dao;

import com.