mybatis：mapper接口中使用@Select注解，返回列表

• UserMapper接口文件

package com.thb.mapper;

import java.util.List;

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")
    List<User> selectManyUsers();
}

User类：

package com.thb.model;

public class User {

    private int id;
    private String userName;
    private String homeTown;

    public int getId() {
        return this.id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUserName() {
        return this.userName;
    }

    public void setUserName(String name) {
        this.userName = name;
    }

    public String getHomeTown () {
        return this.homeTown;
    }

    public void setHomeTown(String hometown) {
        this.homeTown = hometown;
    }
}

mybatis-config.xml文件中的mapper配置：

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

调用代码：

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

    List<User> users = userMapper.selectManyUsers();
    for (User user : users) {
        System.out.println("*".repeat(60));
        System.out.println("id = " + user.getId());
        System.out.println("userName = " + user.getUserName());
        System.out.println("homeTown = " + user.getHomeTown());
    }
}

运行输出：