day51-Mybatis-Plus/代码生成器

1.Mybatis-Plus

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

2.MP实战

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..条件查询

3.代码生成器

依赖： <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();} }