mysql datetime类型，java查询时比较

最新推荐文章于 2024-07-03 03:07:06 发布

人间无味98727

最新推荐文章于 2024-07-03 03:07:06 发布

阅读量1.3k

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/yuke98727/article/details/73550379

版权

java 专栏收录该内容

65 篇文章 1 订阅

订阅专栏

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

String startTimeStr="1483203661";

String endTimeStr="1496700366";

Long starTimesStamp = new Long(Integer.parseInt(startTimeStr));
Long endTimesStamp = new Long(Integer.parseInt(endTimeStr));
Date star = new Date(starTimesStamp*1000);
Date end = new Date(endTimesStamp*1000);

Pager pager = new Pager();
pager.getQuery().put("startTime",sdf.format(star));
pager.getQuery().put("endTime", sdf.format(end));

List<OrderInfo> orderInfoList = orderWebService.findOrderInfoByPager(pager).getData();
public List<OrderInfo> findOrderInfoByPager(Pager pager) throws ParseException {
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    List<Criterion> criterionList = new ArrayList<Criterion>();
    String startTime = (String) pager.getQuery().get("startTime");
    String endTime = (String) pager.getQuery().get("endTime");
    if (StringUtils.isNotEmpty(startTime)){
        Date start = sdf.parse(startTime);
        criterionList.add(Restrictions.gt("updated", start));
    }
    if (StringUtils.isNotEmpty(endTime)){
        Date end = sdf.parse(endTime);
        criterionList.add(Restrictions.lt("updated", end));
    }
    
    Criterion[] criterions = new Criterion[criterionList.size()];
    criterionList.toArray(criterions);
    List<OrderInfo> list = this.getDao().load(criterions);
    
    return list;
}