Mybatis 逆向工程

mybatis逆向工程

【准备工作】

1. 创建表

2. 创建项目导入依赖坐标

   • mybatis-generator-core 依赖

   • mybatis-generator-maven-plugin 插件

   • mybatisConfig.xml 配置文件

创建表

CREATE TABLE USER(
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(20),
PASSWORD VARCHAR(20)
)

CREATE TABLE role(
id INT PRIMARY KEY AUTO_INCREMENT,
rolename VARCHAR(20)
)

INSERT INTO `role`(`rolename`) VALUES ('后台');
INSERT INTO `role`(`rolename`) VALUES ('前端');
INSERT INTO `role`(`rolename`) VALUES ('客户端');
INSERT INTO `role`(`rolename`) VALUES ('AI');
INSERT INTO `role`(`rolename`) VALUES ('大数据');

CREATE TABLE user_role(
id INT PRIMARY KEY AUTO_INCREMENT,
userid INT,
roleid INT
)

引入坐标

  org.mybatis.generator
  mybatis-generator-core
  1.3.7




   org.mybatis.generator
       mybatis-generator-maven-plugin
          1.3.7
          
          true
                            
src/main/resources/mapper/generatorConfig.xml

修改配置文件

<?xml version="1.0" encoding="UTF-8"?>



    
    
        
            
            
        
        
        
            
        
        
        

        
        
            
        

        
        
            
            
            
            
        
        
        
            
            
        
        
        
            
            
        

        
        

        
    

执行程序

public class GeneratorTest {

    public static void main(String[] args) throws Exception {
        List warnings = new ArrayList();
        boolean overwrite = true;
        // 加载generatorConfig配置文件的路径，切记不要写错
        File configFile = new File("src/main/resources/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);
    }
}