1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 package examples.spring;
17
18 import java.util.Date;
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<LastName> lastName = person.lastName;
28 public static final SqlColumn<Date> birthDate = person.birthDate;
29 public static final SqlColumn<Boolean> employed = person.employed;
30 public static final SqlColumn<String> occupation = person.occupation;
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("id");
35 public final SqlColumn<String> firstName = column("first_name");
36 public final SqlColumn<LastName> lastName = column("last_name")
37 .withParameterTypeConverter(new LastNameParameterConverter());
38 public final SqlColumn<Date> birthDate = column("birth_date");
39 public final SqlColumn<Boolean> employed = column("employed")
40 .withParameterTypeConverter(new YesNoParameterConverter());
41 public final SqlColumn<String> occupation = column("occupation");
42 public final SqlColumn<Integer> addressId = column("address_id");
43
44 public Person() {
45 super("Person");
46 }
47 }
48 }