/** * 获取总数 * * @return */ public int queryMsgInfoCount(Map<String, Object> queryParamsMap) { int querNum = 0; StringBuilder querySQL = new StringBuilder("SELECT count(*) FROM activity_manager_info WHERE 1=1 "); querySQL.append(DBQueryCommUtil.getQueryConStr(queryParamsMap)); try { querNum = jdbcTemplate.queryForInt( querySQL.toString(), DBQueryCommUtil.getQueryConParams(queryParamsMap)); } catch (Exception e) { log.error("Query Count activity_manager_info Error:", e); } return querNum; }
/** * 查询信息 * * @return */ public List<Map<String, Object>> queryMsgInfoList( int pageNum, int pageSize, Map<String, Object> queryParamsMap) { List<Map<String, Object>> returnList = new ArrayList<Map<String, Object>>(); StringBuilder querySQL = new StringBuilder("SELECT * FROM activity_manager_info WHERE 1=1 "); querySQL.append(DBQueryCommUtil.getQueryConStr(queryParamsMap)); querySQL.append(" ORDER BY act_start_time DESC"); try { String realQuerySQL = DBQueryCommUtil.packageSQL(querySQL.toString(), pageNum, pageSize); returnList = jdbcTemplate.queryForList( realQuerySQL, DBQueryCommUtil.getQueryConParams(queryParamsMap)); } catch (Exception e) { log.error("Query activity_manager_info Error:", e); } return returnList; }