时间：字符串行转时间类型

最新推荐文章于 2024-08-31 18:07:02 发布

xiaoxiaoniaoQ

最新推荐文章于 2024-08-31 18:07:02 发布

阅读量169

点赞数

分类专栏：技术

本文链接：https://blog.csdn.net/xiaoxiaoniaoQ/article/details/90374227

版权

技术专栏收录该内容

33 篇文章 0 订阅

订阅专栏

public class SpaceCountQuery {
	
	/**
	 * 空间名称
	 */
	private Long spaceId;
	
	/**
	 * 统计时间
	 */
	private String startTime;
	
	/**
	 * 统计结束时间
	 */
	private String endTime;

public DeviceUsedInfoStatCount getUsedInfoStatCount(
           @RequestBody SpaceCountQuery spaceCountQuery) throws ParseException{
       logger.info("invoke:device-service: getUsedInfoStatCount(),param="+
           JSON.toJSONString(spaceCountQuery));
       DeviceUsedInfoStatCount deviceUsedInfoStatCount = new DeviceUsedInfoStatCount();
       if (null==spaceCountQuery.getStartTime() || null == spaceCountQuery.getEndTime() ) {
           return deviceUsedInfoStatCount;
       }
       //string date to java date
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date startDateTime = sdf.parse(spaceCountQuery.getStartTime());
Date endDateTime = sdf.parse(spaceCountQuery.getEndTime());
       List<Object> countList = usedInfoDetailService.getUsedInfoStatCount(
               spaceCountQuery.getSpaceId().intValue(), startDateTime, endDateTime);

@Query(value = "SELECT user_register_type,COUNT(*) FROM table_device_used_info "+
       "WHERE device_num IN (SELECT device_num FROM table_device_room_relation "+
       "WHERE object_type=1 AND relational_object_id=:spaceId) "+
       "and unlock_time >= :startTime and unlock_time <= :endTime "+
       "GROUP BY user_register_type", nativeQuery = true)
   List<Object> getUsedInfoStatCount(@Param(value="spaceId") Integer spaceId,
           @Param(value="startTime") Date startTime,@Param(value="endTime") Date endTime);

=======================

字符串行转时间类型