mybatis-plus分页

 

分页

    @GetMapping(value = "cardScore/list")
    @ApiOperation("分页获取卡片积分")
    public Result getCartScoreList(@ApiParam(value = "page", required = true) Page<CzgjScorecard> page) {


        String uuid = RequestUtils.getParams("uuid");
        BaseSemester currentSemester = UserUtil.newInstance().getCurrentSemester(uuid);
        Integer semesterId = currentSemester.getId();
        StudentViewVo student = UserUtil.newInstance().getCurrentStudent(uuid);
        Integer studentId = student.getUserid();

        Page<CzgjScorecard> pagination = service.
                getScoreCardBySemesterIdStudentIdAndType(studentId, semesterId, page);

        Map<String, Object> retMap = new HashMap<>();
        retMap.put("list", pagination.getRecords());
        retMap.put("totalRecord", pagination.getTotal());
        retMap.put("totalPage", pagination.getPages());
        return ResultGenerator.genSuccessResult(retMap);

    }

 

    @Override
    public Page<CzgjScorecard> getScoreCardBySemesterIdStudentIdAndType(Integer studentId, Integer semesterId,
                                                                        Page<CzgjScorecard> page) {
        List<CzgjScorecard> czgjScorecards = czgjScorecardMapper.
                selectScoreCardBySemesterIdStudentIdAndTypePage(page, studentId, semesterId);
        page.setRecords(czgjScorecards);
        return page;
    }

 

    <select id="selectScoreCardBySemesterIdStudentIdAndTypePage" resultType="my.common.model.scorecard.CzgjScorecard">
        select u.realname,s.score,s.cname,ss.create_time from czgj_scorecard_student ss
        join czgj_scorecard s on s.id = ss.cid
        join sys_user u on u.id = ss.student_id
        where ss.student_id = #{studentId} and ss.semester_id = #{semesterId}
        ORDER BY ss.create_time DESC
    </select>