4.万能的map
1.多个参数是可以使用map接收
示例如下:
1.dao层结构
public interface UserDao {
List<User> getUserByMap(Map<String,Object> map);
}
2.mapper.xml中配置
<!--根据map查询-->
重点1:parameterType可有可无,但是resultType必须有
<select id="getUserByMap" resultType="cn.com.wmd.pojo.User" parameterType="map">
select * from public.user where id=#{user_id} and name=#{user_name}
</select>
3.测试类代码
@org.junit.Test
public void getUserBymap(){
SqlSession sqlSession=MybatisTools.getSqlSession();
UserDao userDao = sqlSession.getMapper(UserDao.class);
//重点2:将参数放入map中
Map<String,Object> map=new HashMap<String, Object>();
map.put("user_id",1);
map.put("user_name","吴孟达");
List<User> userList = userDao.getUserByMap(map);
for (User user : userList) {
System.out.println(user);
}
sqlSession.close();
}
增删改查的其他多参数形式类似