我要评论mybatisplus的分页插件和条件构造器自定义sql遇到的bug
代码
page<scorerecordlistvo> getscorerecordpages( @param(constants.wrapper) querywrapper<scorerecord> qw,@param("pages") page<scorerecordlistvo> pages);问题
当使用@param("page")或其他时，会失效…
经过多方尝试，只能使用@param("pages")
完整代码
- mapper文件
package evan.lijun.xscj.mapper;
import com.baomidou.mybatisplus.core.conditions.query.querywrapper;
import com.baomidou.mybatisplus.core.mapper.basemapper;
import com.baomidou.mybatisplus.core.toolkit.constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.page;
import org.apache.ibatis.annotations.param;
import org.springframework.stereotype.repository;
@repository
public interface scorerecordmapper extends basemapper<scorerecord> {
page<scorerecordlistvo> getscorerecordpages( @param(constants.wrapper) querywrapper<scorerecord> qw,@param("pages") page<scorerecordlistvo> pages);
}- 自定义sql
<select id="getscorerecordpages" resulttype="evan.lijun.xscj.pojo.vo.scorerecordlistvo">
select <include refid="getscorerecordpagesselect"></include> from score_record record
left join student on record.student_id = student.id -- 关联student表
left join class_and_grade teams on record.team_id = teams.id -- 关联class_and_grade表
left join course on record.course_id = course.id -- 关联course表
${ew.customsqlsegment}
</select>总结
以上为个人经验，希望能给大家一个参考，也希望大家多多支持代码网。
发表评论