一、使用c3p0连接数据准备工作
1.工程结构:
2.数据库建表及插入数据:
create table user(
id int auto_increment primary key,
username varchar(50),
password varchar(50)
);
insert into user(username,password) value("小明",123);
insert into user(username,password) value("小王",456);
二、C3P0连接数据库
1.实体类的代码演示:
package com.database3.entity;
public class User {
private int id;
private String username;
private String password;
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;
}
@Override
public String toString() {
return "User [id=" + id + ", username=" + username + ", password="
+ password + "]";
}
}