Mybatis之传多个参数方法总结

提出问题

Mybatis如何实现传多个参数？？？

解决问题

例一：把参数放到map中，看下面代码，有点多

Service层的代码：

public List<PcsTask> findByPmProjectIdAndLeaderId(String projectId) {        String userId = SessionUtils.getCurrentUserId();        //查询参数        Map<String, Object> filter = new HashMap<>();        filter.put("leaderId", userId);        filter.put("pmProjectId", projectId);        return pcsTaskDAO.findByPmProjectIdAndLeaderId(filter);    }

DAO中的接口：

public List<PcsTask> findByPmProjectIdAndLeaderId(Map<String,Object> filter);

Mapper文件

<select id="findByPmProjectIdAndLeaderId" resultType="com.evada.de.projcommand.model.PcsTask" parameterType="java.util.Map">        select * from pm_workitem pw        where pw.pm_project_id = #{pmProjectId}        and pw.leader_id = #{leaderId}        and pw.workitem_status in ('1','2')        and pw.status > '0'        order by pw.plan_end_date asc    </select>

例二：看下代码#{0}，#{1}好像不是特别好

DAO层的函数方法

Public User selectUser(String name,String area);

Mapper文件

<select id="selectUser" resultMap="BaseResultMap">    select  *  from user_user_t   where user_name = #{0} and user_area=#{1}</select>

其中，#{0}代表接收的是dao层中的第一个参数，#{1}代表dao层中第二参数，更多参数一致往后加即可

例三：最推荐的方法，DAO和Mapper文件的代码量和参数都是最优的.

DAO层的函数方法

public ... findByStatus(@Param("mainTaskId") String mainTaskId, @Param("claimStatus") String claimStatus,@Param("subTaskStatus") String subTaskStatus);

Mapper文件

<select id="findByStatus" resultMap="PcsSubTaskDTOResultMap">        select pt.*,pw.code as task_code,pw.name as task_name        from pm_workitem pw,pm_task pt        where pt.status = '1'        and pt.pm_workitem_id = pw.id        and pt.pm_milestone_id = #{mainTaskId}        <if test="claimStatus != null and claimStatus != ''">            and pt.claim_status = #{claimStatus}        </if>        <if test="subTaskStatus != null and subTaskStatus != ''">            and pt.task_status = #{subTaskStatus}        </if>        order by pt.code  asc    </select>