How does MyBatis return a list collection?

9 months ago

Emily Johnson

2 minutes

When using MyBatis to query a database, you can define a method that returns a List to return a collection of query results. Here is a simple example:

Firstly, define a query method in the Mapper interface, for example:

public interface UserMapper {
    List<User> selectAllUsers();
}

Write the corresponding SQL statement in the Mapper XML file, for example:

<select id="selectAllUsers" resultType="User">
    SELECT * FROM users;
</select>

When calling methods in the Mapper interface from the calling end, retrieve the returned List collection, for example:

SqlSession sqlSession = sqlSessionFactory.openSession();
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
List<User> userList = userMapper.selectAllUsers();

In this way, you can query the database using MyBatis and return the results as a List collection.