mybatis-05-模糊查询

万能Map

假设实体类或数据库中表，字段或参数过多，应当考虑使用map

测试使用map进行新增操作

• 测试代码

@Test
	public void testAdd2(){
		SqlSession sqlSession = MybatisUtils.getSqlSession();
		UserMapper mapper = sqlSession.getMapper(UserMapper.class);
		Map<String, Object> map = new HashMap<>();

		map.put("userid",1);
		map.put("password","dddd");

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

• 数据库crud

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

模糊查询

• 测试

@Test
	public void testLike(){
		SqlSession sqlSession = MybatisUtils.getSqlSession();
		UserMapper mapper = sqlSession.getMapper(UserMapper.class);
		List<User> userList = mapper.getUserLike("%李%");
		userList.forEach(System.out::println);

		sqlSession.close();
	}

• sql模糊查询

<!--模糊查询-->
    <select id="getUserLike" resultType="User">
        select id,name,pwd as password from user where name like #{value};
    </select>
</mapper>