Hello MyBatis

返回多结果集

• Mapper Interface：

  @Mapper
  public interface ExampleMapper {
      @Select("EXEC YourProc #{id}")
      @ResultMap({"users", "roles", "now"})
      @Options(statementType = StatementType.CALLABLE)
      List<List<?>> exampleMethod(Integer id);
  }

• XML Mapper：

  <mapper namespace="com.example.mapper.ExampleMapper">
      <resultMap id="users" type="com.example.model.User"/>
      <resultMap id="roles" type="com.example.model.Role"/>
      <resultMap id="now" type="java.time.LocalDateTime"/>
  </mapper>

• 使用：

  List<List<?>> results = exampleMapper.exampleMethod();
  List<User> users = (List<User>) results.get(0);
  List<Role> roles = (List<Role>) results.get(1);
  LocalDateTime now = (LocalDateTime) results.get(2).get(0);