Cookie和Session在实际场景中就常见的应用
1.创建数据库
CREATE DATABASE `hjb_user_manage` DEFAULT CHARACTER SET utf8mb4 ;
-- 指定 utf8mb4 是为了保存中文信息
CREATE TABLE `hjb_user_manage`.`users` (
`uid` INT NOT NULL AUTO_INCREMENT,
`username` VARCHAR(50) NOT NULL,
`password` VARCHAR(50) NOT NULL,
PRIMARY KEY (`uid`),
UNIQUE INDEX `username_UNIQUE` (`username` ASC));//唯一性索引
2.导入JDBC依赖
public class dbUtil {
private static final DataSource dataSource;
static {
MysqlDataSource mysqlDataSource = new MysqlDataSource();
mysqlDataSource.setUrl("jdbc:mysql://127.0.0.1:3306/hjb_user_manage?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai");
mysqlDataSource.setUser("root");
mysqlDataSource.setPassword("123456");
// 3. 尽量使用接口而不是实际类
dataSource = mysqlDataSource; // 就本代码而言,这句意义不大
}
public static Connection connection() throws SQLException {
return dataSource.getConnection();
}
}