Package com.iqbon.jcms.domain.mapRow

Examples of com.iqbon.jcms.domain.mapRow.PushRecordMapper


    Map<String, Object> map = new HashMap<String, Object>(3);
    map.put("topicid", topicid);
    map.put("begin", begin);
    map.put("size", size);
    SqlParameterSource paramMap = new MapSqlParameterSource(map);
    return namedParameterJdbcTemplate.query(sql, paramMap, new PushRecordMapper());
  }
View Full Code Here


    if(StringUtils.isNotEmpty(endTime)){
      sql += "and last_modify <= :endTime";
      map.put("endTime", endTime);
    }
    sql += " order by add_date desc,lspri desc,last_modify desc limit :limit";
    return namedParameterJdbcTemplate.query(sql, map, new PushRecordMapper());
  }
View Full Code Here

  public PushRecord queryPushRecordById(String indexid) {
    String sql = "select * from bu_push_record where indexid=:indexid";
    Map<String, String> map = new HashMap<String, String>(1);
    map.put("indexid", indexid);
    try{
    return namedParameterJdbcTemplate.queryForObject(sql, map, new PushRecordMapper());
    }catch(EmptyResultDataAccessException e){
      logger.info("根据ID(" + indexid + ")查找推送记录信息为空");
      return null;
    }
  }
View Full Code Here

   * @return
   */
  public List<PushRecord> queryPushRecordsById(List<String> indexidList) {
    String sql = "select * from bu_push_record where indexid in "+indexidList.toString().replace("[", "(").replace("]", ")");
    Map<String, String> map = new HashMap<String, String>(0);
    return namedParameterJdbcTemplate.query(sql, map, new PushRecordMapper());
  }
View Full Code Here

  public List<PushRecord> queryPushRecordByDocid(String docid) {
    Map<String, Object> map = new HashMap<String, Object>();
    map.put("docid", docid);
    String sql = "select indexid,docid,modelname,title,lspri,url,sub_title,add_date,last_modify,modify_user,topicid,type,img "
        + "from bu_push_record where  docid = :docid order by last_modify";
    return namedParameterJdbcTemplate.query(sql, map, new PushRecordMapper());
  }
View Full Code Here

TOP

Related Classes of com.iqbon.jcms.domain.mapRow.PushRecordMapper

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.