day51-Mybatis-Plus/代码生成器

定义：是一个Mybatis的增强工具，只在Mybatis基础上增强不做改变，简化开发，提升效率

2.1  创建springboot工程，勾选web，引入依赖

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.36</version>
</dependency>
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
</dependency>
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.0.6</version>
</dependency>

2.2  安装lombok插件

2.3  实体类中加入注解

2.4  UserMapper接口中加入注解，并继承BaseMapper<>（其中增删改查方法已经写好）

2.5  测试

2.6  配置文件中加入日志配置，控制台显示日志详细信息

2.7 设置自增长步骤： 

（1）设置数据库表主键和自增长

（2）指定数据库自增长序列从6开始：ALTER TABLE user AUTO_INCREMENT = 6;

（3）设置实体类：添加注解

（4）测试添加功能，可以实现无id通过自增长添加

2.8  三种方式查询

2.9  分页

（1）加入分页拦截器

（2）测试

2.10  删除

2.11 条件查询器

（2）模糊查询

（3）between..and..条件查询

依赖：

<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.36</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.0.6</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
            <version>3.4.0</version>
        </dependency>
        <dependency>
            <groupId>org.apache.velocity</groupId>
            <artifactId>velocity-engine-core</artifactId>
            <version>2.2</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

生成器脚本：

package cn.kgc.test;import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.config.DataSourceConfig;
import com.baomidou.mybatisplus.generator.config.GlobalConfig;
import com.baomidou.mybatisplus.generator.config.PackageConfig;
import com.baomidou.mybatisplus.generator.config.StrategyConfig;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;public class CodeGenerator {public static void main(String[] args) {// 代码生成器AutoGenerator mpg = new AutoGenerator();// 1全局配置GlobalConfig gc = new GlobalConfig();String projectPath = System.getProperty("user.dir");//获得工程路径gc.setOutputDir(projectPath + "/src/main/java");//路径gc.setAuthor("kgc_sh");//作者gc.setOpen(false);mpg.setGlobalConfig(gc);// 2数据源配置DataSourceConfig dsc = new DataSourceConfig();dsc.setUrl("jdbc:mysql://localhost:3306/db_02?useUnicode=true&useSSL=false&characterEncoding=utf8");// dsc.setSchemaName("public");dsc.setDriverName("com.mysql.jdbc.Driver");dsc.setUsername("root");dsc.setPassword("123456");dsc.setDbType(DbType.MYSQL);//数据库类型mpg.setDataSource(dsc);// 3包配置PackageConfig pc = new PackageConfig();pc.setParent("cn.kgc");pc.setEntity("entity");pc.setMapper("mapper");pc.setService("service");pc.setController("controller");mpg.setPackageInfo(pc);// 4策略配置StrategyConfig strategy = new StrategyConfig();strategy.setInclude("student","sc","course","teacher"); //给哪些表生成代码====================strategy.setNaming(NamingStrategy.underline_to_camel);strategy.setColumnNaming(NamingStrategy.underline_to_camel);strategy.setEntityLombokModel(true);mpg.setStrategy(strategy);mpg.execute();}
}