第一种方案
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());