1
2
3
4
5
6
7
8
9
10
11
12
13
14
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 }