mybatis：使用@Select注解，通过mapper接口调用

• mybatis-config.xml文件中对mapper接口类的配置：

  <mappers>
    <mapper class="com.thb.mapper.UserMapper"/>
  </mappers>

• UserMapper接口文件：

package com.thb.mapper;

import org.apache.ibatis.annotations.Select;

import com.thb.model.User;

public interface UserMapper {

    @Select("SELECT id as id, user_name as userName, home_town as homeTown FROM user WHERE id = #{id}")
    User selectOneUser(int id);
}

• 通过mapper接口调用：

// 取得一个SqlSession
try (SqlSession session = sqlSessionFactory.openSession()) {
    UserMapper userMapper = session.getMapper(UserMapper.class);
    User user = userMapper.selectOneUser(2);

    System.out.println("id = " + user.getId());
    System.out.println("userName = " + user.getUserName());
    System.out.println("homeTown = " + user.getHomeTown());
}