溫馨提示×
您好，登錄后才能下訂單哦！
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》
您好，登錄后才能下訂單哦！
這篇文章給大家分享的是有關(guān)如何使用EasyCode生成springboot+mybatis基礎(chǔ)程序的內(nèi)容。小編覺(jué)得挺實(shí)用的，因此分享給大家做個(gè)參考，一起跟隨小編過(guò)來(lái)看看吧。
此文將分享我個(gè)人使用的一個(gè)easycode生成方法，生成之后可以直接運(yùn)行，這也就意味著，生成的代碼會(huì)更加規(guī)范化。規(guī)范化就意味著會(huì)有更多的約束。
引入所需jar包
pom.xml加入一下依賴(lài)
<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.47</version> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.2</version> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.5</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>fastjson</artifactId> <version>1.2.76</version> </dependency> <!--Swagger3--> <dependency> <groupId>io.springfox</groupId> <artifactId>springfox-boot-starter</artifactId> <version>3.0.0</version> </dependency> <dependency> <groupId>com.github.xiaoymin</groupId> <artifactId>swagger-bootstrap-ui</artifactId> <version>1.9.6</version> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.18.10</version> </dependency>
application.yml配置
spring: datasource: driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://ip:3306/dbname?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC username: xxx password: xxx mybatis: type-aliases-package: xxx.entity mapper-locations: classpath:mapper/*.xml # pagehelper pagehelper: helperDialect: mysql reasonable: true supportMethodsArguments: true params: count=countSql #showSql logging: level: top: yuechenc: yueduapi: mapper : debug
以下是我個(gè)人封裝的pagehelper分頁(yè)工具類(lèi)和統(tǒng)一的返回以及swagger配置
pagehelper工具類(lèi)
如上圖所示，在啟動(dòng)類(lèi)所在目錄下新建目錄common.page/common.util
在page目錄新建類(lèi)PageRequest.java
package xxx.common.page;
/**
* @author Zhiwei Wang
* @version $1.0
* @description 分頁(yè)請(qǐng)求
* @date 2022/1/19 9:25
* @history
*/
public class PageRequest {
/**
* 當(dāng)前頁(yè)碼
*/
private int pageNum;
/**
* 每頁(yè)數(shù)量
*/
private int pageSize;
public PageRequest(int start, int limit) {
pageNum=start;
pageSize=limit;
}
public int getPageNum() {
return pageNum;
}
public void setPageNum(int pageNum) {
this.pageNum = pageNum;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
}在page目錄新建類(lèi)PageResult.java
package xxx.common.page;
import java.util.List;
/**
* @author Zhiwei Wang
* @version $1.0
* @name PageResult
* @description 分頁(yè)返回結(jié)果
* @date 2022/1/19 9:25
* @history
*/
public class PageResult {
/**
* 當(dāng)前頁(yè)碼
*/
private int pageNum;
/**
* 每頁(yè)數(shù)量
*/
private int pageSize;
/**
* 記錄總數(shù)
*/
private long totalSize;
/**
* 頁(yè)碼總數(shù)
*/
private int totalPages;
/**
* 數(shù)據(jù)模型
*/
private List<?> content;
public int getPageNum() {
return pageNum;
}
public void setPageNum(int pageNum) {
this.pageNum = pageNum;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public long getTotalSize() {
return totalSize;
}
public void setTotalSize(long totalSize) {
this.totalSize = totalSize;
}
public int getTotalPages() {
return totalPages;
}
public void setTotalPages(int totalPages) {
this.totalPages = totalPages;
}
public List<?> getContent() {
return content;
}
public void setContent(List<?> content) {
this.content = content;
}
}在util目錄下新建工具類(lèi)PageUtils.java
package xxx.common.util;
import com.github.pagehelper.PageInfo;
import xxx.common.page.PageRequest;
import xxx.common.page.PageResult;
/**
* @author Zhiwei Wang
* @version $
* @name PageUtil
* @description
* @date 2022/1/19 9:26
* @history
*/
public class PageUtils {
/**
* 將分頁(yè)信息封裝到統(tǒng)一的接口
* @param pageRequest
* @param pageInfo
* @return
*/
public static PageResult getPageResult(PageRequest pageRequest, PageInfo<?> pageInfo) {
PageResult pageResult = new PageResult();
pageResult.setPageNum(pageInfo.getPageNum());
pageResult.setPageSize(pageInfo.getPageSize());
pageResult.setTotalSize(pageInfo.getTotal());
pageResult.setTotalPages(pageInfo.getPages());
pageResult.setContent(pageInfo.getList());
return pageResult;
}
}統(tǒng)一返回體
在common目錄下新建Status.java
package xxx.common;
/**
* @author Zhiwei Wang
* @version $
* @name Status
* @description 返回信息枚舉
* @date 2022/1/18 21:01
* @history
*/
public enum Status {
FAIL("101", "失敗")
,GET_FAIL("111", "查詢失敗")
,ADD_FAIL("121", "添加失敗")
,DELETE_FAIL("131", "刪除失敗")
,UPDATE_FAIL("141", "修改失敗")
,SUCCESS("100", "成功")
,GET_SUCCESS("110", "查詢成功")
,ADD_SUCCESS("120", "添加成功")
,DELETE_SUCCESS("130", "刪除成功")
,UPDATE_SUCCESS("140", "修改成功")
,ERROR("201", "錯(cuò)誤")
,USER_NOFOUND("211", "用戶不存在")
,ERROR_ACCOUNT("212", "賬號(hào)或密碼錯(cuò)誤")
,USER_EXIST("213", "用戶已存在")
,USER_LOCK("214", "賬號(hào)被鎖定，請(qǐng)聯(lián)系管理員")
,IP_LOCK("215", "IP 被鎖定，請(qǐng)聯(lián)系管理員")
,PARAM_ERROR("303", "參數(shù)錯(cuò)誤")
,Token_Expired("1044", "token Invalid expired");
public String status; // 狀態(tài)碼
public String msg; // 提示語(yǔ)
Status(String status, String msg) {
this.status = status;
this.msg = msg;
}
}在common目錄下新建ReturnData.java
package xxx.common;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.serializer.SerializerFeature;
/**
* @author Zhiwei Wang
* @version $
* @name ReturnData
* @description 響應(yīng)數(shù)據(jù)結(jié)構(gòu)封裝
* @date 2022/1/18 20:59
* @history
*/
public class ReturnData<T> {
private String status; // 狀態(tài)碼
private String msg; // 提示語(yǔ)
private T data; // 數(shù)據(jù)集合
public static <T> ReturnData<T> SUCCESS(T data) {
return new ReturnData<T>(Status.SUCCESS.status, Status.SUCCESS.msg, data);
}
public static <T> ReturnData<T> SUCCESS(String msg) {
return new ReturnData<T>(Status.SUCCESS.status, msg);
}
public static <T> ReturnData<T> SUCCESS() {
return new ReturnData<T>(Status.SUCCESS.status, Status.SUCCESS.msg);
}
public static <T> ReturnData<T> GET_SUCCESS(T data) {
return new ReturnData<T>(Status.GET_SUCCESS.status, Status.GET_SUCCESS.msg, data);
}
public static <T> ReturnData<T> GET_SUCCESS(String msg) {
return new ReturnData<T>(Status.GET_SUCCESS.status, msg);
}
public static <T> ReturnData<T> GET_SUCCESS() {
return new ReturnData<T>(Status.GET_SUCCESS.status, Status.GET_SUCCESS.msg);
}
public static <T> ReturnData<T> ADD_SUCCESS() {
return new ReturnData<T>(Status.ADD_SUCCESS.status, Status.ADD_SUCCESS.msg);
}
public static <T> ReturnData<T> ADD_SUCCESS(T data) {
return new ReturnData<T>(Status.ADD_SUCCESS.status, Status.ADD_SUCCESS.msg,data);
}
public static <T> ReturnData<T> DELETE_SUCCESS() {
return new ReturnData<T>(Status.DELETE_SUCCESS.status, Status.DELETE_SUCCESS.msg);
}
public static <T> ReturnData<T> UPDATE_SUCCESS() {
return new ReturnData<T>(Status.UPDATE_SUCCESS.status, Status.UPDATE_SUCCESS.msg);
}
public static <T> ReturnData<T> UPDATE_SUCCESS(T data) {
return new ReturnData<T>(Status.UPDATE_SUCCESS.status, Status.UPDATE_SUCCESS.msg,data);
}
public static <T> ReturnData<T> FAIL(String msg) {
return new ReturnData<T>(Status.FAIL.status, msg);
}
public static <T> ReturnData<T> FAIL() {
return new ReturnData<T>(Status.FAIL.status, Status.FAIL.msg);
}
public static <T> ReturnData<T> GET_FAIL(String msg) {
return new ReturnData<T>(Status.GET_FAIL.status, msg);
}
public static <T> ReturnData<T> GET_FAIL() {
return new ReturnData<T>(Status.GET_FAIL.status, Status.FAIL.msg);
}
public static <T> ReturnData<T> ADD_FAIL() {
return new ReturnData<T>(Status.ADD_FAIL.status, Status.ADD_FAIL.msg);
}
public static <T> ReturnData<T> DELETE_FAIL() {
return new ReturnData<T>(Status.DELETE_FAIL.status, Status.DELETE_FAIL.msg);
}
public static <T> ReturnData<T> UPDATE_FAIL() {
return new ReturnData<T>(Status.UPDATE_FAIL.status, Status.UPDATE_FAIL.msg);
}
public static <T> ReturnData<T> ERROR(String msg) {
return new ReturnData<T>(Status.ERROR.status, msg);
}
public static <T> ReturnData<T> ERROR() {
return new ReturnData<T>(Status.ERROR.status, Status.ERROR.msg);
}
public ReturnData(String status, String msg, T data) {
this.status = status;
this.msg = msg;
this.data = data;
}
public ReturnData(String status, String msg) {
this.status = status;
this.msg = msg;
}
public String getStatus() {
return status;
}
public void setStatus(String status) {
this.status = status;
}
public String getMsg() {
return msg;
}
public void setMsg(String msg) {
this.msg = msg;
}
public T getData() {
return data;
}
public void setData(T data) {
this.data = data;
}
/**
* 如果字段為null,該字段不顯示
*/
@Override
public String toString() {
return JSON.toJSONString(this);
}
/**
* 返回全部字段,包括null
*
* @return
*/
public String toAllString() {
return JSON.toJSONString(this, SerializerFeature.WriteMapNullValue);
}
}swagger3配置
在common目錄下新建Swagger3Config.java
package xxx.common;
import io.swagger.annotations.ApiOperation;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import springfox.documentation.builders.ApiInfoBuilder;
import springfox.documentation.builders.PathSelectors;
import springfox.documentation.builders.RequestHandlerSelectors;
import springfox.documentation.service.ApiInfo;
import springfox.documentation.service.Contact;
import springfox.documentation.spi.DocumentationType;
import springfox.documentation.spring.web.plugins.Docket;
/**
* @author Zhiwei Wang
* @version $
* @name Swagger3Config
* @description
* @date 2022/1/18 21:40
* @history
*/
@Configuration
public class Swagger3Config {
@Bean
public Docket createRestApi() {
return new Docket(DocumentationType.OAS_30)
.apiInfo(apiInfo())
.select()
.apis(RequestHandlerSelectors.basePackage("xxx.controller"))
.paths(PathSelectors.any())
.build();
}
private ApiInfo apiInfo() {
return new ApiInfoBuilder()
.title("Swagger3接口文檔")
.description("測(cè)試API")
.contact(new Contact("測(cè)試API", "http://localhost:8080/swagger-ui/index.html", "1757895437@qq.com"))
.version("1.0")
.build();
}
}
如圖所示，打開(kāi)idea的設(shè)置界面，選擇插件，搜索EasyCode，點(diǎn)擊安裝即可
如圖：依次打開(kāi)idea設(shè)置->其他設(shè)置->EasyCode-MyBatisCodeHelper->Template Setting
右邊的就是生成代碼的模板，一次將下列模板粘貼到里面即可:
entity
##引入宏定義
$!define
##使用宏定義設(shè)置回調(diào)（保存位置與文件后綴）
#save("/entity", ".java")
##使用宏定義設(shè)置包后綴
#setPackageSuffix("entity")
##使用全局變量實(shí)現(xiàn)默認(rèn)包導(dǎo)入
$!autoImport
import java.io.Serializable;
##使用宏定義實(shí)現(xiàn)類(lèi)注釋信息
#tableComment("實(shí)體類(lèi)")
public class $!{tableInfo.name} implements Serializable {
private static final long serialVersionUID = $!tool.serial();
#foreach($column in $tableInfo.fullColumn)
#if(${column.comment})/**
* ${column.comment}
*/#end
private $!{tool.getClsNameByFullName($column.type)} $!{column.name};
#end
#foreach($column in $tableInfo.fullColumn)
##使用宏定義實(shí)現(xiàn)get,set方法
#getSetMethod($column)
#end
@Override
public String toString(){
return "$tableInfo.name {" +
#foreach($column in $tableInfo.fullColumn)
"$column.name : " + $column.name + ", " +
#end
'}';
}
}dao
##定義初始變量
#set($tableName = $tool.append($tableInfo.name, "Dao"))
##設(shè)置回調(diào)
$!callback.setFileName($tool.append($tableName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/dao"))
##拿到主鍵
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}dao;
import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
import org.apache.ibatis.annotations.Param;
import java.util.List;
import java.util.Map;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表數(shù)據(jù)庫(kù)訪問(wèn)層
*
* @author $!author
* @since $!time.currTime()
*/
public interface $!{tableName} {
/**
* 通過(guò)ID查詢單條數(shù)據(jù)
*
* @param $!pk.name 主鍵
* @return 實(shí)例對(duì)象
*/
$!{tableInfo.name} selectById($!pk.shortType $!pk.name);
/**
* 分頁(yè)查詢
*
* @param start 查詢起始位置
* @param limit 查詢條數(shù)
* @return 對(duì)象列表
*/
List<$!{tableInfo.name}> selectPage(@Param("start") int start, @Param("limit") int limit);
/**
* 查詢?nèi)?
*
* @return 對(duì)象列表
*/
List<$!{tableInfo.name}> selectAll();
/**
* 通過(guò)實(shí)體作為篩選條件查詢
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 實(shí)例對(duì)象
* @return 對(duì)象列表
*/
List<$!{tableInfo.name}> selectList($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 新增數(shù)據(jù)
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 實(shí)例對(duì)象
* @return 影響行數(shù)
*/
int insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 批量新增
*
* @param $!tool.firstLowerCase($!{tableInfo.name})s 實(shí)例對(duì)象的集合
* @return 影響行數(shù)
*/
int batchInsert(List<$!{tableInfo.name}> $!tool.firstLowerCase($!{tableInfo.name})s);
/**
* 修改數(shù)據(jù)
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 實(shí)例對(duì)象
* @return 影響行數(shù)
*/
int update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 通過(guò)主鍵刪除數(shù)據(jù)
*
* @param $!pk.name 主鍵
* @return 影響行數(shù)
*/
int deleteById($!pk.shortType $!pk.name);
/**
* 查詢總數(shù)據(jù)數(shù)
*
* @return 數(shù)據(jù)總數(shù)
*/
int count();
}service
##定義初始變量
#set($tableName = $tool.append($tableInfo.name, "Service"))
##設(shè)置回調(diào)
$!callback.setFileName($tool.append($tableName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/service"))
##拿到主鍵
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}service;
import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
import java.util.List;
import java.util.Map;
import $!{tableInfo.savePackageName}.common.page.PageResult;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表服務(wù)接口
*
* @author $!author
* @since $!time.currTime()
*/
public interface $!{tableName} {
/**
* 通過(guò)ID查詢單條數(shù)據(jù)
*
* @param $!pk.name 主鍵
* @return 實(shí)例對(duì)象
*/
$!{tableInfo.name} selectById($!pk.shortType $!pk.name);
/**
* 分頁(yè)查詢
*
* @param start 查詢起始位置
* @param limit 查詢條數(shù)
* @return 對(duì)象列表
*/
PageResult selectPage(int start, int limit);
/**
* 查詢?nèi)?
*
* @return 對(duì)象列表
*/
List<$!{tableInfo.name}> selectAll();
/**
* 通過(guò)實(shí)體作為篩選條件查詢
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 實(shí)例對(duì)象
* @return 對(duì)象列表
*/
List<$!{tableInfo.name}> selectList($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 新增數(shù)據(jù)
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 實(shí)例對(duì)象
* @return 影響行數(shù)
*/
int insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 批量新增
*
* @param $!tool.firstLowerCase($!{tableInfo.name})s 實(shí)例對(duì)象的集合
* @return 影響行數(shù)
*/
int batchInsert(List<$!{tableInfo.name}> $!tool.firstLowerCase($!{tableInfo.name})s);
/**
* 修改數(shù)據(jù)
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 實(shí)例對(duì)象
* @return 修改
*/
$!{tableInfo.name} update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 通過(guò)主鍵刪除數(shù)據(jù)
*
* @param $!pk.name 主鍵
* @return 影響行數(shù)
*/
int deleteById($!pk.shortType $!pk.name);
/**
* 查詢總數(shù)據(jù)數(shù)
*
* @return 數(shù)據(jù)總數(shù)
*/
int count();
}serviceimpl
##定義初始變量
#set($tableName = $tool.append($tableInfo.name, "ServiceImpl"))
##設(shè)置回調(diào)
$!callback.setFileName($tool.append($tableName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/service/impl"))
##拿到主鍵
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}service.impl;
import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
import $!{tableInfo.savePackageName}.dao.$!{tableInfo.name}Dao;
import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
import org.springframework.stereotype.Service;
import $!{tableInfo.savePackageName}.common.page.PageResult;
import $!{tableInfo.savePackageName}.common.page.PageRequest;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import $!{tableInfo.savePackageName}.common.util.PageUtils;
import javax.annotation.Resource;
import java.util.List;
import java.util.Map;
/**
* $!{tableInfo.comment}($!{tableInfo.name}表)服務(wù)實(shí)現(xiàn)類(lèi)
*
* @author $!author
* @since $!time.currTime()
*/
@Service("$!tool.firstLowerCase($!{tableInfo.name})Service")
public class $!{tableName} implements $!{tableInfo.name}Service {
@Resource
private $!{tableInfo.name}Dao $!tool.firstLowerCase($!{tableInfo.name})Dao;
/**
* 通過(guò)ID查詢單條數(shù)據(jù)
*
* @param $!pk.name 主鍵
* @return 實(shí)例對(duì)象
*/
@Override
public $!{tableInfo.name} selectById($!pk.shortType $!pk.name) {
return this.$!{tool.firstLowerCase($!{tableInfo.name})}Dao.selectById($!pk.name);
}
/**
* 分頁(yè)查詢
*
* @param start 查詢起始位置
* @param limit 查詢條數(shù)
* @return 對(duì)象列表
*/
@Override
public PageResult selectPage(int start, int limit) {
PageRequest pageRequest=new PageRequest(start,limit);
return PageUtils.getPageResult(pageRequest, getPageInfo(pageRequest));
}
/**
* 調(diào)用分頁(yè)插件完成分頁(yè)
* @param pageRequest
* @return
*/
private PageInfo<$!{tableInfo.name}> getPageInfo(PageRequest pageRequest) {
int pageNum = pageRequest.getPageNum();
int pageSize = pageRequest.getPageSize();
PageHelper.startPage(pageNum, pageSize);
List<$!{tableInfo.name}> $!{tool.firstLowerCase($!{tableInfo.name})}s = this.$!{tool.firstLowerCase($!{tableInfo.name})}Dao.selectAll();
return new PageInfo<>($!{tool.firstLowerCase($!{tableInfo.name})}s);
}
/**
* 查詢所有
*
* @return 實(shí)例對(duì)象的集合
*/
@Override
public List<$!{tableInfo.name}> selectAll() {
return this.$!{tool.firstLowerCase($!{tableInfo.name})}Dao.selectAll();
}
/**
* 根據(jù)條件查詢
*
* @return 實(shí)例對(duì)象的集合
*/
@Override
public List<$!{tableInfo.name}> selectList($!{tableInfo.name} $!{tool.firstLowerCase($!{tableInfo.name})}) {
return this.$!{tool.firstLowerCase($!{tableInfo.name})}Dao.selectList($!{tool.firstLowerCase($!{tableInfo.name})});
}
/**
* 新增數(shù)據(jù)
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 實(shí)例對(duì)象
* @return 實(shí)例對(duì)象
*/
@Override
public int insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name})) {
return this.$!{tool.firstLowerCase($!{tableInfo.name})}Dao.insert($!tool.firstLowerCase($!{tableInfo.name}));
}
/**
* 批量新增
*
* @param $!tool.firstLowerCase($!{tableInfo.name})s 實(shí)例對(duì)象的集合
* @return 生效的條數(shù)
*/
@Override
public int batchInsert(List<$!{tableInfo.name}> $!tool.firstLowerCase($!{tableInfo.name})s) {
return this.$!{tool.firstLowerCase($!{tableInfo.name})}Dao.batchInsert($!tool.firstLowerCase($!{tableInfo.name})s);
}
/**
* 修改數(shù)據(jù)
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 實(shí)例對(duì)象
* @return 實(shí)例對(duì)象
*/
@Override
public $!{tableInfo.name} update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name})) {
this.$!{tool.firstLowerCase($!{tableInfo.name})}Dao.update($!tool.firstLowerCase($!{tableInfo.name}));
return this.selectById($!{tool.firstLowerCase($!{tableInfo.name})}.get$!tool.firstUpperCase($pk.name)());
}
/**
* 通過(guò)主鍵刪除數(shù)據(jù)
*
* @param $!pk.name 主鍵
* @return 是否成功
*/
@Override
public int deleteById($!pk.shortType $!pk.name) {
return this.$!{tool.firstLowerCase($!{tableInfo.name})}Dao.deleteById($!pk.name);
}
/**
* 查詢總數(shù)據(jù)數(shù)
*
* @return 數(shù)據(jù)總數(shù)
*/
@Override
public int count(){
return this.$!{tool.firstLowerCase($!{tableInfo.name})}Dao.count();
}
}controller
##定義初始變量
#set($tableName = $tool.append($tableInfo.name, "Controller"))
##設(shè)置回調(diào)
$!callback.setFileName($tool.append($tableName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/controller"))
##拿到主鍵
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}controller;
import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
import org.springframework.web.bind.annotation.*;
import $!{tableInfo.savePackageName}.common.ReturnData;
import $!{tableInfo.savePackageName}.common.page.PageResult;
import java.util.List;
import javax.annotation.Resource;
/**
* $!{tableInfo.comment}($!{tableInfo.name})控制層
*
* @author $!author
* @since $!time.currTime()
*/
@RestController
@RequestMapping("/$!tool.firstLowerCase($tableInfo.name)")
public class $!{tableName} {
/**
* 服務(wù)對(duì)象
*/
@Resource
private $!{tableInfo.name}Service $!tool.firstLowerCase($tableInfo.name)Service;
/**
* 通過(guò)主鍵查詢單條數(shù)據(jù)
*
* @param $!tool.firstLowerCase($tableInfo.name) 參數(shù)對(duì)象
* @return 單條數(shù)據(jù)
*/
@RequestMapping(value = "get", method = RequestMethod.GET)
public ReturnData<$tableInfo.name> selectOne($tableInfo.name $!tool.firstLowerCase($tableInfo.name)) {
$tableInfo.name result = $!{tool.firstLowerCase($tableInfo.name)}Service.selectById($!{tool.firstLowerCase($tableInfo.name)}.getId());
if(result != null){
return ReturnData.GET_SUCCESS(result);
}
return ReturnData.GET_FAIL();
}
/**
* 新增一條數(shù)據(jù)
*
* @param $!tool.firstLowerCase($tableInfo.name) 實(shí)體類(lèi)
* @return Response對(duì)象
*/
@RequestMapping(value = "insert", method = RequestMethod.POST)
public ReturnData<$tableInfo.name> insert(@RequestBody $tableInfo.name $!tool.firstLowerCase($tableInfo.name)) {
int result = $!{tool.firstLowerCase($tableInfo.name)}Service.insert($!tool.firstLowerCase($tableInfo.name));
if (result > 0) {
return ReturnData.ADD_SUCCESS();
}
return ReturnData.ADD_FAIL();
}
/**
* 修改一條數(shù)據(jù)
*
* @param $!tool.firstLowerCase($tableInfo.name) 實(shí)體類(lèi)
* @return Response對(duì)象
*/
@RequestMapping(value = "update", method = RequestMethod.PUT)
public ReturnData<$tableInfo.name> update(@RequestBody $tableInfo.name $!tool.firstLowerCase($tableInfo.name)) {
$tableInfo.name result = $!{tool.firstLowerCase($tableInfo.name)}Service.update($!tool.firstLowerCase($tableInfo.name));
if (result != null) {
return ReturnData.UPDATE_SUCCESS(result);
}
return ReturnData.UPDATE_FAIL();
}
/**
* 刪除一條數(shù)據(jù)
*
* @param $!tool.firstLowerCase($tableInfo.name) 參數(shù)對(duì)象
* @return Response對(duì)象
*/
@RequestMapping(value = "delete", method = RequestMethod.DELETE)
public ReturnData<$tableInfo.name> delete($tableInfo.name $!tool.firstLowerCase($tableInfo.name)) {
int result = $!{tool.firstLowerCase($tableInfo.name)}Service.deleteById($!{tool.firstLowerCase($tableInfo.name)}.getId());
if (result > 0) {
return ReturnData.DELETE_SUCCESS();
}
return ReturnData.DELETE_FAIL();
}
/**
* 查詢?nèi)?
*
* @return Response對(duì)象
*/
@RequestMapping(value = "selectAll", method = RequestMethod.GET)
public ReturnData<List<$tableInfo.name>> selectAll() {
List<$tableInfo.name> $!tool.firstLowerCase($tableInfo.name)s = $!{tool.firstLowerCase($tableInfo.name)}Service.selectAll();
if ($!tool.firstLowerCase($tableInfo.name)s != null) {
return ReturnData.GET_SUCCESS($!tool.firstLowerCase($tableInfo.name)s);
}
return ReturnData.GET_FAIL();
}
/**
* 分頁(yè)查詢
*
* @param start 偏移
* @param limit 條數(shù)
* @return Response對(duì)象
*/
@RequestMapping(value = "selectPage", method = RequestMethod.GET)
public ReturnData<PageResult> selectPage(Integer start, Integer limit) {
PageResult pageResult = $!{tool.firstLowerCase($tableInfo.name)}Service.selectPage(start, limit);
if (pageResult != null) {
return ReturnData.GET_SUCCESS(pageResult);
}
return ReturnData.GET_FAIL();
}
}mapper.xml
##引入mybatis支持
$!mybatisSupport
##設(shè)置保存名稱(chēng)與保存位置
$!callback.setFileName($tool.append($!{tableInfo.name}, "Dao.xml"))
$!callback.setSavePath($tool.append($modulePath, "/src/main/resources/mapper"))
##拿到主鍵
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
<?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="$!{tableInfo.savePackageName}.dao.$!{tableInfo.name}Dao">
<!-- 結(jié)果集 -->
<resultMap type="$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}" id="$!{tableInfo.name}Map">
#foreach($column in $tableInfo.fullColumn)
<result property="$!column.name" column="$!column.obj.name" jdbcType="$!column.ext.jdbcType"/>
#end
</resultMap>
<!-- 基本字段 -->
<sql id="Base_Column_List">
#allSqlColumn()
</sql>
<!-- 查詢單個(gè) -->
<select id="selectById" resultMap="$!{tableInfo.name}Map">
select
<include refid="Base_Column_List" />
from $!tableInfo.obj.name
where $!pk.obj.name = #{$!pk.name}
</select>
<!-- 分頁(yè)查詢 -->
<select id="selectPage" resultMap="$!{tableInfo.name}Map">
select
<include refid="Base_Column_List" />
from $!tableInfo.obj.name
limit #{start},#{limit}
</select>
<!-- 查詢?nèi)?nbsp;-->
<select id="selectAll" resultMap="$!{tableInfo.name}Map">
select
<include refid="Base_Column_List" />
from $!tableInfo.obj.name
</select>
<!--通過(guò)實(shí)體作為篩選條件查詢-->
<select id="selectList" resultMap="$!{tableInfo.name}Map">
select
<include refid="Base_Column_List" />
from $!tableInfo.obj.name
<where>
#foreach($column in $tableInfo.fullColumn)
<if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">
and $!column.obj.name = #{$!column.name}
</if>
#end
</where>
</select>
<!-- 新增所有列 -->
<insert id="insert" keyProperty="$!pk.name" useGeneratedKeys="true">
insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.fullColumn)$!column.obj.name#if($velocityHasNext), #end#end)
values ( #foreach($column in $tableInfo.fullColumn)#{$!{column.name}}#if($velocityHasNext), #end#end)
</insert>
<!-- 批量新增 -->
<insert id="batchInsert">
insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.fullColumn)$!column.obj.name#if($velocityHasNext), #end#end)
values
<foreach collection="$!tool.firstLowerCase($!{tableInfo.name})s" item="item" index="index" separator=",">
(
#foreach($column in $tableInfo.fullColumn)
#{item.$!{column.name}}#if($velocityHasNext), #end
#end
)
</foreach>
</insert>
<!-- 通過(guò)主鍵修改數(shù)據(jù) -->
<update id="update">
update $!{tableInfo.obj.parent.name}.$!{tableInfo.obj.name}
<set>
#foreach($column in $tableInfo.otherColumn)
<if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">
$!column.obj.name = #{$!column.name},
</if>
#end
</set>
where $!pk.obj.name = #{$!pk.name}
</update>
<!--通過(guò)主鍵刪除-->
<delete id="deleteById">
delete from $!{tableInfo.obj.name} where $!pk.obj.name = #{$!pk.name}
</delete>
<!-- 總數(shù) -->
<select id="count" resultType="int">
select count(*) from $!{tableInfo.obj.name}
</select>
</mapper>首先使用idea連接數(shù)據(jù)庫(kù)，此處省略，如果有不知道怎么連接的，請(qǐng)參考：mysql連接idea詳細(xì)教程
如圖選擇需要生成代碼的表->右鍵->EasyCodeMybatisCodeHelper->Generate_Code,彈出如下窗口
Module：選擇要生成到那個(gè)模塊
Package：填寫(xiě)自己的包名
Path:工程路徑
選擇要生成的類(lèi)，點(diǎn)擊ok即可看到工程里已經(jīng)生成了相應(yīng)的類(lèi)
注意：使用mybatis需要在啟動(dòng)類(lèi)中加入注釋
//掃描dao的路徑配置
@MapperScan(".dao")感謝各位的閱讀！關(guān)于“如何使用EasyCode生成springboot+mybatis基礎(chǔ)程序”這篇文章就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，讓大家可以學(xué)到更多知識(shí)，如果覺(jué)得文章不錯(cuò)，可以把它分享出去讓更多的人看到吧！
免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。
億速云公眾號(hào)
手機(jī)網(wǎng)站二維碼