MyBatis传递多个参数的写法

第一种方案          

Dao层代码

Public User selectUser(Map paramMap);

对应的Mapper文件

<select id=" selectUser" resultMap="BaseResultMap">
   select  *  from user_user_t   where user_name = #{userName，jdbcType=VARCHAR} and user_area=#{userArea,jdbcType=VARCHAR}
</select>

测试用例：

Private User xxxSelectUser(){
Map paramMap=new hashMap();
paramMap.put(“userName”,”对应具体的参数值”);
paramMap.put(“userArea”,”对应具体的参数值”);
User user=xxx. selectUser(paramMap);}

第二种方案 

Dao层代码

public List<Fdfsfile> findAllTest(@Param("param")Map<String, Object> param, @Param("fdfsfile")Fdfsfile fdfsfile);

对应Mapper文件

select id="findAllTest" resultMap="BaseResultMap">
		select 
			  fdfs.id, fdfs.fileid,fdfs.text,fdfs.qa,fdfs.createtime
		from 
		      fdfsfile fdfs
		where 
			  fdfs.id = #{param.communityID}
		and 
			  fdfs.fileid = #{fdfsfile.userid}
	</select>

测试用例:

Map<String, Object> param = new HashMap<String, Object>();
		param.put("communityID", "COM1510090000624");
		
		Fdfsfile fdfsfile = new Fdfsfile();
		fdfsfile.setUserid("1111");
		List<Fdfsfile> findAllTest = fdfsfileMapper.findAllTest(param, fdfsfile);
		
		System.out.println(findAllTest.size());