求问,Spring Boot+mybatisplus连表查询,后端返回的data一直是null,不知道哪里错了
Controller
@RestController
@RequestMapping("/course")
public class CourseController {
@GetMapping("/page")
public Result findPage(
@RequestParam Integer pageNum,
@RequestParam Integer pageSize) {
Page page = courseService.findPage(new Page<>(pageNum, pageSize));
return Result.success(page);
}
}
Service层
@Service
public class CourseServiceImpl extends ServiceImpl, Course> implements ICourseService {
@Resource
private CourseMapper courseMapper;
@Override
public Page<Course> findPage(Page<Course> page) {
return courseMapper.findPage(page);
}
}
public interface ICourseService extends IService<Course> {
Page findPage(Page page);
}
Mapper
public interface CourseMapper extends BaseMapper<Course> {
Page findPage(Page page);
}
<select id="findPage" resultType="com.example.springboot.entity.Course">
select course.*,student.name as teacher from course
left join student
on course.teacher_id = student.id
select>
调用后端接口返回
"code": "200",
"msg": "",
"data": null
可以远程给你调试
package com.changsha.Mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.changsha.entity.Student;
public interface StudentMapper extends BaseMapper<Student> {
/* 在BaseMapper中已经实现了很多CURD方法
类中也可以自己添加方法
*/
//自定义方法
public List<Student> selfSelect();
}
这个接口可以什么方法都不声明,因为在BaseMapper类中继承了很多的CRUD(CRUD是指在做计算处理时的增加Create、读取查询Retrieve、更新Update和删除Delete几个单词的首字母简写)方法。
看一下你pageNum和pageSize值对不对,另外on course.teacher_id = student.id 老师和学生id相等确定没错吗?