mybatis逆向工程使用

叁歲伎倆 2022-05-12 01:48 257阅读 0赞

下载地址：  
[http://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core][http_mvnrepository.com_artifact_org.mybatis.generator_mybatis-generator-core]

**生成代码配置文件**

<?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">
            <commentGenerator>
                
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://120.25.162.238:3306/mybatis001?characterEncoding=utf-8" userId="root" password="123">
            </jdbcConnection>
            
    
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="com.iot.ssm.po" targetProject=".\src">
                
                <property name="enableSubPackages" value="false" />
                
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="com.iot.ssm.mapper" targetProject=".\src">
                
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.iot.ssm.mapper" targetProject=".\src">
                
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
            
            <table tableName="items"></table>
            <table tableName="orders"></table>
            <table tableName="orderdetail"></table>
            <table tableName="user"></table>
            
    
            
        </context>
    </generatorConfiguration>

需要注意的位置：

*  javaModelGenerator,生成PO类的位置
 *  sqlMapGenerator,mapper映射文件生成的位置
 *  javaClientGenerator,mapper接口生成的位置
 *  table,指定数据库表

**执行生成程序**

public void generator() throws Exception{
    
        List<String> warnings = new ArrayList<String>();
        boolean overwrite = true;
        //指定逆向工程配置文件
        File configFile = new File("generatorConfig.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);
    
    }

**使用生成的代码**

package com.iot.ssm.mapper;
    
    import static org.junit.Assert.*;
    
    import java.util.Date;
    import java.util.List;
    
    import com.iot.ssm.po.Items;
    import com.iot.ssm.po.ItemsExample;
    import org.junit.Before;
    import org.junit.Test;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    
    public class ItemsMapperTest { 
    
        private ApplicationContext applicationContext;
    
        private ItemsMapper itemsMapper;
    
        //在setUp这个方法得到spring容器
        @Before
        public void setUp() throws Exception {
            applicationContext = new ClassPathXmlApplicationContext("classpath:spring/applicationContext.xml");
            itemsMapper = (ItemsMapper) applicationContext.getBean("itemsMapper");
        }
    
        //根据主键删除 
        @Test
        public void testDeleteByPrimaryKey() {
    
        }
    
        //插入
        @Test
        public void testInsert() {
            //构造 items对象
            Items items = new Items();
            items.setName("手机");
            items.setPrice(999f);
            items.setCreatetime(new Date());
            itemsMapper.insert(items);
        }
    
        //自定义条件查询
        @Test
        public void testSelectByExample() {
            ItemsExample itemsExample = new ItemsExample();
            //通过criteria构造查询条件
            ItemsExample.Criteria criteria = itemsExample.createCriteria();
            criteria.andNameEqualTo("笔记本");
            //可能返回多条记录
            List<Items> list = itemsMapper.selectByExample(itemsExample);
    
            System.out.println(list);
    
        }
    
        //根据主键查询
        @Test
        public void testSelectByPrimaryKey() {
            Items items = itemsMapper.selectByPrimaryKey(1);
            System.out.println(items);
        }
    
        //更新数据
        @Test
        public void testUpdateByPrimaryKey() {
    
            //对所有字段进行更新，需要先查询出来再更新
            Items items = itemsMapper.selectByPrimaryKey(1);
    
            items.setName("手机");
    
            itemsMapper.updateByPrimaryKey(items);
            //如果传入字段不空为才更新，在批量更新中使用此方法，不需要先查询再更新
            //itemsMapper.updateByPrimaryKeySelective(record);
    
        }
    
    }

[http_mvnrepository.com_artifact_org.mybatis.generator_mybatis-generator-core]: http://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core