個人建站提供軟件下載軟文發(fā)稿平臺有哪些
mybatis古今未來
最近無意之中發(fā)現(xiàn)了一個非常棒的持久層框架mybatis-flex,迫不及待研究了一下
發(fā)現(xiàn)簡直就是我的夢中情框,之前寫ibatis,后來寫mybatis,接著寫mybatis-plus,接著研究mybatis-flex
ibatis
? ? ibatis是apache開源的,當(dāng)時是一款輕量級的數(shù)據(jù)據(jù)持久層的半自動式開發(fā)框架
? ?它簡化直接用jdbc開發(fā)的60%以上的代碼量,并且支持將sql寫入xml中,使結(jié)構(gòu)變得非常清晰,而且能靈活配置,從此進(jìn)入了ibatis的時代,受到當(dāng)時大量的開發(fā)人員的喜愛
優(yōu)點:
- 簡化了直接使用jdbc產(chǎn)生的大量代碼
- 定義xml映射器,將sql語句與java代碼分離,維護(hù)更輕松
- 查詢能將結(jié)果集反映射到j(luò)ava對象中
- 提供了事物管理和連接池管理
- 。。。。
缺點:
- 結(jié)果集封裝單一,不夠靈活
- 增刪改查,入?yún)⒂邢拗?#xff0c;只有一個
- 配置關(guān)系太多
- 不夠優(yōu)化,大量的單表操作仍舊需要手動寫增刪改查等sql
- 復(fù)雜查詢邏輯會出現(xiàn)嵌套查詢 n+1的情況,造成資源搶占,擁護(hù),卡頓
- 。。。。
mybatis:
? ?它就是千錘百煉鍛造出來的,它的前身就是ibatis
優(yōu)點:
- 前身是ibatis,所以它有ibatis的一切優(yōu)點
- 借助jdk的泛型和注解特性進(jìn)一步做了簡化
- 實現(xiàn)了接口綁定,自動生成接口的具體實現(xiàn),簡化了ibatis在dao與xml的映射關(guān)系需要指定的操作
- 對象關(guān)系映射改進(jìn),效率更高
- 性能高:提供了緩存機(jī)制提高性能,存儲過程等
- 。。。。
缺點
- sql編寫工作量較大,大量的單表操作仍舊需要寫常規(guī)的sql語句
- 配置關(guān)系仍舊太多
- 復(fù)雜的查詢操作需要自己編寫sql語句
- 緩存使用不當(dāng),容易產(chǎn)生臟數(shù)據(jù)
- 。。。
mybatis-plus
? ?它是mybatis的增強工具,在mybatis的基礎(chǔ)上只做增強不做改變
優(yōu)點:
- 它只是增強mybatis,所以mybatis一切優(yōu)點它全都繼承了過來
- 依賴少,僅僅依賴 Mybatis 以及 Mybatis-Spring 。
- 預(yù)防sql注入,內(nèi)置sql注入剝離器,可以很好的防止sql注入
- 內(nèi)置多種主鍵策略
- 單表增刪改查等業(yè)務(wù)可以不用寫sql
- 強大的條件構(gòu)造器可以滿足各種使用需求
- 支持Lambda形式調(diào)用
- 。。。。
缺點:
- 分頁查詢無sql解析設(shè)計
- 不支持多表查詢
- 不支持多主鍵,復(fù)合主鍵
- 。。。。
MyBatis-Flex
它也是在mybatis上做了增強
- 擁有mybatis所有的優(yōu)點
- 僅依賴mybatis,體積更小更輕量
- 支持多表查詢
- 支持多主鍵,復(fù)合主鍵
- 。。。。。
我的要求:
- 不用寫重復(fù)性單表增刪改查的業(yè)務(wù),
- 能支持分頁查詢
- 支持多表查詢
- 支持rpc遠(yuǎn)程調(diào)用
mybatis-flex滿足了我所有的要求,所以我覺得自己很有必要去了解一下
例子截圖
?
代碼部分
<?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 https://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>3.1.2</version><relativePath/> <!-- lookup parent from repository --></parent><groupId>com.zxs</groupId><artifactId>springboot-mybatis-flex</artifactId><version>0.0.1-SNAPSHOT</version><name>springboot-mybatis-flex</name><description>springboot-mybatis-flex</description><properties><java.version>17</java.version><mybatis-flex.version>1.5.6</mybatis-flex.version><fastjson.version>1.2.47</fastjson.version></properties><dependencyManagement><dependencies><dependency><groupId>com.github.xiaoymin</groupId><artifactId>knife4j-dependencies</artifactId><version>4.1.0</version><type>pom</type><scope>import</scope></dependency></dependencies></dependencyManagement><dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>com.github.xiaoymin</groupId><artifactId>knife4j-openapi3-jakarta-spring-boot-starter</artifactId></dependency><dependency><groupId>com.mysql</groupId><artifactId>mysql-connector-j</artifactId><scope>runtime</scope></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><optional>true</optional></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-jdbc</artifactId></dependency><dependency><groupId>com.mybatis-flex</groupId><artifactId>mybatis-flex-spring-boot-starter</artifactId><version>${mybatis-flex.version}</version></dependency><dependency><groupId>com.alibaba</groupId><artifactId>fastjson</artifactId><version>${fastjson.version}</version></dependency></dependencies><build><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId><configuration><excludes><exclude><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId></exclude></excludes></configuration></plugin></plugins></build></project>
spring:datasource:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://127.0.0.1:3306/testusername: rootpassword: zkb.comtype: com.zaxxer.hikari.HikariDataSourcehikari:connection-timeout: 30000idle-timeout: 600000max-lifetime: 1800000maximum-pool-size: 100minimum-idle: 10pool-name: HikaraPool-1
springdoc:swagger-ui:path: /swagger-ui.htmltags-sorter: alphaapi-docs:path: /v3/api-docsgroup-configs:- group: '查詢接口'paths-to-match: '/**'packages-to-scan: com.zxs.springbootmybatisflex.controller.sys- group: '增刪改接口'paths-to-match: '/**'packages-to-scan: com.zxs.springbootmybatisflex.controller.clientdefault-flat-param-object: trueknife4j:enable: true
package com.zxs.springbootmybatisflex.config;import com.github.xiaoymin.knife4j.spring.annotations.EnableKnife4j;
import io.swagger.v3.oas.models.OpenAPI;
import io.swagger.v3.oas.models.info.Info;
import io.swagger.v3.oas.models.info.License;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;@Configuration
@EnableKnife4j
public class SwaggerConfig {// 設(shè)置 openapi 基礎(chǔ)參數(shù)@Beanpublic OpenAPI customOpenAPI() {return new OpenAPI().info(new Info().title("zxs API 管理").version("1.0").description("探索mybatis-flex demo").license(new License().name("Apache 2.0")));}
}
package com.zxs.springbootmybatisflex.controller.client;import com.mybatisflex.core.query.QueryCondition;
import com.mybatisflex.core.query.QueryWrapper;
import com.zxs.springbootmybatisflex.entity.User;
import com.zxs.springbootmybatisflex.service.UserService;
import com.zxs.springbootmybatisflex.uitl.DataResult;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.tags.Tag;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;import static com.zxs.springbootmybatisflex.entity.table.UserTableDef.USER;@RestController
@Tag(name="用戶增刪改")
@RequestMapping("/suser")
public class SuserController {@AutowiredUserService userService;@Operation(summary = "根據(jù)id刪除用戶",description = "方式一")@GetMapping("/deleteUser/{id}")public DataResult<User> deleteUser(@PathVariable(value = "id") Long id){DataResult<User> result = DataResult.success();userService.deleteUser(id);return result;}@Operation(summary = "根據(jù)id刪除用戶",description = "方式二")@GetMapping("/deleteUser2/{id}")public DataResult<User> deleteUser2(@PathVariable(value = "id") Long id){DataResult<User> result = DataResult.success();userService.removeById(id);return result;}@Operation(summary = "根據(jù)id刪除用戶",description = "方式三")@GetMapping("/deleteUser3/{id}")public DataResult<User> deleteUser3(@PathVariable(value = "id") Long id){DataResult<User> result = DataResult.success();userService.deleteUser3(id);return result;}@Operation(summary = "根據(jù)id刪除用戶",description = "方式四")@GetMapping("/deleteUser4/{id}")public DataResult<User> deleteUser4(@PathVariable(value = "id") Long id){DataResult<User> result = DataResult.success();QueryCondition queryCondition =USER.ID.eq(id);userService.remove(queryCondition);return result;}@Operation(summary = "增加用戶",description = "方式一")@PostMapping("/addUser1")public DataResult<User> addUser1(@RequestBody User user){DataResult<User> result = DataResult.success();userService.save(user);return result;}@Operation(summary = "修改用戶",description = "方式一")@PostMapping("/updateUser1")public DataResult<User> updateUser1(@RequestBody User user){DataResult<User> result = DataResult.success();QueryWrapper queryWrapper = QueryWrapper.create().where(USER.USERNAME.eq(user.getUsername())).and(USER.PASSWORD.eq(user.getPassword()));userService.update(user,queryWrapper);return result;}@Operation(summary = "修改用戶",description = "方式二")@PostMapping("/updateUser2")public DataResult<User> updateUser2(@RequestBody User user){DataResult<User> result = DataResult.success();QueryWrapper queryWrapper = QueryWrapper.create().where(USER.USERNAME.eq(user.getUsername())).and(USER.PASSWORD.eq(user.getPassword()));userService.update(user,queryWrapper);return result;}}
package com.zxs.springbootmybatisflex.controller.sys;import com.zxs.springbootmybatisflex.entity.User;
import com.zxs.springbootmybatisflex.service.UserService;
import com.zxs.springbootmybatisflex.uitl.DataResult;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.tags.Tag;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;import java.util.List;@RestController
@Tag(name="用戶查詢")
@RequestMapping("/user")
public class UserController {@AutowiredUserService userService;@Operation(summary = "獲取全部用戶",description="獲取全部用戶")@GetMapping("/selectUsers")public DataResult<List<User>> selectUsers(){DataResult<List<User>> result = DataResult.success();List<User> list = userService.list();result.setData(list);return result;}@Operation(summary = "根據(jù)id獲取用戶",description = "方式一")@GetMapping("/selectUser/{id}")public DataResult<User> selectUser(@PathVariable(value = "id") Long id){DataResult<User> result = DataResult.success();User user = userService.selectUserById(id);result.setData(user);return result;}@Operation(summary = "根據(jù)id獲取用戶",description = "方式二")@GetMapping("/selectUser2/{id}")public DataResult<User> selectUser2(@PathVariable(value = "id") Long id){DataResult<User> result = DataResult.success();User user = userService.getById(id);result.setData(user);return result;}@Operation(summary = "根據(jù)id獲取用戶",description = "方式三")@GetMapping("/selectUser3/{id}")public DataResult<User> selectUser3(@PathVariable(value = "id") Long id){DataResult<User> result = DataResult.success();User user = userService.selectUserById2(id);result.setData(user);return result;}
}
package com.zxs.springbootmybatisflex.entity;import com.fasterxml.jackson.annotation.JsonFormat;
import com.fasterxml.jackson.databind.annotation.JsonSerialize;
import com.fasterxml.jackson.databind.ser.std.ToStringSerializer;
import com.mybatisflex.annotation.Column;
import com.mybatisflex.annotation.Id;
import com.mybatisflex.annotation.KeyType;
import com.mybatisflex.annotation.Table;
//import io.swagger.annotations.ApiModel;
//import io.swagger.annotations.ApiModelProperty;
import io.swagger.v3.oas.annotations.media.Schema;
import io.swagger.v3.oas.annotations.tags.Tag;
import lombok.Data;
import lombok.EqualsAndHashCode;import java.util.Date;@Data
@EqualsAndHashCode(callSuper = false)
@Tag(name = "用戶", description = "用戶實體類")
@Table("user")
public class User{@Schema(description="用戶id")@JsonSerialize(using = ToStringSerializer.class)@Id(keyType = KeyType.Auto)private Long id;/*** 用戶名*/@Schema(description="用戶名")private String username;/*** 密碼*/@Schema(description="密碼")private String password;/*** 名稱*/@Schema(description="名稱")private String name;/*** 郵箱*/@Schema(description="郵箱")private String email;/*** 聯(lián)系方式*/@Schema(description="手機(jī)號")private String phone;/*** 用戶狀態(tài):1有效; 2刪除*/@Schema(description="狀態(tài)")private Integer status;/*** 創(chuàng)建時間*/@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")@Column("createTime")private Date createTime;/*** 用戶類型*/@Schema(description="登錄次數(shù)")private Integer logins;}
package com.zxs.springbootmybatisflex.exception.code;public enum BaseResponseCode implements ResponseCodeInterface {/*** 這個要和前段約定好* 引導(dǎo)用戶去登錄界面的* code=401001 引導(dǎo)用戶重新登錄* code=401002 token 過期刷新token* code=401008 無權(quán)限訪問*/SUCCESS(200,"操作成功"),SYSTEM_BUSY(500001, "系統(tǒng)繁忙,請稍候再試"),OPERATION_ERRO(500002,"操作失敗"),METHODARGUMENTNOTVALIDEXCEPTION(500003, "方法參數(shù)校驗異常"),;/*** 錯誤碼*/private final int code;/*** 錯誤消息*/private final String msg;BaseResponseCode(int code, String msg) {this.code = code;this.msg = msg;}@Overridepublic int getCode() {return code;}@Overridepublic String getMsg() {return msg;}
}
package com.zxs.springbootmybatisflex.exception.code;public interface ResponseCodeInterface {int getCode();String getMsg();
}
package com.zxs.springbootmybatisflex.exception.handler;import com.zxs.springbootmybatisflex.exception.BusinessException;
import com.zxs.springbootmybatisflex.exception.code.BaseResponseCode;
import com.zxs.springbootmybatisflex.uitl.DataResult;
import lombok.extern.slf4j.Slf4j;
import org.springframework.validation.ObjectError;
import org.springframework.web.bind.MethodArgumentNotValidException;
import org.springframework.web.bind.annotation.ExceptionHandler;
import org.springframework.web.bind.annotation.RestControllerAdvice;import java.util.List;@RestControllerAdvice
@Slf4j
public class RestExceptionHandler {@ExceptionHandler(Exception.class)public <T> DataResult<T> handleException(Exception e){log.error("Exception,exception:{}", e);return DataResult.getResult(BaseResponseCode.SYSTEM_BUSY);}@ExceptionHandler(value = BusinessException.class)<T> DataResult<T> businessExceptionHandler(BusinessException e) {log.error("BusinessException,exception:{}", e);return new DataResult<>(e.getMessageCode(),e.getDetailMessage());}@ExceptionHandler(MethodArgumentNotValidException.class)<T> DataResult<T> methodArgumentNotValidExceptionHandler(MethodArgumentNotValidException e) {log.error("methodArgumentNotValidExceptionHandler bindingResult.allErrors():{},exception:{}", e.getBindingResult().getAllErrors(), e);List<ObjectError> errors = e.getBindingResult().getAllErrors();return createValidExceptionResp(errors);}private <T> DataResult<T> createValidExceptionResp(List<ObjectError> errors) {String[] msgs = new String[errors.size()];int i = 0;for (ObjectError error : errors) {msgs[i] = error.getDefaultMessage();log.info("msg={}",msgs[i]);i++;}return DataResult.getResult(BaseResponseCode.METHODARGUMENTNOTVALIDEXCEPTION.getCode(), msgs[0]);}
}
package com.zxs.springbootmybatisflex.exception;import com.zxs.springbootmybatisflex.exception.code.ResponseCodeInterface;public class BusinessException extends RuntimeException{/*** 異常編號*/private final int messageCode;/*** 對messageCode 異常信息進(jìn)行補充說明*/private final String detailMessage;public BusinessException(int messageCode,String message) {super(message);this.messageCode = messageCode;this.detailMessage = message;}/*** 構(gòu)造函數(shù)* @param code 異常碼*/public BusinessException(ResponseCodeInterface code) {this(code.getCode(), code.getMsg());}public int getMessageCode() {return messageCode;}public String getDetailMessage() {return detailMessage;}
}
package com.zxs.springbootmybatisflex.exception;import com.zxs.springbootmybatisflex.exception.code.ResponseCodeInterface;public class RoleSaveException extends RuntimeException{/*** 異常編號*/private final int messageCode;/*** 對messageCode 異常信息進(jìn)行補充說明*/private final String detailMessage;public RoleSaveException(int messageCode, String message) {super(message);this.messageCode = messageCode;this.detailMessage = message;}/*** 構(gòu)造函數(shù)* @param code 異常碼*/public RoleSaveException(ResponseCodeInterface code) {this(code.getCode(), code.getMsg());}public int getMessageCode() {return messageCode;}public String getDetailMessage() {return detailMessage;}
}
package com.zxs.springbootmybatisflex.mapper;import com.mybatisflex.core.BaseMapper;
import com.zxs.springbootmybatisflex.entity.User;
import org.apache.ibatis.annotations.Mapper;@Mapper
public interface UserMapper extends BaseMapper<User> {
}
package com.zxs.springbootmybatisflex.service.impl;import com.mybatisflex.core.query.QueryWrapper;
import com.mybatisflex.spring.service.impl.ServiceImpl;
import com.zxs.springbootmybatisflex.entity.User;
import com.zxs.springbootmybatisflex.mapper.UserMapper;
import com.zxs.springbootmybatisflex.service.UserService;
import org.springframework.stereotype.Service;import static com.zxs.springbootmybatisflex.entity.table.UserTableDef.USER;@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {@Overridepublic User selectUserById(Long id) {return getById(id);}@Overridepublic User selectUserById2(Long id) {QueryWrapper queryWrapper = QueryWrapper.create().where(USER.ID.eq(id));return getOne(queryWrapper);}@Overridepublic void deleteUser(Long id) {removeById(id);}@Overridepublic void deleteUser3(Long id) {QueryWrapper queryWrapper = QueryWrapper.create().where(USER.ID.eq(id));remove(queryWrapper);}
}
package com.zxs.springbootmybatisflex.service;import com.mybatisflex.core.service.IService;
import com.zxs.springbootmybatisflex.entity.User;public interface UserService extends IService<User> {User selectUserById(Long id);User selectUserById2(Long id);void deleteUser(Long id);void deleteUser3(Long id);
}
package com.zxs.springbootmybatisflex.uitl;import com.zxs.springbootmybatisflex.exception.code.BaseResponseCode;
import com.zxs.springbootmybatisflex.exception.code.ResponseCodeInterface;
import lombok.Data;@Data
public class DataResult<T>{/*** 請求響應(yīng)code,0為成功 其他為失敗*/private int code;/*** 響應(yīng)異常碼詳細(xì)信息*/private String msg;/*** 響應(yīng)內(nèi)容 , code 0 時為 返回 數(shù)據(jù)*/private T data;public DataResult(int code, T data) {this.code = code;this.data = data;this.msg=null;}public DataResult(int code, String msg, T data) {this.code = code;this.msg = msg;this.data = data;}public DataResult(int code, String msg) {this.code = code;this.msg = msg;this.data=null;}public DataResult() {this.code= BaseResponseCode.SUCCESS.getCode();this.msg=BaseResponseCode.SUCCESS.getMsg();this.data=null;}public DataResult(T data) {this.data = data;this.code=BaseResponseCode.SUCCESS.getCode();this.msg=BaseResponseCode.SUCCESS.getMsg();}public DataResult(ResponseCodeInterface responseCodeInterface) {this.data = null;this.code = responseCodeInterface.getCode();this.msg = responseCodeInterface.getMsg();}public DataResult(ResponseCodeInterface responseCodeInterface, T data) {this.data = data;this.code = responseCodeInterface.getCode();this.msg = responseCodeInterface.getMsg();}public static <T>DataResult success(){return new <T>DataResult();}public static <T>DataResult success(T data){return new <T>DataResult(data);}public static <T>DataResult getResult(int code,String msg,T data){return new <T>DataResult(code,msg,data);}public static <T>DataResult getResult(int code,String msg){return new <T>DataResult(code,msg);}public static <T>DataResult getResult(BaseResponseCode responseCode){return new <T>DataResult(responseCode);}public static <T>DataResult getResult(BaseResponseCode responseCode,T data){return new <T>DataResult(responseCode,data);}
}
package com.zxs.springbootmybatisflex;import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;@SpringBootApplication
@MapperScan("com.zxs.springbootmybatisflex.mapper")
public class SpringbootMybatisFlexApplication {public static void main(String[] args) {SpringApplication.run(SpringbootMybatisFlexApplication.class, args);}}
?