1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 package examples.groupby;
17
18 import java.sql.JDBCType;
19
20 import org.mybatis.dynamic.sql.SqlColumn;
21 import org.mybatis.dynamic.sql.SqlTable;
22
23 public final class PersonDynamicSqlSupport {
24 public static final Person person = new Person();
25 public static final SqlColumn<Integer> id = person.id;
26 public static final SqlColumn<String> firstName = person.firstName;
27 public static final SqlColumn<String> lastName = person.lastName;
28 public static final SqlColumn<String> gender = person.gender;
29 public static final SqlColumn<String> human = person.human;
30 public static final SqlColumn<Integer> age = person.age;
31 public static final SqlColumn<Integer> addressId = person.addressId;
32
33 public static final class Person extends SqlTable {
34 public final SqlColumn<Integer> id = column("person_id", JDBCType.INTEGER);
35 public final SqlColumn<String> firstName = column("first_name", JDBCType.VARCHAR);
36 public final SqlColumn<String> lastName = column("last_name", JDBCType.VARCHAR);
37 public final SqlColumn<String> gender = column("gender", JDBCType.VARCHAR);
38 public final SqlColumn<String> human = column("human_flag", JDBCType.VARCHAR);
39 public final SqlColumn<Integer> age = column("age", JDBCType.INTEGER);
40 public final SqlColumn<Integer> addressId = column("address_id", JDBCType.INTEGER);
41
42 public Person() {
43 super("Person");
44 }
45 }
46 }