注意:不需要手动添加where
参数是构造器,使用@select
@Mapper
@Component
public interface UserMapper extends BaseMapper<User> {
@Select("select * from user ${ew.customSqlSegment}")
Page MyPage1(Page<User> page, @Param("ew") Wrapper<User> queryWrapper);
}
使用xml
效果和注解是相同的
<select id="myPage" resultType="com.fj.entity.User">
select * from user ${ew.customSqlSegment}
</select>
使用
@Mapper
@Component
public interface UserMapper extends BaseMapper<User> {
@Select("select * from user ${ew.customSqlSegment}")
Page MyPage(Page<User> page, @Param("ew") Wrapper<User> queryWrapper);
}