目录
1.StudentController.java
@Slf4j
@RestController
@RequestMapping("/students")
public class StudentController {
@Autowired
private StudentService studentService;
// 学员列表查询
@GetMapping
@Operation(summary = "学员列表查询")
public Result page(String name, Integer degree, Integer clazzId,
@RequestParam(defaultValue = "1") Integer page,
@RequestParam(defaultValue = "10") Integer pageSize){
log.info("分页查询:{},{},{},{},{}",name,degree,clazzId,page,pageSize);
PageResult pageResult = studentService.page(name,degree,clazzId,page,pageSize);
return Result.success(pageResult);
}
}
2.interface StudentService
public interface StudentService {
// 学员列表查询
PageResult page(String name, Integer degree, Integer clazzId, Integer page, Integer pageSize);
}
3.StudentServiceImpl.java
@Service
public class StudentServiceImpl implements StudentService {
@Autowired
private StudentMapper studentMapper;
// 学员列表查询
@Override
public PageResult page(String name, Integer degree, Integer clazzId,Integer page,Integer pageSize) {
PageHelper.startPage(page,pageSize);
List<Student> studentList = studentMapper.page(name,degree,clazzId);
Page<Student> p = (Page<Student>) studentList;
return new PageResult(p.getTotal(),p.getResult());
}
}
4.interface StudentMapper
@Mapper
public interface StudentMapper {
// 学员列表查询
List<Student> page(String name, Integer degree, Integer clazzId);
}
5.StudentMapper.java
<!--学员列表查询-->
<select id="page" resultType="org.gdcp.tliassystemdemo.pojo.Student">
select s.*, c.name clazzName from student s left join clazz c on s.clazz_id = c.id
<where>
<if test="name != null and name != ''">
s.name like concat('%',#{name},'%')
</if>
<if test="degree != null">
and s.degree = #{degree}
</if>
<if test="clazzId != null">
and s.clazz_id = #{clazzId}
</if>
</where>
order by s.update_time desc
</select>