-
新建一个SpringBoot项目,并引入Mybatis和mybatis-generator相关的依赖。如下
<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.0.1</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-devtools</artifactId> <scope>runtime</scope> <optional>true</optional> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.10</version> </dependency> <!--mybatis-generator核心包--> <dependency> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-core</artifactId> <version>1.3.5</version> <scope>provided</scope> </dependency>
-
在resource下新建一个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> <!--本机数据库驱动jar包存放目录--> <classPathEntry location="E:\software programe\apache-maven-3.5.4\repository\mysql\mysql-connector-java\5.1.42\mysql-connector-java-5.1.42.jar"/> <context id="DB2Tables" targetRuntime="MyBatis3"> <commentGenerator> <property name="suppressDate" value="true"/> <property name="suppressAllComments" value="true"/> </commentGenerator> <!--数据库驱动,数据库地址及表名,账号,密码--> <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/my-blog" userId="root" password="root"> </jdbcConnection> <javaTypeResolver> <property name="forceBigDecimals" value="false"/> </javaTypeResolver> <!--生成Model类的包名及存放位置--> <javaModelGenerator targetPackage="com.kangswx.blog.domain" targetProject="src/main/java"> <property name="enableSubPackages" value="true"/> <property name="trimStrings" value="true"/> </javaModelGenerator> <!--生成映射文件的包名及存放位置--> <sqlMapGenerator targetPackage="com.kangswx.blog.mapper.mapping" targetProject="src/main/java"> <property name="enableSubPackages" value="true"/> </sqlMapGenerator> <!--生成Dao类的包名及存放位置--> <javaClientGenerator type="XMLMAPPER" targetPackage="com.kangswx.blog.mapper" targetProject="src/main/java"> <property name="enableSubPackages" value="true"/> </javaClientGenerator> <!--生成对应表及类名,domainObjectName是设置实体类的名字的--> <table tableName="t_topic" domainObjectName="Topic" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table> </context> </generatorConfiguration>
-
在上面的配置文件中配置好连接的数据库、连接驱动以及需要生成的表以后,在idea中执行下面的操作,即可自动生成表对应的实体类、Mapper接口和mapping的配置文件
-
具体执行过程如下图
在上图的位置处右击,点击Run Maven Build,即可自动生成表对应的三个文件
SpringBoot整合Mybatis和Mybatis-generator实现代码自动生成
最新推荐文章于 2022-11-22 09:18:43 发布