6.29网页注册登录与注销

工具类

package com.z0629.util;

import java.sql.*;

public class DBUtil {
   
    private static String url;
    private static String user;
    private static String password;
    private static String driver;
    public static Connection getConnection() throws SQLException, ClassNotFoundException {
   
        Class.forName("com.mysql.jdbc.Driver");
        System.out.println("连接数据库");
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test1", "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();
        }
    }
}

用户类

package com.z0629.model;

public class User {
   
    public int id;
    public String name;
    public String password;
    public 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;
    }
}

传递类

package com.z0629.dao;

import com.z0629.model.User;
import com.z0629.util.DBUtil;

import java.sql.Connection;
import java.sql.PreparedS