一.创建项目,导入静态页面
二.书写配置文件
1.静态页面映射文件`
public class WebMvcConfig extends WebMvcConfigurationSupport {
// 设置静态资源映射
@Override
protected void addResourceHandlers(ResourceHandlerRegistry registry) {
log.info("静态资源配置映射完成");
registry.addResourceHandler("backend/**").addResourceLocations("classpath:/backend/");
registry.addResourceHandler("front/**").addResourceLocations("classpath:/front/");
System.out.println("registry = " + registry);
}
}
2.yml配置文件
server:
port: 8080
spring:
datasource:
druid:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/reggie?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
username: root
password: 123456
mybatis-plus:
configuration:
map-underscore-to-camel-case: true
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
global-config:
db-config:
id-type: ASSIGN_ID
三.插件使用
1.mybatis-generator
首先进行pom.xml的修改
导入mybatis-generator的包,再增加其插件
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.4.0</version>
</dependency>
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.4.0</version>
<configuration>
<configurationFile>${basedir}/src/main/resources/generatorConfig.xml
</configurationFile>
<overwrite>true</overwrite>
<verbose>true</verbose>
</configuration>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.29</version>
</dependency>
</dependencies>
</plugin>
注意插件中需要增加MySQL依赖
再在配置文件中增加generatorConfig.xml配置文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<context id="testTables" targetRuntime="MyBatis3">
<commentGenerator>
<!-- 是否去除自动生成的注释 true:是 : false:否 -->
<property name="suppressAllComments" value="true" />
</commentGenerator>
<!--数据库连接的信息:驱动类、连接地址、用户名、密码 -->
<jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/reggie?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true"
userId="root"
password="123456">
</jdbcConnection>
<!-- 默认false,把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer,为 true时把JDBC DECIMAL 和
NUMERIC 类型解析为java.math.BigDecimal -->
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!-- targetProject:生成PO类的位置 -->
<javaModelGenerator targetPackage="com.tyf.reggiewaimai.entity"
targetProject=".\src\main\java">
<!-- enableSubPackages:是否让schema作为包的后缀 -->
<property name="enableSubPackages" value="false" />
<!-- 从数据库返回的值被清理前后的空格 -->
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- targetProject:mapper映射文件生成的位置 -->
<!-- <sqlMapGenerator targetPackage="com.bjpowernode.mapper"-->
<!-- targetProject=".\src">-->
<!-- <!– enableSubPackages:是否让schema作为包的后缀 –>-->
<!-- <property name="enableSubPackages" value="false" />-->
<!-- </sqlMapGenerator>-->
<!-- <!– targetPackage:mapper接口生成的位置 –>-->
<!-- <javaClientGenerator type="XMLMAPPER"-->
<!-- targetPackage="com.bjpowernode.mapper"-->
<!-- targetProject=".\src">-->
<!-- <!– enableSubPackages:是否让schema作为包的后缀 –>-->
<!-- <property name="enableSubPackages" value="false" />-->
<!-- </javaClientGenerator>-->
<!-- 指定数据库表 -->
<table schema="" tableName="address_book"></table>
<table schema="" tableName="category"></table>
<table schema="" tableName="dish"></table>
<table schema="" tableName="dish_falvor"></table>
<table schema="" tableName="employee"></table>
<table schema="" tableName="orders"></table>
<table schema="" tableName="order_detail"></table>
<table schema="" tableName="setmeal"></table>
<table schema="" tableName="setmeal_dish"></table>
<table schema="" tableName="shopping_cart"></table>
<table schema="" tableName="user"></table>
</context>
</generatorConfiguration>
启动maven中的插件即可生成逆向工程