mybatis-ResultMap简单案例

一.数据库字段

二.java bean 属性

//实体类
public class User {
    private int id;
    private String name;
    private String password;
}

三.UserMapper接口方法

//根据id查询用户
User getUser(int id);

四.UserMapper.xml中使用结果集映射->resultMap

    

        
        
        
    
    
        select * from mybatis.user where id = #{id}
    

五.测试

@Test
public void test(){
    SqlSession sqlSession = MybatisUtils.getSqlSession();
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    User user = mapper.getUser(1);
    System.out.println(user);
    sqlSession.close();
}