View Javadoc
1   /*
2    *    Copyright 2009-2021 the original author or authors.
3    *
4    *    Licensed under the Apache License, Version 2.0 (the "License");
5    *    you may not use this file except in compliance with the License.
6    *    You may obtain a copy of the License at
7    *
8    *       http://www.apache.org/licenses/LICENSE-2.0
9    *
10   *    Unless required by applicable law or agreed to in writing, software
11   *    distributed under the License is distributed on an "AS IS" BASIS,
12   *    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13   *    See the License for the specific language governing permissions and
14   *    limitations under the License.
15   */
16  package org.apache.ibatis.submitted.sql;
17  
18  import java.util.List;
19  
20  import org.apache.ibatis.annotations.Param;
21  import org.apache.ibatis.annotations.SelectProvider;
22  import org.apache.ibatis.builder.annotation.ProviderMethodResolver;
23  import org.apache.ibatis.jdbc.SQL;
24  
25  public interface Mapper {
26  
27    @SelectProvider(type = SqlProvider.class)
28    List<User> findAll(@Param("offset") long offset, @Param("limit") int limit);
29  
30    class SqlProvider implements ProviderMethodResolver {
31      public String findAll() {
32        return new SQL()
33          .SELECT("user_id", "name")
34          .FROM("${schema}users")
35          .ORDER_BY("user_id")
36          .OFFSET_ROWS("#{offset}")
37          .FETCH_FIRST_ROWS_ONLY("#{limit}")
38          .toString();
39      }
40    }
41  
42  }