Mybatis05_逆向工程

最新推荐文章于 2024-05-19 08:27:26 发布

BLUcoding

最新推荐文章于 2024-05-19 08:27:26 发布

阅读量6.6w

点赞数

分类专栏： Mybatis 文章标签：数据库 mybatis java mysql

本文链接：https://blog.csdn.net/BLU_111/article/details/106135992

版权

Mybatis 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

Mybatis05_逆向工程

数据库 t_user 表结构和内容：
在这里插入图片描述

创建maven工程
pom文件：

<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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.blu</groupId>
  <artifactId>generatorTest</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <dependencies>
  	<dependency>
  		<groupId>org.mybatis</groupId>
  		<artifactId>mybatis</artifactId>
  		<version>3.4.5</version>
  	</dependency>
  	<dependency>
  		<groupId>mysql</groupId>
  		<artifactId>mysql-connector-java</artifactId>
  		<version>8.0.11</version>
  	</dependency>
  	<dependency>
  		<groupId>org.mybatis.generator</groupId>
  		<artifactId>mybatis-generator-core</artifactId>
  		<version>1.3.2</version>
  	</dependency>
  </dependencies>
</project>

resources下创建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="testTables" targetRuntime="MyBatis3">
		<jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
						connectionURL="jdbc:mysql://localhost:3306/mybatis?useUnicode=true&amp;characterEncoding=UTF-8"
						userId="root" password="123456">
		</jdbcConnection>
		<javaModelGenerator targetPackage="com.blu.entity" targetProject="./src/main/java"></javaModelGenerator>
		<sqlMapGenerator targetPackage="com.blu.repository" targetProject="./src/main/java"></sqlMapGenerator>
		<javaClientGenerator type="XMLMAPPER" targetPackage="com.blu.repository" targetProject="./src/main/java"></javaClientGenerator>
		<table tableName="t_user" domainObjectName="User"></table>
	</context>
</generatorConfiguration>

jdbcConnection 配置数据库连接信息
javaModelGenerator 配置 JavaBean 的⽣成策略
sqlMapGenerator 配置 SQL 映射⽂件⽣成策略
javaClientGenerator 配置 Mapper 接⼝的⽣成策略
table 配置⽬标数据表（tableName：表名，domainObjectName：JavaBean 类名）

测试类generatorTest：

package com.blu.test;

import java.io.File;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.mybatis.generator.api.MyBatisGenerator;
import org.mybatis.generator.config.Configuration;
import org.mybatis.generator.config.xml.ConfigurationParser;
import org.mybatis.generator.exception.InvalidConfigurationException;
import org.mybatis.generator.exception.XMLParserException;
import org.mybatis.generator.internal.DefaultShellCallback;

public class generatorTest {
	public static void main(String[] args) {
		List<String> warings = new ArrayList<String>();
		boolean overwrite = true;
		String genCig = "/generatorConfig.xml";
		File configFile = new File(generatorTest.class.getResource(genCig).getFile());
		ConfigurationParser configurationParser = new ConfigurationParser(warings);
		Configuration configuration = null;
		try {
			configuration = configurationParser.parseConfiguration(configFile);
		} catch (IOException e) {
			e.printStackTrace();
		} catch (XMLParserException e) {
			e.printStackTrace();
		}
		DefaultShellCallback callback = new DefaultShellCallback(overwrite);
		MyBatisGenerator myBatisGenerator = null;
		try {
			myBatisGenerator = new MyBatisGenerator(configuration, callback, warings);
		} catch (InvalidConfigurationException e) {
			e.printStackTrace();
		}
		try {
			myBatisGenerator.generate(null);
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		} catch (InterruptedException e) {
			e.printStackTrace();
		}
	}
}