假如我们的实体类属性过多,用map,传递map的key
int addUser2(Map<String, Object> map);
<insert id="addUser2" parameterType="map">
insert into mybatis.user (id, name, pwd) values (#{id1}, #{name1}, #{pwd1});
</insert>
@Test
public void addUser2(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
Map<String, Object> map = new HashMap<String, Object>();
map.put("name1","dddddddddong");
map.put("pwd1","12345");
mapper.addUser2(map);
//提交事务
sqlSession.commit();
sqlSession.close();
}
扩展学习。
List<User> getUserLike(String value);
<select id="getUserLike" resultType="com.kuang.pojo.User">
select * from mybatis.user where name like #{value}
</select>
@Test
public void getUserLike(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserDao mapper = sqlSession.getMapper(UserDao.class);
List<User> list = mapper.getUserLike("%大%");
for(User user : list){
System.out.println(user);
}
sqlSession.close();
}