/** * 执行sql更新语句 * * @param sql * @param params * @return * @author LiuKun * @created 2012-8-2 上午10:05:47 */ @Transactional public Integer executeUpdate(String sql, Object... params) { Integer count = null; count = JDBCUtil.executeUpdate(baseDao.getConnection(), sql, params); return count; }
/** * 执行sql查询语句 * * @param sql * @param pageInfo * @param params * @return * @author LiuKun * @created 2012-8-2 上午10:05:23 */ @Transactional public List<Map<String, Object>> executeQuery(String sql, PageInfo pageInfo, Object... params) { List<Map<String, Object>> mapList = null; mapList = JDBCUtil.executeQuery(baseDao.getConnection(), sql, pageInfo, params); return mapList; }