1.导入依赖
springboot:
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper-spring-boot-starter</artifactId>
<version>2.0.4</version>
</dependency>
代码生成MBG:
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.6</version>
<configuration>
<configurationFile>
${basedir}/src/main/resources/generatorConfig.xml
</configurationFile>
<overwrite>true</overwrite>
<verbose>true</verbose>
</configuration>
<dependencies>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>9.4.1211.jre7</version>
</dependency>
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>4.0</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.29</version>
</dependency>
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper</artifactId>
<version>4.0.0</version>
</dependency>
</dependencies>
</plugin>
执行命令:mybatis-generator:generate
-------------------------------------------------------------------------------------------
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="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat">
<plugin type="tk.mybatis.mapper.generator.MapperPlugin">
<property name="mappers" value="tk.mybatis.mapper.common.Mapper"/>
<!-- caseSensitive默认false,当数据库表名区分大小写时,可以将该属性设置为true -->
<property name="caseSensitive" value="true"/>
<property name="forceAnnotation" value="true"/>
</plugin>
<!-- 数据库连接 -->
<jdbcConnection driverClass=""
connectionURL=""
userId=""
password="h">
</jdbcConnection>
<!-- 实体创建 -->
<javaModelGenerator targetPackage="com.sixi.domain.model" targetProject="src/main/java"/>
<!-- xml sql -->
<sqlMapGenerator targetPackage="com.sixi.fin.mapper" targetProject="src/main/resources"/>
<!-- mapper -->
<javaClientGenerator targetPackage="com.sixi.domain.dao.oasqlserver" targetProject="src/main/java" type="XMLMAPPER"/>
<table tableName="aaa_demo" domainObjectName="AaaDemo" >
<generatedKey column="id" sqlStatement="JDBC" identity="true"/>
</table>
</context>
</generatorConfiguration>
-------------------------------------------------------------------------------------------------------------------
MapperScannerConfigurer :使用tk的扫描 /** * 指定扫描 mybaties mapper 的包名 * @return * @throws Exception */ public static MapperScannerConfigurer getMapperScannerConfigurer(String sqlSessionFactoryBean, String packageName) throws Exception{ //通用mapper配置 Properties properties = new Properties(); properties.setProperty("mappers", "tk.mybatis.mapper.common.Mapper"); properties.setProperty("notEmpty", "false"); MapperScannerConfigurer m=new MapperScannerConfigurer(); m.setBasePackage(packageName); m.setSqlSessionFactoryBeanName(sqlSessionFactoryBean); m.setProperties(properties); return m; }