使用DB2在一种方法中使用多个SQL的MyBatis映射器

public interface MyMapper {
    List<User> getUsers();
    void insertUser(User user);
    void updateUser(User user);
    void deleteUser(int userId);
}

<!-- MyMapper.xml -->
<mapper namespace="com.example.MyMapper">
    <select id="getUsers" resultType="com.example.User">
        SELECT * FROM users
    </select>
    <insert id="insertUser" parameterType="com.example.User">
        INSERT INTO users (id, name) VALUES (#{id}, #{name})
    </insert>
    <update id="updateUser" parameterType="com.example.User">
        UPDATE users SET name = #{name} WHERE id = #{id}
    </update>
    <delete id="deleteUser" parameterType="int">
        DELETE FROM users WHERE id = #{id}
    </delete>
</mapper>

<!-- mybatis-config.xml -->
<configuration>
    <mappers>
        <mapper resource="com/example/MyMapper.xml"/>
    </mappers>
</configuration>

SqlSessionFactory sqlSessionFactory = ...; // 初始化SqlSessionFactory
SqlSession sqlSession = sqlSessionFactory.openSession();
MyMapper myMapper = sqlSession.getMapper(MyMapper.class);

List<User> users = myMapper.getUsers();
User user = new User(1, "John");
myMapper.insertUser(user);
user.setName("Tom");
myMapper.updateUser(user);
myMapper.deleteUser(1);

sqlSession.commit();
sqlSession.close();