MyBatis的逆向工程之奢华尊享版

MyBatis的逆向工程之奢华尊享版

逆向工程的配置文件 generatorConfig.xml

将targetRuntime修改为：targetRuntime="MyBatis3"

"1.0" encoding="UTF-8"?>
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/ssm"
                        userId="root"
                        password="123456">
        jdbcConnection>
        
        <javaModelGenerator targetPackage="com.atguigu.mybatis.pojo"
                            targetProject=".\src\main\java">
            <property name="enableSubPackages" value="true"/>
            <property name="trimStrings" value="true"/>
        javaModelGenerator>
        
        <sqlMapGenerator targetPackage="com.atguigu.mybatis.mapper"
                         targetProject=".\src\main\resources">
            <property name="enableSubPackages" value="true"/>
        sqlMapGenerator>
        
        <javaClientGenerator type="XMLMAPPER"
                             targetPackage="com.atguigu.mybatis.mapper" targetProject=".\src\main\java">
            <property name="enableSubPackages" value="true"/>
        javaClientGenerator>
        
        
        
        <table tableName="t_emp" domainObjectName="Emp"/>
        <table tableName="t_dept" domainObjectName="Dept"/>
    context>
generatorConfiguration>

测试

public class MBGTest {
 
    @Test
    public void testMBG(){
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        EmpMapper mapper = sqlSession.getMapper(EmpMapper.class);
 
        //1.根据id来查询数据
        /*Emp emp = mapper.selectByPrimaryKey(1);
        System.out.println(emp);*/
 
        //2.查询所有数据
        /*List list = mapper.selectByExample(null);
        list.forEach(System.out::println);*/
 
        //3.根据条件来查询数据
        /*EmpExample example = new EmpExample();
        example.createCriteria().andEmpNameEqualTo("张三").andAgeGreaterThanOrEqualTo(20);
        example.or().andGenderEqualTo("男");
        List list = mapper.selectByExample(example);
        list.forEach(System.out::println);*/
 
        //4.测试普通修改功能
        /*Emp emp  = new Emp(1,"小黑",null,"女");
        mapper.updateByPrimaryKey(emp);*/
 
        //5.测试选择性修改
        Emp emp  = new Emp(1,"小黑",null,"女");
        mapper.updateByPrimaryKeySelective(emp);
    }
}

原始数据

1.根据id来查询数据

2.查询所有数据

3.根据条件来查询数据

4.测试普通修改功能

5.测试选择性修改

将数据还原为原始数据