1.新建Java Enterprise项目,在java下新建相关软件包,并将web项目导入
2.新建数据库表,新建实例,编写数据库连接工具类和数据库关闭连接工具类,测试
package pojo;
public class t_user {
private int id;
private String username;
private String password;
private String email;
public t_user() {
}
public t_user(int id, String username, String password, String email) {
this.id = id;
this.username = username;
this.password = password;
this.email = email;
}
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;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
@Override
public String toString() {
return "t_user{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
", email='" + email + '\'' +
'}';
}
}
public class JDBCUtils {
/**
* 数据库连接工具类
*/
private static DataSource dataSource;
static {
try {
Properties properties=new Properties();
properties.load(ClassLoader.getSystemClassLoader().getResourceAsStream("jdbc.properties"));
//properties.load(JDBCUtils.class.getClassLoader().getResourceAsStream("jdbc.properties"));
System.out.println(properties.getProperty("username"));
dataSource= DruidDataSourceFactory.createDataSource(properties);
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection connection=null;
try {
connection = dataSource.getConnection();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
return connection;
}
/**
* 数据库关闭工具类
*/
public static void getConnectionClose(Connection connection){
if (connection!=null){
try {
connection.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
driverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/bookproject?useUnicode=true&characterEncoding=UTF8&serverTimezone=UTC
username=root
password=123456
注:idea2020版本后,在Java Enterprise项目中,在写jdbc.properties时,默认路径不放在src之下,要放到resources目录下,并将resources提升为根路径。不然空指针异常。
流程:https://blog.csdn.net/FoverLove1314/article/details/118991697
步骤:
1.右击resources-->Mark Directory as点击-->Resources Root
2.在 File -->Project Structure–>Modules–>Resources 中找到resources目录-->右击选中Resources-->OK
3.编写通用的增删改和查询语句,用于灵活调用
注:abstract和接口和实现类关系:实现类继承abstract实现接口
public abstract class BaseDao {
QueryRunner queryRunner=new QueryRunner();
/**
* 通用的增、删、改方法
*/
public int update(String sql,Object ...args){
Connection