コード例 #1
0
 /**
  * 获取总数
  *
  * @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;
 }
コード例 #2
0
  /**
   * 查询信息
   *
   * @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;
  }