一、什么是逆向工程?
简单点说,就是通过数据库中的单表,自动生成java代码。
Mybatis官方提供了逆向工程,可以针对单表自动生成mybatis代码(mapper.java\mapper.xml\po类)
下面上实例
首先第一步 在src下创建 generator.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>
<!-- classPathEntry:数据库的JDBC驱动的jar包地址 -->
<context id="DB2Tables" targetRuntime="MyBatis3">
<commentGenerator>
<!-- <property name="suppressAllComments" value="true" /> -->
<property name="suppressDate" value="true" />
<property name="javaFileEncoding" value="UTF-8" />
</commentGenerator>
<!-- 数据库链接URL、用户名、密码 -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/licong?useSSL=false&serverTimezone=Hongkong&characterEncoding=utf-8&autoReconnect=true"
userId="root" password="123">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!-- 生成model模型和位置pojo -->
<javaModelGenerator targetPackage="pojo"
targetProject=".\src">
<property name="enableSubPackages" value="false" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- 生成的SQL映射文件包名和位置mapper -->
<sqlMapGenerator targetPackage="mapper"
targetProject=".\src">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!-- 生成DAO的包名和位置mapper接口,这里写 mapper-->
<javaClientGenerator type="XMLMAPPER"
targetPackage="mapper" targetProject=".\src">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<!-- 指定表名 -->
<table schema="" tableName="count"></table>
<!-- <table schema="" tableName="vehicle"></table> -->
</context>
</generatorConfiguration>
然后新建一个java类 代码如下
package gen;
import java.io.File;
import java.io.Reader;
import java.util.ArrayList;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.junit.Test;
import org.mybatis.generator.api.MyBatisGenerator;
import org.mybatis.generator.config.Configuration;
import org.mybatis.generator.config.xml.ConfigurationParser;
import org.mybatis.generator.internal.DefaultShellCallback;
public class generator {
public static void main(String[] args) throws Exception {
List<String> warnings = new ArrayList<String>();
boolean overwrite = true;
Reader reader=Resources.getResourceAsReader("generator.xml");
File configFile = new File("generator.xml");
ConfigurationParser cp = new ConfigurationParser(warnings);
Configuration config = cp.parseConfiguration(reader);
DefaultShellCallback callback = new DefaultShellCallback(overwrite);
MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
myBatisGenerator.generate(null);
}
}
然后运行此代码 刷新项目
你会看到自动生成的代码
代码我就不上了
生成以后直接测试 测试代码和之前的大同小异
package gen;
import java.io.IOException;
import java.io.InputStream;
import mapper.CountMapper;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;
import pojo.Count;
public class test {
private SqlSessionFactory sqlf;
@Before
public void setup() throws IOException{
InputStream input=Resources.getResourceAsStream("SqlMapConfig.xml");
sqlf=new SqlSessionFactoryBuilder().build(input);
}
@Test
public void tests(){
SqlSession sql=sqlf.openSession();
CountMapper cc=sql.getMapper(CountMapper.class);
Count co=new Count();
co.setId(1);
Count count=cc.selectByPrimaryKey(co.getId());
System.out.println(count);
sql.close();
}
}
还有一些配置文件 和之前基本相同 可以看看上一篇