QueryRunner使用方法

第一步获取连接:
MyDButil工具类自己配这里不多说,一般使用C3P0连接池

QueryRunner qr = new QueryRunner(MyDButil.getDataSource());

第二步:增删改查:

增:

String sql = "insert into user value(?,?,?)";
Object [] ob = {"abc","ddd","rrrr"};
int update = qr.update(sql, ob);//插入成功返回1

删:

String sql = "delete from  user  where id=?";
        Object [] ob = {39};
        int update = rq.update(sql, ob);

改:

String sql = "update user set upsw=? where id=?";
        Object [] ob = {"123",39};
        int update = rq.update(sql, ob);

查:
查询有很多,也是最重要的

第一种普通查询:

String sql = "select * from user";
List<User> query = rq.query(sql, new BeanListHandler<User>(User.class));

第二种条件查询

String sql = "select * from user where uid=?";
User query = rq.query(sql, new BeanHandler<User>(User.class), ob);

第三种数量查询

    String sql = "select count(*) from user where upsw=?";
    Object ob[] ={123};
    Long count = (Long) rq.query(sql, new ScalarHandler(), ob);

第四种Map映射查询:
适合做联合查询

List<Map<String, Object>> query = rq.query(sql, new MapListHandler(), ob);

第五种
要哪行就要返回哪里的结果集

List<Object> query = rq.query(sql, new ColumnListHandler("uname", ob);