//collection="zt_message_carousel"即為mongodb庫中的文檔名字
@Document(collection="zt_message_carousel")
public class CarouselInfo {
    //創(chuàng)建索引
    @Indexed(unique = true)
    @Id
    private String id;
    private String type;
    private String title;
    private String clickUrl;
    private String photoUrl;
    private Integer platformId;
    private String systemId;
    private Integer sort;
    private int state;
    private String creator;
    private Date createTime;
    private Date updateTime;
}

//添加操作比較簡單,創(chuàng)建對象,設置參數(shù),調用api即可
        CarouselInfo info = new CarouselInfo();
        //設置參數(shù)
        info.setId(UUIDUtil.getUuid());
        info.setSystemId(params.getSystemId());
        info.setPlatformId(params.getPlatformId());
        info.setTitle(params.getTitle());
        info.setType(params.getType());
        info.setClickUrl(params.getClickUrl());
        info.setCreator(params.getCreator());
        info.setPhotoUrl(params.getPhotoUrl());
        info.setCreateTime(new Date());
        //調用方法,完成添加,并返回添加成功的數(shù)據(jù)
        CarouselInfo carouselInfo = mongoTemplate.save(info);

		//創(chuàng)建查詢
		Query query = new Query();
		//設置條件
        Criteria criteria = new Criteria();
        List<String> list = Arrays.asList(ids.split(","));
        criteria.and("systemId").is(systemId);
        criteria.and("platformId").is(platformId);
        //這里用的是in,也可以是ID,刪除一條,靈活使用
        criteria.and("id").in(list);
        query.addCriteria(criteria);
        //調用方法,DeleteResult中可以獲取到刪除的條數(shù)
        DeleteResult remove = mongoTemplate.remove(query, CarouselInfo.class);

		//創(chuàng)建查詢,主要是用來定位要修改的對象
		Query query = new Query();
        Criteria criteria = new Criteria();
        criteria.and("systemId").is(params.getSystemId()).and("platformId").is(params.getPlatformId()).and("id").is(params.getId());
        query.addCriteria(criteria);
        //創(chuàng)建Update,修改設置,給查詢到的對象,對應的字段設置新值,和sql異曲同工
        Update update = new Update().set("title", params.getTitle()).set("type", params.getType()).set("photoUrl", params.getPhotoUrl()).set("updateTime",new Date());
        //執(zhí)行修改操作,返回修改成功的條數(shù)
        UpdateResult res = mongoTemplate.updateFirst(query, update, CarouselInfo.class);

//這里是把查詢條件寫在了方法內,也可提取出來,也可以使用find()方法,返回的就是一個List集合
CarouselInfo info = mongoTemplate.findOne(new Query(Criteria.where("systemId").is(systemId).and("platformId").is(platformId).and("id").is(id)), CarouselInfo.class);

		//創(chuàng)建查詢,查出此條件下,總記錄數(shù)
		Query query = new Query();
        Criteria criteria = new Criteria();
        criteria.and("systemId").is(params.getSystemId());
        criteria.and("platformId").is(params.getPlatformId());
        if (StringUtils.isNotBlank(params.getTitle())) {
            criteria.and("title").is(params.getTitle());
        }
        if (StringUtils.isNotBlank(params.getType())) {
            criteria.and("type").is(params.getType());
        }
        if (params.getState() != null) {
            criteria.and("state").is(params.getState());
        }
        query.addCriteria(criteria);
        int count = mongoTemplate.find(query, CarouselInfo.class).size();
        
        // 分頁查詢
        params.setCurPage(params.getCurPage() == null ? PageParameter.DEFAULT_CURR_PAGE : params.getCurPage());
        params.setPageSize(params.getPageSize() == null ? PageParameter.DEFAULT_PAGE_SIZE : params.getPageSize());
        //此處為第幾頁,從第幾條開始查,公式和sql一樣,根據(jù)業(yè)務自行設置
        query.skip((params.getCurPage() - 1) * params.getPageSize());
        //每頁條數(shù)
        query.limit(params.getPageSize());
        //調用find(),查出符合條件的數(shù)據(jù)
        List<CarouselInfo> carouselInfos = mongoTemplate.find(query, CarouselInfo.class);

	//日期類型的,用gte和lte比較即可,且where條件只應出現(xiàn)一次,所以根據(jù)業(yè)務書寫自己的邏輯即可
    query.addCriteria(Criteria.where("createTime").gte(dateToISODate(new Date(beginTime + 8*60*60*1000))).lte(dateToISODate(new Date(endTime + 8*60*60*1000))));

    /**
     * 將時間戳轉化為mongodb中的ISODate時間類型數(shù)據(jù)
     * @param   dateStr Date類型時間戳
     * @return  parse   ISODate時間
     */
    public static Date dateToISODate(Date dateStr) {
        Date parse = null;
        try {
            // 解析出字符串時間
            SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'");
            parse = format.parse(format.format(dateStr));
        } catch (Exception e) {
            e.printStackTrace();
        }
        return parse;
    }