Mybatise-Plus使用总结

一、Mybatise-Pluse常用总结

1. 分页使用

可以使用自带查询条件分页，如遇到多表查询且要对分页数据进行业务处理可以使用mybatise-plus自带分页工具：

自带查询条件分页 

自定义分页查询

方法层调用

    public IPage<PadOutDTO> findOutApplicationForm(Integer page,Integer limit, StockMasterVO param) {
        if (page == null) {
            page = 0;
        }
        if (limit == null) {
            limit = 10;
        }
        Page<PadOutDTO> dtoPage = new Page<>(page,limit);
        IPage<PadOutDTO> result = applicationFormMapper.findOutApplicationForm(dtoPage, param);
        return result;
    }

 mapper层调用

<select id="findOutApplicationForm" resultMap="OutForm">
        SELECT
        form.application_form_no,detail.workorder_no,detail.material_count,
        form.create_time,detail.material_type,form.application_form_state
        FROM
        t_application_form form
        INNER JOIN
        t_outbound_details detail
        ON
        form.application_form_no = detail.application_form_no
        WHERE
        form.application_form_type = '1'
        <if test="param.workorderNo != null and param.workorderNo != ''">
            AND detail.workorder_no = #{param.workorderNo}
        </if>
        <if test="param.materialNo != null and param.materialNo != ''">
            AND detail.material_no = #{param.materialNo}
        </if>
        <if test="param.materialName != null and param.materialName != ''">
            AND detail.material_name = #{param.materialName}
        </if>
    </select>

2.插入后实体会直接带有id

3.更新的时候，指定可以更新为null值的字段，使用strategy

tablefield​​​​​​​

或者全局配置