利用dbutils框架简化jdbc开发
1.首先要导入要用的jar包
?
commons-dbcp-1.2.2.jar
commons-dbutils-1.2.jar
commons-pool.jar
mysql-connector-java-5.0.8-bin.jar
?
?
2.修改配置文件参考模板：
?
?
?
?
3.java 编写utils工具类public class Demo1 {/* create database day17; use day17; create table users(id int primary key,name varchar(40),password varchar(40),email varchar(60),birthday date); *///使用dbutils完成数据库的crud@Testpublic void insert() throws SQLException{QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());String sql = "insert into users(id,name,password,email,birthday) values(?,?,?,?,?)";Object params[] = {2,"bbb","123","aa@sina.com",new Date()};runner.update(sql, params);}@Testpublic void update() throws SQLException{QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());String sql = "update users set email=? where id=?";Object params[] = {"aaaaaa@sina.com",1};runner.update(sql, params);}@Testpublic void delete() throws SQLException{QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());String sql = "delete from users where id=?";runner.update(sql, 1);}@Testpublic void find() throws SQLException{QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());String sql = "select * from users where id=?";User user = (User) runner.query(sql, 1, new BeanHandler(User.class));System.out.println(user.getEmail());}@Testpublic void getAll() throws Exception{QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());String sql = "select * from users";List list = (List) runner.query(sql, new BeanListHandler(User.class));System.out.println(list);}@Testpublic void batch() throws SQLException{QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());String sql = "insert into users(id,name,password,email,birthday) values(?,?,?,?,?)";Object params[][] = new Object[3][5];for(int i=0;i<params.length;i++){ //3params[i] = new Object[]{i+1,"aa"+i,"123",i + "@sina.com",new Date()};}runner.batch(sql, params);}}??
