/**
* 获取总数
*
* @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;
}