DBUtils

2011-11-20 20:58 7人阅读 评论(0) 收藏 举报

DBUtils

环境搭建：

1、 复制库文件

c3p0的jar及c3p0-config.xml

dbuitls的jar包

mysql驱动包

2、复制并修改DBManager

CRID

插入

public void insert() throws SQLException{ QueryRunner runner = new QueryRunner(DBManager_c3p0.getDataSource()); String sql = "insert into user(id,name,password,email,birthday) values(null,?,?,?,?)"; Object[] param={"by","sss","by@wer.com","1980-03-04"}; runner.update(sql, param); }

删除

public void delete() throws SQLException{ QueryRunner runner = new QueryRunner(DBManager_c3p0.getDataSource()); String sql = "delete from user where name=?"; Object[] param ={"by"}; runner.update(sql, param); }

查询

public User find() throws SQLException{ QueryRunner runner = new QueryRunner(DBManager_c3p0.getDataSource()); String sql = "select * from user where id=?"; User u = (User)runner.query(sql, new BeanHandler(User.class),1); return u; }

public void getAll() throws SQLException{ QueryRunner runner = new QueryRunner(DBManager_c3p0.getDataSource()); String sql = "select * from user"; List<User> list = (List<User>) runner.query(sql, new BeanListHandler(User.class)); System.out.println(list.size()); }

批处理

public void bath() throws SQLException{ QueryRunner runner = new QueryRunner(DBManager_c3p0.getDataSource()); String sql = "insert into user(id,name,password) values(?,?,?)"; Object[][] params = {{5,"Jake","aaa"},{6,"John","bbb"},{7,"Jansen","ccc"}}; runner.batch(sql, params); }