涉及内容
涉及内容:
Spring jdbc,
druid配置,
JDBCUtils工具类,
BeanUtils工具类
Servlet等.
1 准备工作
1.1 创建javaEE web项目
1.2 导入HTML页面,登陆页面login.html
//web/login.html
<body>
<form action="/loginServlet" method="post">
username<input type="text" name="username"><br>
password<input type="text" name="password"><br>
<input type="submit" value="提交">
</form>
</body>
1.3 jdbc druid配置文件
# src根目录下: druid.properties
driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/account
username=root
password=root@123
# 初始化连接数
initialSize=5
# 最大连接数
maxActive=10
# 等待超时时间
maxWait=1000
1.4 导入jar包
右键 - > add as Library
依赖包 | 包连接 |
---|---|
spirng jdbc | https://download.csdn.net/download/weixin_44084661/12657503 |
druid-1.1.23.jar | https://download.csdn.net/download/weixin_44084661/12656167 |
mysql-connector-java | https://download.csdn.net/download/weixin_44084661/12646068 |
commons-beanutils-1.9.4.jar | https://download.csdn.net/download/weixin_44084661/12663604 |
1.5 准备数据库
CREATE TABLE user (
`id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
`username` VARCHAR ( 128 ) NOT NULL,
`password` VARCHAR ( 128 ) NOT NULL
);
INSERT INTO `user` VALUES(null,"admin","admin");
2. 代码实施
2.1 实例化数据库
// src.domain.User 生成getter / setter , toString方法 (快捷键command + n)
package domain;
public class User {
private Integer id;
private String username;
private String password;
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
public Integer getId() {
return id;
}
public void setId(Integer