map传参
Map传递参数,直接在SQL中取出key即可
1.在接口方法中,参数直接传递Map
int addUser2(Map<String,Object> map);
2.编写SQL语句的时候,需要传递参数类型,参数类型为map
<!--万能map-->
<insert id="addUser2" parameterType="map">
INSERT into user (id, name, psw) VALUES (#{id},#{name},#{psw})
</insert>
3.在使用方法的时候,Map的key为sql中去的值即可,没有顺序要求
@Test
public void addUser2(){
SqlSession session = MybatisUtils.getSqlSession();
UserDao mapper = session.getMapper(UserDao.class);
Map<String, Object> map = new HashMap<String, Object>();
map.put("id",4);
map.put("name","yueyue");
map.put("psw","12345678");
mapper.addUser2(map);
session.commit();
session.close();
}