这个模块是跟着b站里的尚硅谷一边学一边模仿做的,在这里只是列一下在这个过程中我自己遇到的问题
这次开发使用c3p0作为JDBC连接池,所需要的jar包有:
jar包下载链接:(https://download.csdn.net/download/flypang0126/12500779)
这里列出的jar包只会有多无少,有些是后续开发要用到的,大家参考着用
开发思路:
**用户通过HTML页面发送请求给servlet层—>servlet层调用service方法–>service层调用DAO层方法–>调用Bean层对应数据库字段
所以我们应该从最底层开发,先编写Bean层
package com.fly.bean;
/*
* 对应数据库中的user表
* id INT(11) PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(100) NOT NULL UNIQUE,
PASSWORD VARCHAR(100) NOT NULL,
tel VARCHAR(100)
*/
public class User {
private Integer id;
private String username;
private String password;
private String tel;
@Override
public String toString() {
return "User [id=" + id + ", username=" + username + ", password=" + password + ", tel=" + tel + "]";
}
public User() {
super();
// TODO Auto-generated constructor stub
}
public User(Integer id, String username, String password, String tel) {
super();
this.id = id;
this.username = username;
this.password = password;
this.tel = tel;
}
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;
}
public String getTel() {
return tel;
}
public void setEmail(String tel) {
this.tel = tel;
}
}
BaseDao
package com.fly.dao;
import java.util.List;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.junit.runners.