3.3.2 Api
定义我的课程查询接口如下:
public QueryResponseResult<CourseInfo> findCourseList(int page,
int size,
CourseListRequest courseListRequest);
3.3.3 Dao
修改 CourseMapper.xml的查询课程列表,添加companyId条件。
<select id="findCourseListPage" resultType="com.xuecheng.framework.domain.course.ext.CourseInfo"
parameterType="com.xuecheng.framework.domain.course.request.CourseListRequest">
SELECT
course_base.*,
(SELECT pic FROM course_pic WHERE courseid = course_base.id) pic
FROM
course_base
where 1=1
<if test="companyId!=null and companyId!=''">
and course_base.company_id = #{companyId}
</if>
</select>
3.3.4 Service
修改CourseService的findCourseList方法,添加companyId参数,并且传给dao
public QueryResult<CourseInfo> findCourseList(String companyId,int page,int
size,CourseListRequest courseListRequest) {
if(courseListRequest == null){
courseListRequest = new CourseListRequest();
}
//企业id
courseListRequest.setCompanyId(companyId);
//将companyId传给dao
courseListRequest.setCompanyId(companyId);
if(page<=0){
page = 0;
}
if(size<=0){
size = 20;
}
PageHelper.startPage(page, size);
Page<CourseInfo> courseListPage = courseMapper.findCourseListPage(courseListRequest);
List<CourseInfo> list = courseListPage.getResult();
long total = courseListPage.getTotal();
QueryResult<CourseInfo> courseIncfoQueryResult = new QueryResult<CourseInfo>();
courseIncfoQueryResult.setList(list);
courseIncfoQueryResult.setTotal(total);
return courseIncfoQueryResult;
}
3.3.5 Controller
修改CourseController的findCourseList,向service传入companyId
这里先使用静态数据测试使用。
@Override
@GetMapping("/coursebase/list/{page}/{size}")
public QueryResult<CourseInfo> findCourseList(@PathVariable("page") int page,
@PathVariable("size") int size,
CourseListRequest courseListRequest) {
//先使用静态数据测试
String companyId = "1";
return courseService.findCourseList(companyId,page,size,courseListRequest);
}