idea逆向工程的使用

1.创建一个maven工程
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>

    <groupId>com.zz</groupId>
    <artifactId>aaa</artifactId>
    <version>1.0-SNAPSHOT</version>
    <build>
        <finalName>zsxt</finalName>
        <plugins>
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <configuration>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                </configuration>

                <dependencies>
                    <!--此处添加一个mysql-connector-java依赖可以防止找不到jdbc Driver-->
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>5.1.28</version>
                        <scope>runtime</scope>
                    </dependency>

                </dependencies>

            </plugin>
        </plugins>

    </build>

    
</project>

2.resources下创建generator.properties和generatorConfig.xml

generator.properties代码

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/pinyougoudb?useUnicode=true&char
acterEncoding=utf8&autoReconnect=true
jdbc.username=root
jdbc.password=root

generatorConfig.xml代码

<?xml version="1.0" encoding="UTF-8"?>

	<!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和 
		NUMERIC 类型解析为java.math.BigDecimal -->
	<javaTypeResolver>
		<property name="forceBigDecimals" value="false" />
	</javaTypeResolver>

	<!-- targetProject:生成PO类的位置 -->
	<javaModelGenerator targetPackage="com.pinyougou.pojo"
		targetProject=".\src">
		<!-- enableSubPackages:是否让schema作为包的后缀 -->
		<property name="enableSubPackages" value="false" />
		<!-- 从数据库返回的值被清理前后的空格 -->
		<property name="trimStrings" value="true" />
	</javaModelGenerator>
    <!-- targetProject:mapper映射文件生成的位置 -->
	<sqlMapGenerator targetPackage="com.pinyougou.mapper" 
		targetProject=".\resource">
		<!-- enableSubPackages:是否让schema作为包的后缀 -->
		<property name="enableSubPackages" value="false" />
	</sqlMapGenerator>
	<!-- targetPackage：mapper接口生成的位置 -->
	<javaClientGenerator type="XMLMAPPER"
		targetPackage="com.pinyougou.mapper" 
		targetProject=".\src">
		<!-- enableSubPackages:是否让schema作为包的后缀 -->
		<property name="enableSubPackages" value="false" />
	</javaClientGenerator>
	<!-- 指定数据库表 -->
	<table schema="" tableName="tb_address"></table>
	<table schema="" tableName="tb_areas"></table>
	<table schema="" tableName="tb_brand"></table>
	<table schema="" tableName="tb_cities"></table>
	<table schema="" tableName="tb_content"></table>
	<table schema="" tableName="tb_content_category"></table>
	<table schema="" tableName="tb_freight_template"></table>
	<table schema="" tableName="tb_goods"></table>
	<table schema="" tableName="tb_goods_desc"></table>
	<table schema="" tableName="tb_item"></table>
	<table schema="" tableName="tb_item_cat"></table>
	<table schema="" tableName="tb_item_spec_option"></table>
	<table schema="" tableName="tb_order"></table>
	<table schema="" tableName="tb_order_item"></table>
	<table schema="" tableName="tb_pay_log"></table>
	<table schema="" tableName="tb_provinces"></table>
	<table schema="" tableName="tb_seller"></table>
	<table schema="" tableName="tb_specification"></table>
	<table schema="" tableName="tb_specification_option"></table>
	<table schema="" tableName="tb_type_template"></table>
	<table schema="" tableName="tb_user"></table>
	
	<!-- 有些表的字段需要指定java类型
	<table schema="" tableName="">
		<columnOverride column="" javaType="" />
	</table> -->
</context>