之前文章有整合过springboot整合mybatis自动生成代码,之前的版本xml文件中还需要有sql语句
使用mybatis-plus这个版本生成代码单表不需要再写xml的sql语句
同时,自动的代码生成越来越多,开发速度提高了,也隐约的让我有了危机感,还是需要不断的去学习接受新的技术事物,
研究基础底层原理,并发包,分布式微服务等原理等
首先引入依赖
<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>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.0.5</version>
</dependency>
配置application.yml
# 配置mybatis-plus
mybatis-plus:
# 配置扫描xml
mapper-locations:
- classpath:mapper/*.xml
# 实体扫描,多个package用逗号或者分号分隔
type-aliases-package: com.ahut.entity
global-config:
# 逻辑删除配置
logic-delete-value: 0
logic-not-delete-value: 1
sql-injector: com.baomidou.mybatisplus.mapper.LogicSqlInjector
使用代码生成器自动生成代码
package com.demo.controller;
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.IdType;
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.po.TableFill;
import com.baomidou.mybatisplus.generator.config.rules.DateType;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
import java.util.ArrayList;
/**
* @author leiliang
* @date 2021-3-22
* @email 代码生成器
*/
public class Code {
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.setOutputDir("E://code");
gc.setAuthor("leiliang"); //设置作者姓名
gc.setOpen(false);
gc.setFileOverride(false); //是否覆盖
gc.setServiceName("%sService"); //去除service的I前缀(如果不设置service前面将会多一个I)
gc.setIdType(IdType.ID_WORKER);
gc.setDateType(DateType.ONLY_DATE);
gc.setSwagger2(false);
//xml文件相关
gc.setActiveRecord(false);// 不需要ActiveRecord特性的请改为false
gc.setEnableCache(false);// XML 二级缓存
gc.setBaseResultMap(true);// XML ResultMap
gc.setBaseColumnList(true);// XML columList
mpg.setGlobalConfig(gc);
//2、配置数据源
DataSourceConfig dsc = new DataSourceConfig();
dsc.setUrl("jdbc:mysql://localhost:3306/test?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8");
dsc.setDriverName("com.mysql.jdbc.Driver");
dsc.setUsername("root");
dsc.setPassword("root");
dsc.setDbType(DbType.MYSQL);
mpg.setDataSource(dsc);
//3、配置包
PackageConfig pc = new PackageConfig();
pc.setParent("com.wisdom.travel"); //设置生成在哪个父包下
pc.setEntity("pojo"); //设置实体类包名
pc.setMapper("mapper");
pc.setService("service");
pc.setController("controller");
mpg.setPackageInfo(pc);
//4、策略配置
StrategyConfig strategy = new StrategyConfig();
//设置需要生成的表 //设置要映射的表(可包含多个)
strategy.setInclude(new String[]{"student"});
//strategy.setExclude("article"); //也可设置不需要映射的表
strategy.setNaming(NamingStrategy.underline_to_camel);
strategy.setColumnNaming(NamingStrategy.underline_to_camel);
strategy.setEntityLombokModel(true);
//strategy.setLogicDeleteFieldName("deleted"); //设置逻辑删除字段
TableFill createTime = new TableFill("create_time", FieldFill.INSERT);
TableFill updateTime = new TableFill("update_time", FieldFill.INSERT_UPDATE);
ArrayList<TableFill> tableFills = new ArrayList<>();
tableFills.add(createTime);
tableFills.add(updateTime);
strategy.setTableFillList(tableFills);
//乐观锁
//strategy.setVersionFieldName("version");
strategy.setRestControllerStyle(true);
strategy.setControllerMappingHyphenStyle(true);
mpg.setStrategy(strategy);
//执行
mpg.execute();
}
}
生成后的结构
继承接口CRUD
可以看到,代码生成器为我们生成了我们平时必须自己完成的entity、mapper、mapperXml、service、serviceImpl和controller文件,那么让我们来看看他是如何做到简化我们的文件的。、
首先来看entity文件,它与正常的entity的不同在于他继承了Model类,这个类为我们提供了单体操作的CRUD,不过正常我们还是会使用继承了BaseMapper接口的mapper来进行CRUD。
接下来是在entity类属性上的注解@TableId和@TableField,前者是标识当前表的主键,用于对应其中的selectById和deleteById等方法;后者则是用于属性名与数据库列名不一致的情况,为防止属性注入失败而生的注解。
package com.wisdom.travel.pojo;
import java.io.Serializable;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.Version;
import lombok.Data;
import lombok.EqualsAndHashCode;
/**
* <p>
*
* </p>
*
* @author leiliang
* @since 2021-03-22
*/
@Data
@EqualsAndHashCode(callSuper = false)
public class Student implements Serializable {
private static final long serialVersionUID = 1L;
/**
* id
*/
@TableId
private Integer id;
/**
* 名字
*/
@TableField("name")
private String name;
/**
* cid
*/
@TableField("cid")
private Integer cid;
/**
* 学校
*/
@TableField("school")
private String school;
/**
* 版本号
*/
@Version
private Integer version;
}
改造控制层如下
package com.wisdom.travel.controller;
import com.demo.pojo.User;
import com.wisdom.travel.pojo.Student;
import com.wisdom.travel.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
/**
* <p>
* 前端控制器
* </p>
*
* @author leiliang
* @since 2021-03-22
*/
@RestController
@RequestMapping("/student")
public class StudentController {
@Autowired
StudentService studentService;
@RequestMapping("/queryList")
@ResponseBody
public List<Student> queryList() {
List<Student> list = studentService.queryList();
return list;
}
}
service层例子 提供了许多的方法可以直接调用
package com.wisdom.travel.service;
import com.wisdom.travel.pojo.Student;
import com.baomidou.mybatisplus.extension.service.IService;
import java.util.List;
/**
* <p>
* 服务类
* </p>
*
* @author leiliang
* @since 2021-03-22
*/
public interface StudentService extends IService<Student> {
List<Student> queryList();
}
package com.wisdom.travel.service.impl;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.wisdom.travel.pojo.Student;
import com.wisdom.travel.mapper.StudentMapper;
import com.wisdom.travel.service.StudentService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;
import java.util.List;
/**
* <p>
* 服务实现类
* </p>
*
* @author leiliang
* @since 2021-03-22
*/
@Service
public class StudentServiceImpl extends ServiceImpl<StudentMapper, Student> implements StudentService {
@Override
public List<Student> queryList() {
//参考 QueryWrapper条件构造器 https://mp.baomidou.com/guide/wrapper.html#abstractwrapper
//构造条件查询
QueryWrapper<Student> wrapper = new QueryWrapper();
List<Student> list = this.list(wrapper);
//新增
Student student = new Student();
this.save(student);
//修改
Student s = new Student();
this.updateById(s);
return list;
}
}
Mapper相关
package com.wisdom.travel.mapper;
import com.wisdom.travel.pojo.Student;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
/**
* <p>
* Mapper 接口
* </p>
*
* @author leiliang
* @since 2021-03-22
*/
public interface StudentMapper extends BaseMapper<Student> {
}
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.wisdom.travel.mapper.StudentMapper">
<!-- 通用查询映射结果 -->
<resultMap id="BaseResultMap" type="com.wisdom.travel.pojo.Student">
<result column="id" property="id" />
<result column="name" property="name" />
<result column="cid" property="cid" />
<result column="school" property="school" />
<result column="version" property="version" />
</resultMap>
<!-- 通用查询结果列 -->
<sql id="Base_Column_List">
id, name, cid, school, version
</sql>
</mapper>