Mybatis里的Mapper； 组合查询；多条件查询；模糊查询

<?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.jsh.erp.stock.dao.BsProdProcessMapper">
    <update id="updateBuildOnlyNumber">
        update jsh_sequence set current_val = current_val + 1 where seq_name = 'bs_prod_list_seq'
    </update>

    <select id="getBuildOnlyNumber" resultType="java.lang.Long">
        select current_val from jsh_sequence where seq_name = 'bs_prod_list_seq'
    </select>
    <select id="findBsProdProcessWithBeginAndEndTime" resultType="com.jsh.erp.stock.entity.BsProdProcess">
        select * from bs_prod_process where 1 = 1
        <if test="beginTime != null and beginTime != ''">
            and order_date &gt; #{beginTime}
        </if>
        <if test="endTime != null and endTime != ''">
            and order_date &lt; #{endTime}
        </if>
        <if test="processCode != null and processCode != ''">
            and process_code like CONCAT('%', #{processCode}, '%')
        </if>
        <if test="projectName != null and projectName != ''">
            and project_name like CONCAT('%', #{processName}, '%')
        </if>
        <if test="projectCode != null and projectCode != '' ">
            and project_code like CONCAT('%', #{projectCode}, '%')
        </if>
        <if test="processState != -1 ">
            and process_state = #{processState}
        </if>
    </select>
</mapper>

对应的Mapper接口： BsProdProcessMapper.java

package com.jsh.erp.stock.dao;

import com.jsh.erp.stock.entity.BsProdProcess;
import com.jsh.erp.stock.query.BsProdProcessQuery;
import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.common.MySqlMapper;

import java.util.List;

/**
* @Package: com.jsh.erp.stock.dao
* @ClassName: BsProdProcessMapper
* @Author: hanty
* @Description: 生产流程单 Mapper
* @Date: 2020-12-29 09:49:51
* @Version: 1.0
*/
public interface BsProdProcessMapper extends Mapper<BsProdProcess>, MySqlMapper<BsProdProcess> {
    /**
     * 带有开始时间和结束时间的查询生产清单接口
     * @param bsProdProcessQuery
     * @return
     */
    List<BsProdProcess> findBsProdProcessWithBeginAndEndTime(BsProdProcessQuery bsProdProcessQuery);
}