分页条件查询

最新推荐文章于 2024-05-28 10:22:46 发布

qq_52479450

最新推荐文章于 2024-05-28 10:22:46 发布

阅读量55

点赞数

文章标签： windows

本文链接：https://blog.csdn.net/qq_52479450/article/details/134064554

版权

本文介绍了如何在SpringBoot项目中，使用EmpMapper接口进行员工数据的分页查询，包括Controller层的HTTP请求处理和Service层对EmpMapper的调用，以及XML配置的SQL查询语句。

摘要由CSDN通过智能技术生成

EmpMapper

 public List<Emp> list(String name, Short gender, LocalDate begin, LocalDate end);

EmpController

@Slf4j
@RestController
public class EmpController {
    @Autowired
private EmpService empService;
    @GetMapping("/emps")
    public Result page(@RequestParam(defaultValue = "1") Integer page,@RequestParam(defaultValue = "10") Integer pageSize,String name,Short gender,@DateTimeFormat(pattern = "yyyy-MM-dd") LocalDate begin,@DateTimeFormat(pattern = "yyyy-MM-dd") LocalDate end){
log.info("分页查询",page,pageSize,name,gender,begin,end);
PageBean pageBean = empService.page(page,pageSize,name,gender,begin,end);
return Result.success(pageBean);
    }



}

EmpService

public interface EmpService {
    PageBean page(Integer page,Integer pageSize,String name,Short gender,LocalDate start,LocalDate end);
}

EmpServiceImpl


@Service
public class EmpServiceImpl implements EmpService {
    @Autowired
    private EmpMapper empMapper;
/*
    @Override
*/

    /*public PageBean page(Integer page, Integer pageSize) {
        Long count = empMapper.count();
        Integer start = (page - 1) * pageSize;
       List<Emp> empList = empMapper.page(start,pageSize);

       PageBean pageBean = new PageBean(count,empList);
       return pageBean;
    }*/

    public PageBean page(Integer page,Integer pageSize,String name,Short gender,LocalDate begin,LocalDate end) {

        PageHelper.startPage(page,pageSize);

        List<Emp> empList = empMapper.list(name,gender,begin,end);
        Page<Emp> p = (Page<Emp>) empList;

        PageBean pageBean = new PageBean(p.getTotal(),p.getResult());
        return pageBean;

    }
}

xml文件配置

<select id="list" resultType="com.yyy.pojo.Emp">
select *
from tlias.emp
<where>
      <if test = "name != null and name != 'nul">
          name like concat('%',#{name},'%')</if>
  <if test = "gender != null">
      and gender = #{gender}</if>
  <if test="begin !=null and end != null">
      and entrydate between #{begin} and #{end}</if>
</where>
order by update_time desc

</select>
</mapper>