ruoyi整合A.CTable
- 需求
- 进入正题
- 第一步安装 A.CTable
- 第二步在application.yml文件中添加配置
- 第三步配置MyBtis
- 第四步在启动类上添加注解
- A.CTable配置实体类
-
- 注解详解
需求
- 我们的需求一是让系统帮我们自动创建数据库表格,二是自动在子类的数据库表中补充父类的公共属性
- 感谢A.CTable的作者孙琛斌(浮生),开源地址
- 语雀文档地址
进入正题
第一步安装 A.CTable
com.gitee.sunchenbin.mybatis.actable
mybatis-enhance-actable
1.5.0.RELEASE
第二步在application.yml文件中添加配置
actable:
table:
auto: update
model:
pack: com.ruoyi.entity
database:
type: mysql
# Spring配置数据库连接配置
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/ry-vue?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
username: root
password: 123456
第三步配置MyBtis
# MyBatis配置
mybatis:
# 配置mapper的扫描,找到所有的mapper.xml映射文件
mapperLocations: classpath*:mapper*Mapper.xml,classpath*:com/gitee/sunchenbin/mybatis/actable/mapping
@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;
}
进阶配置
@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;
}
注解详解