示例Model

ACTable示例Model

简单的配置如下：

import com.gitee.sunchenbin.mybatis.actable.annotation.*;
import java.math.BigDecimal;
import java.util.Date;
/**
 * 全部采用actable自有的注解
 */
@Table(comment = "actable简单配置")
public class ACTableSimple {
    @IsKey
    @IsAutoIncrement
    private Long id;
    @Column
    @Index
    @IsNotNull
    private String name;
    @Column
    private Date createTime;
    @Column(defaultValue = "false")
    private Boolean isTrue;
    @Column
    private Integer age;
    @Column
    private BigDecimal price;
    @Column
    @Unique
    private String identitycard;
}

生成表如下：

进阶版配置如下：

import com.gitee.sunchenbin.mybatis.actable.annotation.*;
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlCharsetConstant;
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlEngineConstant;
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlTypeConstant;
import java.math.BigDecimal;
import java.util.Date;
/**
 * 全部采用actable自有的注解
 */
@Table(value = "t_actable_advance", comment = "actable进阶配置")
@TableCharset(MySqlCharsetConstant.UTF8)
@TableEngine(MySqlEngineConstant.InnoDB)
public class ACTableAdvance {
    @IsKey
    @IsAutoIncrement
    private Long id;
    @Column
    @Index(value = "idx_name_shop", columns = {"name","shop"})
    @IsNotNull
    private String name;
    @Column(name = "create_time", type = MySqlTypeConstant.TIMESTAMP, comment = "创建时间")
    private Date createTime;
    @Column
    @DefaultValue("true")
    private Boolean isTrue;
    @Column
    @ColumnComment("年龄")
    @ColumnType(value = MySqlTypeConstant.INT, length = 3)
    private Integer age;
    @Column(length = 10, decimalLength = 4)
    private BigDecimal price;
    @Column
    @Unique("uni_identitycard")
    private String identitycard;
    @Column
    @Unique(columns = {"name","shop"})
    private String shop;
}

生成表如下：

tk.mybatis示例Model

简单的配置如下：

import javax.persistence.Column;
import javax.persistence.Id;
import javax.persistence.Table;
import java.math.BigDecimal;
import java.util.Date;

/**
 * 完全使用tk.mybatis的注解
 */
@Table
public class TKMybatisSimple {

    @Id
    private Long id;

    @Column
    private String name;

    @Column
    private Date createTime;

    @Column
    private Boolean isTrue;

    @Column
    private Integer age;

    @Column
    private BigDecimal price;

    @Column
    private String identitycard;
}

生成表如下：

进阶版的结合ACTable的配置如下：

import com.gitee.sunchenbin.mybatis.actable.annotation.*;
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlCharsetConstant;
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlEngineConstant;
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlTypeConstant;

import javax.persistence.Column;
import javax.persistence.Id;
import javax.persistence.Table;
import java.math.BigDecimal;
import java.util.Date;

/**
 * 使用tk.mybatis的Table，Column，Id三个注解，其他的是actable的注解
 */
@Table(name = "t_tkmybatis_advance")
@TableComment("tkmyabts进阶版配置结合actable注解")
@TableCharset(MySqlCharsetConstant.UTF8)
@TableEngine(MySqlEngineConstant.InnoDB)
public class TKMybatisAdvance {

    @Id
    @IsAutoIncrement
    private Long id;

    @Column(length = 50, nullable = false)
    @Index(value = "idx_name_shop", columns = {"name","shop"})
    private String name;

    @Column(name = "create_time")
    @ColumnType(MySqlTypeConstant.TIMESTAMP)
    @ColumnComment("创建时间")
    private Date createTime;

    @Column
    @DefaultValue("0")
    private Boolean isTrue;

    @Column
    @ColumnComment("年龄")
    @ColumnType(value = MySqlTypeConstant.INT, length = 3)
    private Integer age;

    @Column(length = 10, scale = 4)
    private BigDecimal price;

    @Column
    @Unique("uni_identitycard")
    private String identitycard;

    @Column
    @Unique(columns = {"name","shop"})
    private String shop;
}

生成表如下：

mybatis-plus示例Model

简单的配置如下：

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;

import java.math.BigDecimal;
import java.util.Date;

/**
 * 完全使用mybatis-plus的注解
 */
@TableName
public class MybatisPlusSimple {

    @TableId
    private Long id;

    @TableField
    private String name;

    @TableField
    private Date createTime;

    @TableField
    private Boolean isTrue;

    @TableField
    private Integer age;

    @TableField
    private BigDecimal price;

    @TableField
    private String identitycard;
}

生成表如下：

进阶版的结合ACTable的配置如下：

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.gitee.sunchenbin.mybatis.actable.annotation.*;
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlCharsetConstant;
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlEngineConstant;
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlTypeConstant;

import java.math.BigDecimal;
import java.util.Date;

/**
 *
 */
@TableName("t_mybatisplus_advance")
@TableComment("mybatisplus进阶版配置结合actable注解")
@TableCharset(MySqlCharsetConstant.UTF8)
@TableEngine(MySqlEngineConstant.InnoDB)
public class MybatisPlusAdvance {

    @TableId
    @IsAutoIncrement
    private Long id;

    @TableField
    @ColumnType(length = 50)
    @IsNotNull
    @Index(value = "idx_name_shop", columns = {"name","shop"})
    private String name;

    @TableField("create_time")
    @ColumnType(MySqlTypeConstant.TIMESTAMP)
    @ColumnComment("创建时间")
    private Date createTime;

    @TableField
    @DefaultValue("1")
    private Boolean isTrue;

    @TableField
    @ColumnComment("年龄")
    @ColumnType(value = MySqlTypeConstant.INT, length = 3)
    private Integer age;

    @TableField
    @ColumnType(length = 10, decimalLength = 4)
    private BigDecimal price;

    @TableField
    @Unique("uni_identitycard")
    private String identitycard;

    @TableField
    @Unique(columns = {"name","shop"})
    private String shop;

    @TableField(exist = false)
    private String notExsit;
}

生成表如下：