spring boot整合Mybatis如何查询某一时间段内的信息

java总结师

于 2019-01-08 14:35:52 发布

阅读量7.8k

点赞数 8

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/weixin_42172022/article/details/86074551

(我分别用mysql和oracle做)

Mysql数据库

学生表

这里按sdate字段查询

Controller内的代码如下

@RequestMapping(value = "/selectNo", method = RequestMethod.GET)
public String selectstu(HttpServletRequest request, @RequestParam(required = false) String sex, @RequestParam(required = false) String startDate,
                     @RequestParam(required = false) String endDate,@RequestParam(required = false) String cno,@RequestParam int pageNum, @RequestParam int pageSize) {

    try {
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("sex", sex);
        if (null != endDate && !"".equals(endDate)) {
            String startTime = startDate.replace("-", "");
            String endTime = endDate.replace("-", "");
            map.put("startTime", startTime);