尚筹网：逆向工程如何搭建

- 日理万妓 2023-06-22 09:25 25阅读 0赞

# 创建数据库和数据库表 #

## 创建数据库 ##

CREATE DATABASE `atcrowdfunding190105` CHARACTER SET utf8

## 创建管理员数据库表 ##

drop table if exists t_admin;
    
    create table t_admin
    (
       id                   int not null auto_increment,
       login_acct            varchar(255) not null,
       user_pswd             char(32) not null,
       user_name             varchar(255) not null,
       email                varchar(255) not null,
       create_time           char(19),
       primary key (id)
    );

# 基于Maven的MyBatis逆向工程 #

## 创建maven工程 ##

0、建议逆向工程从项目本身独立出来。  
1、new ---- 》 Maven Projetc----》选择 Create a simple project(skip archetype selection)  
2、在Artifact部分中：

*  group id：com.atguigu.crowd.funding
 *  artifact id：atcrowdfunding-reverse
 *  package：jar

## pom.xml配置 ##

<dependencies>
    	<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.0</version>
    
    			
    			<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>8.0.15</version>
    				</dependency>
    			</dependencies>
    		</plugin>
    	</plugins>
    </build>

## generatorConfig.xml配置 ##

在src/main/resources目录下创建**generatorConfig.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="atguiguTables" targetRuntime="MyBatis3">
    		<commentGenerator>
    			
    			<property name="suppressAllComments" value="true" />
    		</commentGenerator>
    
    		
    		<jdbcConnection 
    			driverClass="com.mysql.cj.jdbc.Driver"
    			connectionURL="jdbc:mysql://localhost:3306/atcrowdfunding190105?useUnicode=true&characterEncoding=utf-8" 
    			userId="root"
    			password="123456">
    		</jdbcConnection>
    
    		
    		<javaTypeResolver>
    			<property name="forceBigDecimals" value="false" />
    		</javaTypeResolver>
    
    		
    		<javaModelGenerator targetProject=".\src\main\java"
    			targetPackage="com.atguigu.crowd.funding.entity">
    			
    			<property name="enableSubPackages" value="false" />
    			
    			<property name="trimStrings" value="true" />
    		</javaModelGenerator>
    
    		
    		<sqlMapGenerator targetProject=".\src\main\java"
    			targetPackage="com.atguigu.crowd.funding.mapper">
    			
    			<property name="enableSubPackages" value="false" />
    		</sqlMapGenerator>
    
    		
    		<javaClientGenerator type="XMLMAPPER"
    			targetProject=".\src\main\java"
    			targetPackage="com.atguigu.crowd.funding.mapper">
    			
    			<property name="enableSubPackages" value="false" />
    		</javaClientGenerator>
    
    		
    		<table tableName="t_admin" domainObjectName="Admin" />
    
    	</context>
    </generatorConfiguration>

## 执行逆向生成操作的Maven命令 ##

1、选择pom.xml----》 Run as —》 Maven build … —》将Goal的值设置为：**mybatis-generator:generate**\----》Run  
2、然后刷新  
![在这里插入图片描述][20191215182519135.png]  
3、调整Admin.java：生成无参构造器、有参构造器和toString方法

## 逆向工程生成的资源各归各位 ##

1、将atcrowdfunding-reverse/src/main/java目录下的com.atguigu.crowd.funding.entity包调整到atcrowdfunding-admin-4-entity模块的/src/main/java下

2、atcrowdfunding-reverse/src/main/java目录下的com.atguigu.crowd.funding.mapper包放到component模块的/src/main/java下【可能会缺少一个org.acache包，暂时不处理】。

3、在atcrowdfunding-admin-1-webui模块的/src/main/resources下创建一个mybatis/mapper目录，然后将com.atguigu.crowd.funding.mapper包的AdminMapper.xml放在atcrowdfunding-admin-1-webui模块的/src/main/resources下  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][20191215183328233.png]

[20191215182519135.png]: https://img-blog.csdnimg.cn/20191215182519135.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191215183308272.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg==,size_16,color_FFFFFF,t_70
[20191215183328233.png]: https://img-blog.csdnimg.cn/20191215183328233.png