實現(xiàn)功能：根據(jù)數(shù)據(jù)庫中的表，自動生成model、dao和對應(yīng)的xml文件。xml中實現(xiàn)通用mapper中CURD功能

1、引入依賴

<properties> <mybatis.generator.version>1.3.7</mybatis.generator.version> <tk.mybatis.version>4.1.5</tk.mybatis.version> </properties> <dependencies> <!--mybatis--> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.1.3</version> </dependency> <!--通用mapper--> <dependency> <groupId>tk.mybatis</groupId> <artifactId>mapper</artifactId> <version>${tk.mybatis.version}</version> </dependency> <!--mybatis-generator--> <dependency> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-core</artifactId> <version>${mybatis.generator.version}</version> </dependency> <!--mysql數(shù)據(jù)庫--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <!--druid數(shù)據(jù)源--> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.1.10</version> </dependency> <dependencies> <build> <plugins> <!--配置Maven中 mybatis-generator 插件--> <!--加入tk.mybatis的依賴--> <plugin><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-maven-plugin</artifactId><version>${mybatis.generator.version}</version><configuration> <!--可移動--> <verbose>true</verbose> <!--可覆蓋--> <overwrite>true</overwrite></configuration><dependencies> <dependency> <groupId>tk.mybatis</groupId> <artifactId>mapper</artifactId> <version>${tk.mybatis.version}</version> </dependency></dependencies> </plugin> </plugins> </build>

2、配置通用mapper

方式1：配置要掃描的mapper

@SpringBootApplication@MapperScan(basePackages = 'com.liang.mapper')public class MyappApplication { public static void main(String[] args) { SpringApplication.run(MyappApplication.class, args); }}

方式2：掃描的mapper

@Configurationpublic class MybatisConfig { @Bean(name = 'mapperScannerConfigurer') public MapperScannerConfigurer MapperScannerConfigurer1() { MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer(); mapperScannerConfigurer.setBasePackage('com.liang.mapper'); Properties properties = new Properties(); properties.setProperty('notEmpty', 'false'); properties.setProperty('IDENTITY', 'MYSQL'); properties.setProperty('mappers', Mapper.class.getName()); mapperScannerConfigurer.setSqlSessionFactoryBeanName('sqlSessionFactory'); mapperScannerConfigurer.setProperties(properties); return mapperScannerConfigurer; }}

3、application.yaml中配置mybatis

#Mybatis（注意不是 mybatis.config-location 這個配置）mybatis: mapper-locations: classpath:mapper/*.xml type-aliases-package: com.liang.pojo configuration-properties: { notEmpty: false, IDENTITY: ’MYSQL’, mappers: 'tk.mybatis.mapper.common.Mapper' }

4、添加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> <!-- 數(shù)據(jù)庫驅(qū)動--> <classPathEntry location='E:ideaMavenMavenRepositorymysqlmysql-connector-java8.0.22mysql-connector-java-8.0.22.jar' /> <context targetRuntime='MyBatis3Simple'> <!--beginningDelimiter和endingDelimiter：指明數(shù)據(jù)庫的用于標記數(shù)據(jù)庫對象名的符號，比如ORACLE就是雙引號，MYSQL默認是`反引號； --> <property name='beginningDelimiter' value='`'></property> <property name='endingDelimiter' value='`'></property> <!-- 生成的Java文件的編碼 --> <property name='javaFileEncoding' value='utf-8'/> <!--添加Tk-mapper插件--> <plugin type='tk.mybatis.mapper.generator.MapperPlugin' > <property name='mappers' value='tk.mybatis.mapper.common.Mapper'/> </plugin> <jdbcConnection driverClass='com.mysql.cj.jdbc.Driver' connectionURL='jdbc:mysql://localhost:3306/temp_db?serverTimezone=Asia/Shanghai&amp;characterEncoding=utf-8&amp;useUnicode=true&amp;useSSL=false' userId='root' password='123456'> </jdbcConnection> <!-- java類型處理器 用于處理DB中的類型到Java中的類型，默認使用JavaTypeResolverDefaultImpl； 注意一點，默認會先嘗試使用Integer，Long，Short等來對應(yīng)DECIMAL和 NUMERIC數(shù)據(jù)類型； --> <javaTypeResolver > <property name='forceBigDecimals' value='false' /> </javaTypeResolver> <!--生成entity類存放位置--> <javaModelGenerator targetPackage='com.liang.pojo' targetProject='src/main/java'> <property name='enableSubPackages' value='false' /> <property name='trimStrings' value='true' /> </javaModelGenerator> <!--生成映射文件存放位置 --> <sqlMapGenerator targetPackage='mapper' targetProject='src/main/resources'> <property name='enableSubPackages' value='true' /> </sqlMapGenerator> <!--生成Dao類存放位置--> <javaClientGenerator type='XMLMAPPER' targetPackage='com.liang.mapper' targetProject='src/main/java'> <property name='enableSubPackages' value='true' /> </javaClientGenerator> <!--要生成的Table,注意不同的數(shù)據(jù)庫，sqlStatement--> <!--sqlStatement 不同的數(shù)據(jù)庫配置 http://mybatis.org/generator/configreference/generatedKey.html--> <table domainObjectName='School2' tableName='t_school'> <!--<generatedKey column='id' sqlStatement='MySql' identity='true' />--> <generatedKey column='id' sqlStatement='SELECT LAST_INSERT_ID() AS id' identity='true' /> </table> </context></generatorConfiguration>

5、完成

以上就是本文的全部內(nèi)容，希望對大家的學習有所幫助，也希望大家多多支持好吧啦網(wǎng)。