获取当前月时间以及查询数据库中所有时间为本月的数据

不念不忘少年蓝@ 2024-02-05 19:40 47阅读 0赞

获取当月1号到当前的日期时间

DateTimeFormatter formatter = DateTimeFormat.forPattern("yyyy-MM-dd HH:mm:ss");
     DateTime startTime = DateTime.parse(new SimpleDateFormat("yyyy-MM-01 00:00:00").format(new Date()), formatter);
     DateTime endTime = DateTime.parse(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()), formatter);

案例:查询数据库中当月新增的所有数据

StudentMapper.xml

<select id="select" resultType="java.lang.Integer">
       select count(id) from student where times BETWEEN #{startTime} and #{endTime}
    </select>

StudentMapper.java

Integer select(@Param("startTime") String startTime,@Param("endTime") String endTime);

StudentService.java

Integer select(DateTime startTime, DateTime endTime);

StudentServiceImpl.java

@Override
    public Integer select(DateTime tempStartTime, DateTime TempEndTime) {
       String startTime = tempStartTime.toString("yyyy-MM-dd 00:00:00");
       String endTime = TempEndTime.toString("yyyy-MM-dd 23:59:59");
       return studentMapper.select(startTime,endTime);
    }

StudentController.java

@GetMapping("/number")
    public AjaxResult countStudent(){
            DateTimeFormatter formatter = DateTimeFormat.forPattern("yyyy-MM-dd HH:mm:ss");
            DateTime startTime = DateTime.parse(new SimpleDateFormat("yyyy-MM-01 00:00:00").format(new Date()), formatter);
            DateTime endTime = DateTime.parse(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()), formatter);
            Integer number = studentService.select(startTime, endTime);
            return AjaxResult.success(number);
    }