第一步:导包
<dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.13</version> </dependency>
第二步:mapper层
List<User> getAll(Map<String,Object> map);
第三步:mapper.xml文件
<select id="getAll" resultType="user" parameterType="map"> select * from library.user <where> <if test="username!=null and username !=''"> and username like concat('%',#{username},'%') </if> <if test="password!=null and password !=''"> and password like concat('%',#{password},'%') </if> </where> </select>
第四步:controller层
@GetMapping("/getAll") public HashMap<String, Object> getAll(@RequestParam Integer pageNum,@RequestParam Integer pageSize ,@RequestParam String username ,@RequestParam String password){ //查询分页后的所有数据 HashMap<String, Object> hashMap = new HashMap<>(); hashMap.put("username",username); hashMap.put("password",password); PageHelper.startPage(pageNum,pageSize); List<User> list = userService.getAll(hashMap); PageInfo<User> PageInfo = new PageInfo<>(list); HashMap<String, Object> map = new HashMap<>(); map.put("data",PageInfo.getList()); map.put("total",PageInfo.getTotal());//获得总条数 return map; }
前端是用vue-element框架