4.万能的Map+模糊查询

万能的Map

当数据或者属性很多的时候，可以选择性的单独改变密码或者用户名等等

UserMapper.java     

int updateUserByMap(Map<String,Object> map);

UserMapper.xml

<insert id="addUser" parameterType="map">
insert into mybatis.user (id,name,pwd) values (#{id},#{name},#{pwd});
</insert>

test.java

@Test
public void addUser(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);

Map<String,Object> map = new HashMap<String, Object>();
map.put("id",7);
map.put("name","董");
map.put("pwd","123");

mapper.addUser(map);
sqlSession.commit();
sqlSession.close();
}

模糊查询

UserMapper.java     

List<User> getUserLike(String value);

UserMapper.xml

 

<select id="getUserLike" resultType="com.zou.pojo.User">
select * from mybatis.user where name like #{value}
</select>

test.java

@Test
public void getUserLike(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);

List<User> userList = mapper.getUserLike("%董%");
for(User user : userList){
System.out.println(user);
}

sqlSession.close();
}

结果如下：

 

 注意：

 

1.Java程序运行时，传递通配符% %  

 

 

 依旧是喜欢丹丹的一天