public class DB_utils {
//获取数据源
private ComboPooledDataSource ds = new ComboPooledDataSource();
//创建QueryRunner对象并且将数据源传给构造方法
private QueryRunner qr = new QueryRunner(ds);
@Test
public void save() throws SQLException {
String sql = "insert into user (username,password,real_name) values (?,?,?)";
int i = qr.update(sql,"mingzi","777","名字");
System.out.println(i);
}
@Test
public void update() throws SQLException {
String sql = "update user set real_name = ? where uid =?";
int i = qr.update(sql,"哈哈哈哈哈哈哈",1);
System.out.println(i);
}
@Test
public void delete() throws SQLException {
String sql = "delete from user where uid =?";
int i = qr.update(sql,1);
System.out.println(i);
}
}