接着上一篇的文章,第一篇中写了一个小demo,mybatis-plus已经对简单CRUD进行了封装。业务上需要根据需求来自行添加。开始第二篇:
具体的创建工程就不说了,第一篇有。
创建新的子工程:
1.引入pom依赖:
标签中的名称改成自己的
<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<project xmlns=\"http://maven.apache.org/POM/4.0.0\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"
xsi:schemaLocation=\"http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd\">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.1.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.cd</groupId>
<artifactId>rm-autogenerator</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>rm-autogenerator</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-freemarker</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--lombok用来简化实体类-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<!--mybatis-plus-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.0.6</version>
</dependency>
<!--连接数据库-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<!--测试类-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!--代码生成-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-generator</artifactId>
<version>3.0.6</version>
<scope>compile</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
2.新建一个mybatis-plus.properties
可以更改代码生成的位置,还可以更改名称…等等
#生成代码的位置(本地目录)
OutputDir=D:/cd-Test/mybatis-plusx/rm-autogenerator/src/main/java
#mapper.xml的位置(本地目录)
OutputDirXml=D:/cd-Test/mybatis-plusx/rm-autogenerator/src/main/resources
#表名
tableName=user
#包名后缀
className=crm
#????
author=ccc
#生成代码的位置在那个包下
#父包的路径
parent=com.cd
#连接数据库
url=jdbc:mysql://localhost:3306/数据库名?useUnicode=true&characterEncoding=utf-8&tinyInt1isBit=false
userName=youname
password=youpassword
3.创建一个代码生成包
用来获取mybatis-plus.properties
package com.cd.mybatisplusgenrator;
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.core.toolkit.StringPool;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.InjectionConfig;
import com.baomidou.mybatisplus.generator.config.*;
import com.baomidou.mybatisplus.generator.config.po.TableInfo;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;
import java.util.ArrayList;
import java.util.List;
import java.util.ResourceBundle;
public class MpGenerator {
public static void main(String[] args) throws InterruptedException {
//用来获取Mybatis-Plus.properties文件的配置信息
final ResourceBundle rb = ResourceBundle.getBundle(\"mybatis-plus\");
// 代码生成器
AutoGenerator mpg = new AutoGenerator();
// 全局配置
GlobalConfig gc = new GlobalConfig();
gc.setOutputDir(rb.getString(\"OutputDir\"));
gc.setOpen(false);
gc.setBaseResultMap(true);
gc.setBaseColumnList(true);
gc.setAuthor(rb.getString(\"author\"));
gc.setMapperName(\"%sMapper\");
gc.setXmlName(\"%sMapper\");
gc.setServiceName(\"%sService\");
gc.setServiceImplName(\"%sServiceImpl\");
gc.setControllerName(\"%sController\");
mpg.setGlobalConfig(gc);
// 数据源配置
DataSourceConfig dsc = new DataSourceConfig();
dsc.setDbType(DbType.MYSQL);
dsc.setUrl(rb.getString(\"url\"));
dsc.setDriverName(\"com.mysql.jdbc.Driver\");
dsc.setUsername(rb.getString(\"userName\"));
dsc.setPassword(rb.getString(\"password\"));
mpg.setDataSource(dsc);
// 包配置
PackageConfig pc = new PackageConfig();
pc.setParent(rb.getString(\"parent\"));
pc.setController(\"controller.\" + rb.getString(\"className\"));
pc.setService(\"service.\" + rb.getString(\"className\"));
pc.setServiceImpl(\"service.\" + rb.getString(\"className\") + \".impl\");
pc.setEntity(\"bean.\" + rb.getString(\"className\"));
pc.setMapper(\"dao.\" + rb.getString(\"className\"));
mpg.setPackageInfo(pc);
// 自定义配置
InjectionConfig cfg = new InjectionConfig() {
@Override
public void initMap() {
// to do nothing
}
};
List<FileOutConfig> focList = new ArrayList<>();
focList.add(new FileOutConfig(\"/templates/mapper.xml.ftl\") {
@Override
public String outputFile(TableInfo tableInfo) {
// 自定义输入文件名称
return rb.getString(\"OutputDirXml\") + \"/mapper/\" + rb.getString(\"className\") + \"/\" + tableInfo.getEntityName() + StringPool.DOT_XML;
}
});
cfg.setFileOutConfigList(focList);
mpg.setCfg(cfg);
mpg.setTemplate(new TemplateConfig().setXml(null));
// 策略配置
StrategyConfig strategy = new StrategyConfig();
strategy.setNaming(NamingStrategy.underline_to_camel);
strategy.setColumnNaming(NamingStrategy.underline_to_camel);
strategy.setEntityLombokModel(true);
strategy.setInclude(new String[]{rb.getString(\"tableName\")});
mpg.setStrategy(strategy);
mpg.setTemplateEngine(new FreemarkerTemplateEngine());
mpg.execute();
}
}
这样就可以运行一下生成代码的类了。
4.可以来测试一下了
4.1:首先application.yml文件需要有:
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=true
username: root
password: 1234
4.2:
4.3启动类上添加@MapperScan(“com.cd.dao.crm”)注解
package com.cd;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan(\"com.cd.dao.crm\")//写自己的mqpper位置
public class RmAutogeneratorApplication {
public static void main(String[] args) {
SpringApplication.run(RmAutogeneratorApplication.class, args);
}
}
4.3:在单元测试中测试
package com.cd;
import com.cd.bean.crm.User;
import com.cd.dao.crm.UserMapper;
import org.junit.Assert;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
import java.util.List;
@RunWith(SpringRunner.class)
@SpringBootTest
public class RmAutogeneratorApplicationTests {
@Autowired
private UserMapper userMapper;
@Test
public void contextLoads() {
System.out.println((\"----- selectAll method test ------\"));
List<User> userList = userMapper.selectList(null);
Assert.assertEquals(5, userList.size());
userList.forEach(System.out::println);
}
}
over!
版权声明
本文仅代表作者观点,不代表百度立场。
本文系作者授权百度百家发表,未经许可,不得转载。




