Parameter 'queryWrapper' not found. Available parameters are [ew, page, param1, param2]
mybatis-plus 的重写
关于,重写 selectPage方法。
打算重写,selectPage ,引用自己的自定义的sql 。同时 又保留 共有方法,实现方法重写。
CommonServiceImpl
//查询获取数据
page = commonMapper.selectPage(page, queryWrapper);
UserMstMapper
@Select("<script> " +
" select u.*,d.TRSNM as company_name , GROUP_CONCAT(r.name) as roleNames" +
" from USER_MST u " +
" left join TORMTA d on u.orderer_code = d.TRSCD " +
" left join sys_user_role ur on u.user_id=ur.user_id " +
" left join sys_role r on ur.role_id=r.id " +
" where 1=1 " +
" <if test ='ew.entity.userId!=null and ew.entity.userId.trim() neq \"\"'>" +
" and u.user_id like concat('%',#{ew.entity.userId},'%')" +
" </if>" +
" <if test ='ew.entity.emailAddress!=null and ew.entity.emailAddress.trim() neq \"\"'>" +
" and u.email_address like concat('%',#{ew.entity.emailAddress},'%')" +
" </if>" +
" <if test ='ew.entity.status!=null '>" +
" and u.status = #{ew.entity.status}" +
" </if>" +
" <if test ='ew.entity.ordererCode!=null and ew.entity.ordererCode > 0'>" +
" and u.orderer_code like concat('%,',#{ew.entity.ordererCode},',%')" +
" </if>" +
" GROUP BY u.user_id " +
"</script>")
@Results({
@Result(id = true, column = "id", property = "id")
})
IPage<UserMst> selectPage(Page<UserMst> page, @Param("ew") QueryWrapper ew);
自定义 selectPage 的sql 。
这样就能调用轮子,改动最少。掌声
问题 出现在
新
@Param("ew") QueryWrapper ew