java springboot 怎么集成mysql, mybatis-plus
1:引包
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.2.18</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.5.3.1</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-generator</artifactId>
<version>3.5.3.1</version>
</dependency>
2:配置 application.yml
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: 123456
url: jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf-8&serverTimezone=UTC
type: com.alibaba.druid.pool.DruidDataSource
sql:
init:
schema-locations: classpath:db/schema.sql #初始化sql DDL 脚本
mode: always #确定项目初始化时, sql脚本是否执行。 always:一直初始化数据库。EMBEDDED:内嵌式数据库才会初始化。never:不初始化
3:安装插件
4:建库建表
CREATE TABLE if not exists suite_config_t
(
id BIGINT(8) auto_increment primary key COMMENT '主键',
reversion INT COMMENT '乐观锁',
create_by VARCHAR(32) COMMENT '创建人',
create_time DATETIME COMMENT '创建时间',
update_by VARCHAR(32) COMMENT '更新人',
update_time DATETIME COMMENT '更新时间',
is_deleted TINYINT(1) COMMENT '是否删除',
suite_id VARCHAR(32) COMMENT '应用id'
) COMMENT = '应用配置表 ';
5:生成代码
打开idea, 点击Other-configdatabase
ok后, 点击other-codegenerator
点击check field检查字段
点击ok,再点击code generator
就生成了代码:
时间戳的转换问题
https://www.cnblogs.com/zszxz/p/12255663.html