02-Mybatis中的万能公式

map万能公式

1. 映射接口

User getUserById2(Map<String,Object> map);

2.接口对应配置文件的编写

 <select id="getUserById2" parameterType="map" resultType="com.lty.pojo.User">
   select * from user where id=#{userid};
 </select>

3.测试编写

@Test
 public void getUserById2(){
   SqlSession sqlSession = MybatisUtils.getSession();
   UserDao mapper = sqlSession.getMapper(UserDao.class);
   Map<String, Object> map = new HashMap<>();
   map.put("userid",1);
   User user = mapper.getUserById2(map);
   System.out.println(user);
   sqlSession.close();
 }