官网示例前往

条件构造器用法示例

//条件构造器用法1
QueryWrapper<Indvinfo> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("id",indvinfo.getId());
Indvinfo result = indvinfoService.getOne(queryWrapper);
//条件构造器用法2
Indvinfo result = indvinfoService.getOne(Wrappers.<Indvinfo>query().eq("id", indvinfo.getId()));
//条件构造器用法3
Indvinfo result = indvinfoService.query().eq("id",indvinfo.getId()).one();

自定义方法分页示例

示例中的Page类均来自于com.baomidou.mybatisplus.extension.plugins.pagination.Page; 引入类的时候不要引错了

controller

IPage<TaskInfo> page = taskInfoService.pageNoReport(new Page<TaskInfo>(1, 300));
return Response.success(page);

service

public interface ITaskInfoService extends IService<TaskInfo> {
    IPage<TaskInfo> pageNoReport(Page<TaskInfo> page);
}

serviceImpl

public class TaskInfoServiceImpl extends ServiceImpl<TaskInfoMapper, TaskInfo> implements ITaskInfoService {
    @Autowired
    TaskInfoMapper taskInfoMapper;
    public IPage<TaskInfo> pageNoReport(Page page) {
        return taskInfoMapper.pageNoReport(page);
    }
}

mapper

public interface TaskInfoMapper extends BaseMapper<TaskInfo> {
    IPage<TaskInfo> pageNoReport(Page<TaskInfo> page);
}

mapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.sundsoft.business.taskinfo.mapper.TaskInfoMapper">
    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.sundsoft.business.taskinfo.entity.TaskInfo">
        <result column="workserialno" property="workserialno"/>
        <result column="assistcode" property="assistcode"/>
        <result column="eventcode" property="eventcode"/>
        <result column="taskindex" property="taskindex"/>
        <result column="pushstatus" property="pushstatus"/>
        <result column="pushtime" property="pushtime"/>
        <result column="reportstatus" property="reportstatus"/>
        <result column="reporttime" property="reporttime"/>
        <result column="bizstatus" property="bizstatus"/>
        <result column="nodetype" property="nodetype"/>
        <result column="ythoperatorcode" property="ythoperatorcode"/>
        <result column="operatorname" property="operatorname"/>
        <result column="operatoridcard" property="operatoridcard"/>
        <result column="operatorphone" property="operatorphone"/>
        <result column="operatorareacode" property="operatorareacode"/>
        <result column="nodeorganid" property="nodeorganid"/>
        <result column="ythdeptcode" property="ythdeptcode"/>
        <result column="deptname" property="deptname"/>
        <result column="auditadvice" property="auditadvice"/>
        <result column="auditremark" property="auditremark"/>
        <result column="gentime" property="gentime"/>
        <result column="completetime" property="completetime"/>
        <result column="postjson" property="postjson"/>
        <result column="resultjson" property="resultjson"/>
    </resultMap>
    <select id="pageNoReport" resultMap="BaseResultMap">
        SELECT T.workserialno, T.assistcode, T.eventcode
        FROM utb_gov_task_info T
        WHERE T.TASKINDEX='1'
          AND t.pushstatus = '0'
    </select>
</mapper>

链接