注意:使用Generator的时候,必须保证数据库的连通性和数据库是否有表 1.首先,create new project,创建一个spring Initializr项目 2.然后点击下一步 3.添加依赖 4.打开application.propertries文件 添加如下配置
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://ip地址:端口号/数据库名称?useUnicode=true&characterEncoding=UTF-8 spring.datasource.username=你的数据库用户名 spring.datasource.password=你设置的密码 server.port=自定义一个端口号 mybatis.mapper-locations= classpath:/mapper/**/*.xml保证包结构的完整性,创建一个generatorConfig.xml文件 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"> <!-- mybatis-generator的核心配置文件 --> <generatorConfiguration> <classPathEntry location="这里是本地仓库的/mysql-connector-java-8.0.15.jar插件的位置" /> <context id="DB2Tables" targetRuntime="MyBatis3"> <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://还是你的数据库的ip地址:端口号/数据库连接名" userId="用户名" password="密码"> <!-- 产生--> <property name="useInformationSchema" value="true"/> </jdbcConnection> <!--指定生成的类型为java类型，避免数据库中number等类型字段 --> <javaTypeResolver > <property name="forceBigDecimals" value="false" /> </javaTypeResolver> <!--自动生成的实体的存放包路径 --> <javaModelGenerator targetPackage="com.jzt.system.bean" targetProject="./src/main/java"> <property name="enableSubPackages" value="true" /> <property name="trimStrings" value="true" /> </javaModelGenerator> <!--自动生成的*Mapper.xml文件存放路径 --> <sqlMapGenerator targetPackage="mapper" targetProject="./src/main/resources"> <property name="enableSubPackages" value="true" /> </sqlMapGenerator> <!--自动生成的*Mapper.java存放路径 --> <javaClientGenerator type="XMLMAPPER" targetPackage="com.jzt.system.mapper" targetProject="./src/main/java"> <property name="enableSubPackages" value="true" /> </javaClientGenerator> <!-- 映射配置 --> <table tableName="这里添加你的表名" domainObjectName="这里用表名的首字母大写,比如Tablename" ></table> <--这里如果不止一张表的话需要手动添加多张表---> </context> </generatorConfiguration>然后在pom.xml文件里添加依赖
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.1.4.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.刚才的包名</groupId> <artifactId>项目名</artifactId> <version>0.0.1-SNAPSHOT</version> <name>system</name> <description>Demo project for Spring Boot</description> <properties> <java.version>1.8</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-devtools</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <!-- swagger api文档 --> <dependency> <groupId>io.springfox</groupId> <artifactId>springfox-swagger2</artifactId> <version>2.6.1</version> </dependency> <dependency> <groupId>io.springfox</groupId> <artifactId>springfox-swagger-ui</artifactId> <version>2.6.1</version> </dependency> <!--mysql驱动--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <!--mybatis--> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.2</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> </dependency> <!--mybatis-generator--> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> <plugin> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.5</version> </plugin> </plugins> </build> </project>然后在config文件夹中创建MybatisConfig和Swagger2和WebConfig文件 源文件:链接：https://pan.baidu.com/s/1fT2Js6_6ld8L_-GZWiZb8g 提取码：omw4
5.在控制台运行
mvn -Dmybatis.generator.overwrite=true mybatis-generator:generate然后就会自动生成bean和mapper里的文件,所有需要用到的数据库语句都会自动生成. 创建需要的Service和Impl和Controller 启动项目,去浏览器查看swagger localhost:你的端口/swagger.ui.html
