1.万能Map
假设我们的实体类或者数据库中的表,它们的字段或者参数过多,我们应该考虑使用Map!
接口
//万能Map
int addUser2(Map<String,Object> userMap);
实现类
<insert id="addUser2" parameterType="map">
insert into mybatis.user (id,name) values (#{id},#{name})
</insert>
测试
@Test
public void addUser2Test(){
SqlSession sqlSession = MybatisUtil.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
HashMap<String, Object> userMap = new HashMap<>();
userMap.put("id",9);
userMap.put("name","giao");
int success = mapper.addUser2(userMap);
if(success>0){
System.out.println("添加成功!");
} else {
System.out.println("添加失败");
}
sqlSession.commit();
sqlSession.close();
}
2.模糊查询拓展
模糊查询怎么写?
- Java代码执行的时候,传递通配符% %
List<User> userList = mapper.getUserLike("%l%");
- 在sql拼接中使用通配符
<select id="getUserLike" resultType="com.hui.pojo.User" >
select * from mybatis.user where name like "%"#{value}"%"
</select>