Table Mapping

Example 1: class name as table name (default)
@Table
public class Users {      // 映射为 Users 表
    private Integer id;   // 映射为 id 列
    private String  name; // 映射为 name 列
    private Integer age;  // 映射为 age 列

    // getters and setters omitted
}

Example 2: specify table name
@Table("admin_users")
public class AdminUsers {       // 表名映射为 admin_users 表
    private Integer id;         // 映射为 id 列
    private String  name;       // 映射为 name 列
    private Integer age;        // 映射为 age 列
    @Column("create_time")
    private Date    createTime; // 映射为 create_time 列

    // getters and setters omitted
}

Example 3: specify catalog/schema
@Table(catalog = "co", 
       schema  = "example", 
       table   = "admin_users")
public class AdminUsers {       // 表名映射为 co.example.admin_users
    private Integer id;         // 映射为 id 列
    private String  name;       // 映射为 name 列
    private Integer age;        // 映射为 age 列

    // getters and setters omitted
}

Example 4: annotation-only mapping
@Table(table = "admin_users", autoMapping = false)
public class AdminUsers {       // 表名映射为 admin_users
    private Integer id;         // 不映射
    private String  name;       // 不映射
    @Column
    private Integer age;        // 映射为 age 列
    @Column("create_time")
    private Date    createTime; // 映射为 create_time 列

    // getters and setters omitted
}

Example 5: ignore a property
@Table(table = "admin_users")
public class AdminUsers {       // 表名映射为 admin_users
    private Integer id;         // 映射为 id 列
    private String  name;       // 映射为 name 列
    private Integer age;        // 映射为 age 列
    @Ignore
    private Date    modifyTime; // 忽略到列的映射
}

@Table attributes

Attribute	Description
catalog	可选 Catalog name. Default empty.
schema	可选 Schema name. Default empty.
table	可选 Table name; defaults to class name when empty. Tip: `value` is equivalent; when all defaults are used you can omit the attribute name as in example 3.
value	可选 Same as `table`; defaults to class name when empty. Tip: `value` is equivalent; when all defaults are used you can omit the attribute name as in example 3.
autoMapping	可选 Auto mapping on by default. When false, every mapped column must be annotated with @Column.
useDelimited	可选 Wrap table/column names in delimiters to handle reserved words. Default false.
caseInsensitive	可选 Case-insensitive table/column names when true (default). Applies when reading result sets.
mapUnderscoreToCamelCase	可选 Convert camel-case names to underscore in table/column names. Off by default.
ddlAuto	可选 Auto DDL mode: `none, create, add, update, create-drop` (auto DDL not yet supported).

@Column 注解属性

Attribute	Description
name	可选 Column name; defaults to the property name.
value	可选 Column name; defaults to the property name.
jdbcType	可选 jdbcType to use; default is Types.JAVA_OBJECT.
specialJavaType	可选 For abstract properties, specify the concrete implementation type.
typeHandler	可选 TypeHandler to read/write the column.
keyType	可选 Applies to Fluent API. Data generator when the value is null. See Key generator.
primary	可选 Whether this is a primary key. Default false.
insert	可选 For Fluent API: whether to include in insert. See Write policy.
update	可选 For Fluent API: whether to include in update. See Write policy.
selectTemplate	可选 For Fluent API: column expression in SELECT. Empty = column name. See Statement templates.
insertTemplate	可选 For Fluent API: argument expression in INSERT, default `?`. See Statement templates.
setValueTemplate	可选 For Fluent API: argument expression in UPDATE SET, default `?`. See Statement templates.
whereColTemplate	可选 For Fluent API: column expression in WHERE (update/delete). Empty = column name. See Statement templates.
whereValueTemplate	可选 For Fluent API: argument expression in WHERE (update/delete), default `?`. See Statement templates.
orderByColTemplate	可选 For Fluent API: column expression in ORDER BY. Empty = column name. See Statement templates.

@Table attributes​

@Column 注解属性​

@Table attributes

@Column 注解属性