SSM2

SSM2.6 的整合–逆向工程

Spring –> Service

Spring MVC –> 表现层

Mybatis –> Dao

逆向工程

1. 新建maven项目

2. 修改pom文件

   <?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>cn.cxg.ssm</groupId>
       <artifactId>SSM-mybatis</artifactId>
       <version>1.0-SNAPSHOT</version>
       <build>
           <plugins>
               <!-- mybatis-generator自动生成代码插件 -->
               <plugin>
                   <groupId>org.mybatis.generator</groupId>
                   <artifactId>mybatis-generator-maven-plugin</artifactId>
                   <version>1.3.6</version>
               </plugin>
           </plugins>
       </build>
       <dependencies>
           <dependency>
               <groupId>log4j</groupId>
               <artifactId>log4j</artifactId>
               <version>1.2.17</version>
           </dependency>
   
           <!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core -->
   		<!--生成po、mapper.java、mapper.xml核心jar-->
           <dependency>
               <groupId>org.mybatis.generator</groupId>
               <artifactId>mybatis-generator-core</artifactId>
               <version>1.3.5</version>
           </dependency>
   
           <!--<!—mybatis核心&ndash;&gt;-->
           <dependency>
               <groupId>org.mybatis</groupId>
               <artifactId>mybatis</artifactId>
               <version>3.2.3</version>
           </dependency>
           <!--<!—数据库&ndash;&gt;-->
           <dependency>
               <groupId>mysql</groupId>
               <artifactId>mysql-connector-java</artifactId>
               <version>8.0.13</version>
           </dependency>
           
   
       </dependencies>
   </project>
   

3. 在项目 主目录下建立mybatis-generator的配置文件，名字可以随意，我这里叫 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="DB2Tables" targetRuntime="MyBatis3">
           <commentGenerator>
               <property name="suppressAllComments" value="true" />
           </commentGenerator>
           <!-- 配置数据库连接 -->
           <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                           connectionURL="jdbc:mysql://localhost:3306/manong" userId="root"
                           password="root">
           </jdbcConnection>
   
           <javaTypeResolver>
               <property name="forceBigDecimals" value="false" />
           </javaTypeResolver>
   
           <!-- 指定javaBean生成的位置 -->
           <javaModelGenerator targetPackage="com.njau.pojo"
                               targetProject=".\src\main\java">
               <property name="enableSubPackages" value="true" />
               <property name="trimStrings" value="true" />
           </javaModelGenerator>
   
           <!--指定sql映射文件生成的位置 -->
           <sqlMapGenerator targetPackage="com.njau.mapper" targetProject=".\src\main\java">
               <property name="enableSubPackages" value="true" />
           </sqlMapGenerator>
   
           <!-- 指定dao接口生成的位置，mapper接口 -->
           <javaClientGenerator type="XMLMAPPER"
                                targetPackage="com.njau.mapper" targetProject=".\src\main\java">
               <property name="enableSubPackages" value="true" />
           </javaClientGenerator>
   
   
           <!-- table指定每个表的生成策略 -->
           <table tableName="user" domainObjectName="User"></table>
           <table tableName="product" domainObjectName="Product"></table>
           <table tableName="product_category" domainObjectName="ProductCategory"></table>
       </context>
   </generatorConfiguration>
   

4. 建立主函数

   public static void main(String[] args) throws Exception{
   				List<String> warnings = new ArrayList<String>();
   				boolean overwrite = true;
   				File configFile = new File("generatorConfig.xml");
   				ConfigurationParser cp = new ConfigurationParser(warnings);
   				Configuration config = cp.parseConfiguration(configFile);
   				DefaultShellCallback callback = new DefaultShellCallback(overwrite);
   				MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
   				myBatisGenerator.generate(null);
   		}
   

5. 运行主函数，生成所需要的文件和目录

   

将生成的 .xml 文件复制时要放到resources中，应为只有resources中的资源文件才会被编译！