Day41——MyBatis逆向工程

一时失言乱红尘 2023-07-04 15:49 5阅读 0赞

# 一. 知识储备 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNjM0ODQ2_size_16_color_FFFFFF_t_70]

# 二. 例子 #

导入jar 包：mybatis-generator-core-1.3.2.jar

在工程项目的目录下创建mbg.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">
        
        <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/bookstore_0416" userId="root" password="123456">
        </jdbcConnection>
    
    	
        <javaModelGenerator targetPackage="com.atguigu.mybatis.beans" targetProject=".\src">
          <property name="enableSubPackages" value="true" />
          <property name="trimStrings" value="true" />
        </javaModelGenerator>
    	
    	
        <sqlMapGenerator targetPackage="com.atguigu.mybatis.dao" targetProject=".\conf">
          <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
    	
    	
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.atguigu.mybatis.dao" targetProject=".\src">
          <property name="enableSubPackages" value="true" />
        </javaClientGenerator>
    	
    	
        <table tableName="tbl_dept" domainObjectName="Department"></table>
        <table tableName="tbl_employee" domainObjectName="Employee"></table>
    
      </context>
    </generatorConfiguration>

TestMyBatis.java

//测试
    @Test
    	public void testMyBatis3() throws Exception{ 
    		SqlSessionFactory ssf = getSqlSessionFactory();
    		SqlSession session = ssf.openSession();
    		
    		try { 
    				EmployeeMapper mapper = session.getMapper(EmployeeMapper.class);
    				
    				//QBC: Query By Criteria
    				
    				//查询：查询名字中带有“老师”并且 性别是男的 或者 邮箱中带有'b'
    				EmployeeExample example = new EmployeeExample();
    				//封装条件 Criteria
    				Criteria c1 = example.createCriteria();
    				c1.andLastNameLike("%老师%");
    				c1.andGenderEqualTo("1");
    				
    				//对于or的条件需要重新封装到Criteria中
    				Criteria c2 = example.createCriteria();
    				c2.andEmailLike("%b%");
    				
    				//封装or条件的Criteria需要or到example中
    				example.or(c2);
    				
    				
    				List<Employee> emps = mapper.selectByExample(example);
    				System.out.println(emps);
    			
    			
    		} finally { 
    			// TODO: handle finally clause
    			session.close();
    		}
    		
    	}
    
    
    //运行即可创建逆向工程
    @Test
    	public void testMbg() throws Exception{ 
    		List<String> warnings = new ArrayList<String>();
    		   boolean overwrite = true;
    		   File configFile = new File("mbg.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);
    	}

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNjM0ODQ2_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200212193126972.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNjM0ODQ2,size_16,color_FFFFFF,t_70