本文共 7531 字，大约阅读时间需要 25 分钟。

前言：本人查遍全网教程大多都是烂大街的过时教程（5版本的，要不就是引入SpringBoot的但涉及到Maven包管理的（版本为Maven3）,废话不多说上教程

测试案例环境

mybatis3.5.2

mysql-connector-java8.0.16

mybatis-generator-maven-plugin1.3.5

 

把这段sql程序导入到你的数据库

/* Navicat Premium Data Transfer Source Server         : 本地Demo Source Server Type    : MySQL Source Server Version : 80021 Source Host           : localhost:3306 Source Schema         : mydb Target Server Type    : MySQL Target Server Version : 80021 File Encoding         : 65001 Date: 31/10/2020 15:39:31*/SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for bonus-- ----------------------------DROP TABLE IF EXISTS `bonus`;CREATE TABLE `bonus`  (  `ENAME` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,  `JOB` varchar(9) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,  `SAL` double(7, 2) NULL DEFAULT NULL,  `COMM` double(7, 2) NULL DEFAULT NULL) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of bonus-- ----------------------------INSERT INTO `bonus` VALUES ('sd', 'as', 100.00, 10.00);-- ------------------------------ Table structure for dept-- ----------------------------DROP TABLE IF EXISTS `dept`;CREATE TABLE `dept`  (  `DEPTNO` int(0) NOT NULL,  `DNAME` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,  `LOC` varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,  PRIMARY KEY (`DEPTNO`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of dept-- ----------------------------INSERT INTO `dept` VALUES (10, 'ACCOUNTING', 'NEW YORK');INSERT INTO `dept` VALUES (20, 'RESEARCH', 'DALLAS');INSERT INTO `dept` VALUES (30, 'SALES', 'CHICAGO');INSERT INTO `dept` VALUES (40, 'OPERATIONS', 'BOSTON');-- ------------------------------ Table structure for emp-- ----------------------------DROP TABLE IF EXISTS `emp`;CREATE TABLE `emp`  (  `EMPNO` int(0) NOT NULL,  `ENAME` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,  `JOB` varchar(9) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,  `MGR` int(0) NULL DEFAULT NULL,  `HIREDATE` date NULL DEFAULT NULL,  `SAL` double(7, 2) NULL DEFAULT NULL,  `COMM` double(7, 2) NULL DEFAULT NULL,  `DEPTNO` int(0) NULL DEFAULT NULL,  PRIMARY KEY (`EMPNO`) USING BTREE,  INDEX `FK_DEPTNO`(`DEPTNO`) USING BTREE,  CONSTRAINT `FK_DEPTNO` FOREIGN KEY (`DEPTNO`) REFERENCES `dept` (`DEPTNO`) ON DELETE RESTRICT ON UPDATE RESTRICT) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of emp-- ----------------------------INSERT INTO `emp` VALUES (7369, 'SMITH', 'CLERK', 7902, '1980-12-17', 800.00, NULL, 20);INSERT INTO `emp` VALUES (7499, 'ALLEN', 'SALESMAN', 7698, '1981-02-20', 1600.00, 300.00, 30);INSERT INTO `emp` VALUES (7521, 'WARD', 'SALESMAN', 7698, '1981-02-22', 1250.00, 500.00, 30);INSERT INTO `emp` VALUES (7566, 'JONES', 'MANAGER', 7839, '1981-04-02', 2975.00, NULL, 20);INSERT INTO `emp` VALUES (7654, 'MARTIN', 'SALESMAN', 7698, '1981-09-28', 1250.00, 1400.00, 30);INSERT INTO `emp` VALUES (7698, 'BLAKE', 'MANAGER', 7839, '1981-05-01', 2850.00, NULL, 30);INSERT INTO `emp` VALUES (7782, 'CLARK', 'MANAGER', 7839, '1981-06-09', 2450.00, NULL, 10);INSERT INTO `emp` VALUES (7788, 'SCOTT', 'ANALYST', 7566, '1987-04-19', 3000.00, NULL, 20);INSERT INTO `emp` VALUES (7839, 'KING', 'PRESIDENT', NULL, '1981-11-17', 5000.00, NULL, 10);INSERT INTO `emp` VALUES (7844, 'TURNER', 'SALESMAN', 7698, '1981-09-08', 1500.00, 0.00, 30);INSERT INTO `emp` VALUES (7876, 'ADAMS', 'CLERK', 7788, '1987-05-23', 1100.00, NULL, 20);INSERT INTO `emp` VALUES (7900, 'JAMES', 'CLERK', 7698, '1981-12-03', 950.00, NULL, 30);INSERT INTO `emp` VALUES (7902, 'FORD', 'ANALYST', 7566, '1981-12-03', 3000.00, NULL, 20);INSERT INTO `emp` VALUES (7934, 'MILLER', 'CLERK', 7782, '1982-01-23', 1300.00, NULL, 10);-- ------------------------------ Table structure for salgrade-- ----------------------------DROP TABLE IF EXISTS `salgrade`;CREATE TABLE `salgrade`  (  `GRADE` int(0) NOT NULL,  `LOSAL` double(7, 2) NULL DEFAULT NULL,  `HISAL` double(7, 2) NULL DEFAULT NULL,  PRIMARY KEY (`GRADE`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of salgrade-- ----------------------------INSERT INTO `salgrade` VALUES (1, 700.00, 1200.00);INSERT INTO `salgrade` VALUES (2, 1201.00, 1400.00);INSERT INTO `salgrade` VALUES (3, 1401.00, 2000.00);INSERT INTO `salgrade` VALUES (4, 2001.00, 3000.00);INSERT INTO `salgrade` VALUES (5, 3001.00, 9999.00);SET FOREIGN_KEY_CHECKS = 1;

 maven工程的配置文件（pom.xml）用下面这个

    
        
     
      4.0.0
         
     
      com.java.mybatis_day01
         
     
      mybatis_day01
         
     
      1.0-SNAPSHOT
         
     
      jar
         
         
             
              
                  
       
        org.mybatis
                   
       
        mybatis
                   
       
        3.5.0
               
              
              
                  
       
        mysql
                   
       
        mysql-connector-java
                   
       
        8.0.16
               
              
                  
       
        junit
                   
       
        junit
                   
       
        RELEASE
               
          
         
         
             
                  
                       
        
         org.apache.maven.plugins
                        
        
         maven-compiler-plugin
                        
                            
         1.8                    
         
          1.8
                         
                    
                   
                       
        
         org.mybatis.generator
                        
        
         mybatis-generator-maven-plugin
                        
        
         1.3.5
                        
                            
                             
         
          true
                             
                             
         
          true
                             
         
          src/main/resources/generatorConfig.xml
                         
                        
                        
                            
          
          
           mysql
           
          
           mysql-connector-java
           
          
           8.0.16
           
                         
                    
               
              
                  
                       
        
         src/main/java
                        
                            
         
          **/*.xml
                         
                    
               
          
     
    

完整的项目结构

generatorConfig.xml

 

项目运行效果图

 

转载地址：https://superman.blog.csdn.net/article/details/109403177 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！