MyBatis 创建逆向工程，实现自动生成 mapper.java、mapper.xml、pojo…

柔情只为你懂 2023-06-29 10:53 4阅读 0赞

![20200112144054581.png][]

![2020011214410699.png][]

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="suppressDate" value="true" />
    			<property name="suppressAllComments" value="true" />
    		</commentGenerator>
    		
    		<jdbcConnection driverClass="oracle.jdbc.OracleDriver"
    			connectionURL="jdbc:oracle:thin:@localhost:1521:orcl" userId="sys as sysdba"
    			password="123456" />		
    		
    		<javaTypeResolver>
    			
    			<property name="forceBigDecimals" value="false"/>
    		</javaTypeResolver>
    		
    		<javaModelGenerator
    			targetPackage="org.cjr.entity" targetProject=".\src">
    			
    			<property name="enableSubPackages" value="false" />
    			
    			<property name="trimString" value="true" />
    		</javaModelGenerator>
    		
    		<sqlMapGenerator targetPackage="org.cjr.mapper"
    			targetProject=".\src">	
    		</sqlMapGenerator>
    		
    		<javaClientGenerator type="XMLMAPPER"
    			targetPackage="org.cjr.mapper" targetProject=".\src">
    		</javaClientGenerator>
    		
    		<table tableName="Student"></table>
    		<table tableName="StudentCard"></table>	
    		<table tableName="StudentClass"></table>
    	</context>
    </generatorConfiguration>

3.工具类

package org.cjr.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 Test {
    	
    	public static void main(String[] args) throws IOException, XMLParserException, InvalidConfigurationException, SQLException, InterruptedException {
    		
    		List<String> warning = new ArrayList<>();
    		
    		File  file = new File("src/generator.xml");
    		
    		ConfigurationParser cp = new ConfigurationParser(warning);
    			
    		Configuration config = cp.parseConfiguration(file); 
    		
    		DefaultShellCallback callback = new DefaultShellCallback(true);
    		
    		MyBatisGenerator generator = new MyBatisGenerator(config,callback,warning);
    		generator.generate(null);
    	}
    
    }

执行Test 就可以生成结构了

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM5ODg5_size_16_color_FFFFFF_t_70][]

最后，我们写一个 查询 来测试功能；

public class test1111 {
    
    	public static void main(String[] args) throws IOException {
    
    		Reader reader = Resources.getResourceAsReader("config.xml");
    
    		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
    
    		SqlSession session = sqlSessionFactory.openSession();
    		/*
    		 * 1.实现接口 2.然后接口文件的名称 与 xml中的namespace形成映射 自动绑定配置
    		 */
    		StudentMapper studentmapper = session.getMapper(StudentMapper.class);
    		// example 中Criteria 的查询条件
    		StudentExample example = new StudentExample();
    
    		Criteria criteria = example.createCriteria();
              
    		List<Student> student = studentmapper.selectByExample(example);
    		
    		System.out.println(student);
    		
    	}
    }

运行结果

![20200112144322345.png][]

[20200112144054581.png]: https://img-blog.csdnimg.cn/20200112144054581.png
[2020011214410699.png]: https://img-blog.csdnimg.cn/2020011214410699.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM5ODg5_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200112144224228.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM5ODg5,size_16,color_FFFFFF,t_70
[20200112144322345.png]: https://img-blog.csdnimg.cn/20200112144322345.png