IDEA Javaweb 用户登录案例

1.需求分析

2.开发步骤

1.创建项目

2.导入jar包

jar相关jar的百度云链接：https://pan.baidu.com/s/1PM-A-UOTC3KpGCr-xNMm9w 提取码：80sq

3.配置文件

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql:///db2
username=root
password=root
#初始化连接量
initialSize =5
#最大连接数
maxActive =10
#最大等待时间
maxWait =3000

4.创建数据库环境

CREATE DATABASE db2;
USE db2;
CREATE TABLE USER(
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(32) UNIQUE NOT NULL,
PASSWORD VARCHAR(32) NOT NULL
);

5.创建包com.mimihany.domain,创建类User（用户的实体类）

package com.mimihany.domain;

public class user {
   
    private int id;
    private  String username;
    private  String password;

    public Integer getId() {
   
        return id;
    }

    public void setId(Integer 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 + '\'' +
                '}';
    }
}

6.创建包com.mimihany.util,编写工具类JDBCUtils

package com.mimihany.util;

import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.IOException