JdbcTemplate是spring在数据库操作jdbc上进行封装的模板。
BaseDao 是dao和JdbcTemplate的封装
常用方法
execute执行所有sql
query执行查询sql
1.execute() (返回类型:int)
baseDao.execute("update user set openId = null where openId = :openId ", ImmutableMap.of("openId", openId));
2.queryForListMap () (返回类型:List< Map< String, Object>> )
baseDao.queryForListMap(sql, param);
3.queryForObjectMap() (返回类型:Map< String, Object> )
Map<String, Object> map = baseDao.queryForObjectMap(sql, param);
4.queryForInteger() (返回类型:Integer )
baseDao.queryForInteger("select count(*) from (" + field + sql.toString() + ") a", param)
5.queryForListLimit() (分页)
List<Map<String, Object>> expandList = baseDao.queryForListLimit(field + sql.toString(), param, page.getPageNum(), page.getPageSize());
6.queryForBeanList()
List<User> users = baseDao.queryForBeanList("select * from user where idcard=:idcard ", ImmutableMap.of("idcard",
idCard), new User());