逆向工程_Java

逆向工程：即根据数据库自动生成实体类以及mapper、mapper.xml文件

1、pom.xml文件

<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/maven-v4_0_0.xsd">    <modelVersion>4.0.0</modelVersion>    <groupId>com.zhx</groupId>    <artifactId>ReverseCode</artifactId>    <packaging>war</packaging>    <version>1.0-SNAPSHOT</version>    <name>ReverseCode Maven Webapp</name>    <url>http://maven.apache.org</url>    <dependencies>        <dependency>            <groupId>junit</groupId>            <artifactId>junit</artifactId>            <version>3.8.1</version>            <scope>test</scope>        </dependency>        <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis</artifactId>            <version>3.2.8</version>        </dependency>    </dependencies>    <build>        <plugins>            <plugin>                <groupId>org.mybatis.generator</groupId>                <artifactId>mybatis-generator-maven-plugin</artifactId>                <version>1.3.2</version>                <configuration>                    <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>                    <verbose>true</verbose>                    <overwrite>true</overwrite>                </configuration>                <executions>                    <execution>                        <id>Generate MyBatis Artifacts</id>                        <goals>                            <goal>generate</goal>                        </goals>                    </execution>                </executions>                <dependencies>                    <dependency>                        <groupId>org.mybatis.generator</groupId>                        <artifactId>mybatis-generator-core</artifactId>                        <version>1.3.2</version>                    </dependency>                    <dependency>                        <groupId>com.mchange</groupId>                        <artifactId>c3p0</artifactId>                        <version>0.9.2</version>                    </dependency>                    <dependency>                        <groupId>mysql</groupId>                        <artifactId>mysql-connector-java</artifactId>                        <version>5.1.30</version>                    </dependency>                    <dependency>                        <groupId>org.mybatis</groupId>                        <artifactId>mybatis</artifactId>                        <version>3.2.2</version>                    </dependency>                </dependencies>            </plugin>        </plugins>        <finalName>ReverseCode</finalName>    </build></project>

2、generateConfig.xml文件

<!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="reverse" targetRuntime="MyBatis3">        <commentGenerator>            <!-- 是否去除自动生成的注释 true：是 ： false:否 -->            <property name="suppressAllComments" value="true"/>        </commentGenerator>        <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->        <jdbcConnection                driverClass="com.mysql.jdbc.Driver"                connectionURL="jdbc:mysql://localhost:3306/reverse"                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:生成Entity类的路径 -->        <javaModelGenerator targetProject=".\src\main\java" targetPackage="com.zhx.mybatis.entities">            <!-- enableSubPackages:是否让schema作为包的后缀 -->            <property name="enableSubPackages" value="false"/>            <!-- 从数据库返回的值被清理前后的空格 -->            <property name="trimStrings" value="true"/>        </javaModelGenerator>        <!-- targetProject:XxxMapper.xml映射文件生成的路径 -->        <sqlMapGenerator targetProject=".\src\main\java" targetPackage="com.zhx.mybatis.mappers">            <!-- enableSubPackages:是否让schema作为包的后缀 -->            <property name="enableSubPackages" value="false"/>        </sqlMapGenerator>        <!-- targetPackage：Mapper接口生成的位置 -->        <javaClientGenerator type="XMLMAPPER" targetProject=".\src\main\java"                             targetPackage="com.zhx.mybatis.mappers">            <!-- enableSubPackages:是否让schema作为包的后缀 -->            <property name="enableSubPackages" value="false"/>        </javaClientGenerator>        <!-- 数据库表名字和我们的entity类对应的映射指定。tableName:表名 -->        <table tableName="tbl_book" domainObjectName="Book"/>    </context></generatorConfiguration>

3、运行maven命令：mybatis-generator：generate

4、生成后的项目结构：