简单通过jdbc实现对数据库中的表增删改查
-
在此之前,需要先准备好数据库中的表和对象实体类
-
实体类
public class User {
private int userId;
private String username;
private String password;
private int sex;
private int flag;
public int getUserId() {
return userId;
}
public void setUserId(int userId) {
this.userId = userId;
}
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 int getSex() {
return sex;
}
public void setSex(int sex) {
this.sex = sex;
}
public int getFlag() {
return flag;
}
public void setFlag(int flag) {
this.flag = flag;
}
}
- 数据库表(这里数据库名称jdbctest)
CREATE TABLE `user` (
`userId` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(20) DEFAULT NULL,
`password` varchar(100) DEFAULT NULL,
`sex` int(1) DEFAULT '1' COMMENT '1表示男,0表示女',
`flag` int(1) DEFAULT '1' COMMENT '1表示正常,0表示不正常',
PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
-
可以分成三大步骤
1.获取连接
2.产生执行sql语句的对象
3.使用sql对表操作 -
插入代码示例
public class Test01 {
public static void main(String[] args){
String jdbDriver ="com.mysql.jdbc.Driver";
String jdbcURL="jdbc:mysql://localhost:3306/jdbctest";
String jdbcUser="root";
String jdbcPassword="123456";
//获取连接
Connection conn = null;
//加载驱动
try {
Class.forName(jdbDriver);
conn = DriverManager.getConnection(jdbcURL,jdbcUser,jdbcPassword);
System.out.println(conn);
//产生执行sql语句的对象
Statement st=null;
st=conn.createStatement();
//插入一条记录
String sql = "INSERT into user (username,password) VALUES ('xiaoming','123456')";
int rows =st.executeUpdate(sql);
if(rows > 0){
System.out.println("插入数据成功!");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
- 增删改查都是sql语句不同,其他代码都一样
删除操作sql
DELETE from `user` where userId=1
修改操作sql
UPDATE `user` set `password`="1234" where userId=2
查询操作sql
SELECT username,`password`FROM `user`