Web

创建一个Connection的实例化类：

public class ConnectionManager {
    private static final String DRIVER = "com.mysql.jdbc.Driver";
    private static final String URL = "jdbc:mysql://localhost:3306/xudb";
    private static final String USER = "root";
    private static final String PASSWORD = "1";

    /**
     * 私有化构造方法，拒绝实例化
     */
    private ConnectionManager() {
    }

    /**
     * 获取数据库连接静态方法
     *
     * @return 数据库连接
     */
    public static Connection getConnection() {
        //声明数据库连接
        Connection conn = null;

        try {
            //安装数据库驱动程序
            Class.forName(DRIVER);
            //获取数据库连接
            conn = DriverManager.getConnection(URL,USER,PASSWORD);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }
    /**
     *
     */
    public static void closeConn(Connection conn){
        if (conn != null){
            try {
                if (!conn.isClosed()){
                    conn.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

修改do_login的代码：

创建模型层UserDaojiekou接口：`package net.xu.bean;

/**

• 功能：用户实体类

• 作者：许

• 日期：2019.10.12
  */
  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 + username+’’’+
  “,password=’”+password+’’’+
  ‘}’;
  }
  }`
  创建接口UserDao:
  
  创建UserDaoImpl实现类：