1.概述
2.实现增删改操作
2.1 添加操作
// 测试插入语句
@Test
public void test1() {
Connection conn= null;
try {
QueryRunner runner=new QueryRunner();
conn = JDBCUtils2.getConnection3();
String sql="insert into customers(name,email,birth) values(?,?,?)";
runner.update(conn,sql,"ccc","ccc.com","2020-12-09");
} catch (Exception e) {
e.printStackTrace();
}finally {
JDBCUtils.closeResource(conn,null);//ps的连接封装在queryrunner里面,关闭也在里面
// 这里关闭资源只是范湖到数据库连接池并不是真正的关闭
}
}
2.2 删除操作
// 测试删除语句
@Test
public void test2() {
Connection conn= null;
try {
QueryRunner runner=new QueryRunner();
conn = JDBCUtils2.getConnection3();
String sql="delete from customers where id=?";
runner.update(conn,sql,48);
} catch (Exception e) {
e.printStackTrace();
}finally {
JDBCUtils.closeResource(conn,null);
}
}
2.3 更改操作
// 测试更改语句
@Test
public void test3(){
Connection conn=null;