MyBatis JPA Extra,MyBatis JPA 擴展 v2.2 發布

2020-12-09 開源中國

MyBatis JPA Extra

MyBatis JPA Extra對MyBatis進行了JPA擴展，旨在基於JPA 2.1的注釋簡化對單表CUID操作，根據JPA注釋動態生成SQL語句；使用Interceptor實現資料庫SELECT分頁查詢，適配多種資料庫；另外提供mybatis-jpa-extra-spring-boot-starter簡化SpringBoot集成。

相關資源

MyBatis網站

MyBatis GitHub源碼

1、JavaBean注釋簡單

只支持6個注釋

  • @Entity
  • @Table
  • @Column
  • @Id
  • @GeneratedValue
  • @Transient

@GeneratedValue有3中策略

  1. AUTO

    uuid

    uuid.hex

    serial

  2. SEQUENCE

    generator值為資料庫序列名

  3. IDENTITY

    generator無，根據資料庫自動生成方式

package org.apache.mybatis.jpa.test.domain;import java.io.Serializable;import javax.persistence.Column;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.Table;import org.apache.mybatis.jpa.persistence.JpaBaseDomain;/* ID varchar(40) not null, NAME varchar(60) not null, STATUS char(1) null, CREATEBY varchar(40) null, CREATEDATE date null, UPDATEBY varchar(40) null, UPDATEDATE date null, constraint PK_ROLES primary key clustered (ID) *//** * @author Crystal.Sea * */@Entity@Table(name = "STUDENTS") public class Students extends JpaBaseDomain implements Serializable{ /** * */ private static final long serialVersionUID = -6928570405840778151L; @Id @Column @GeneratedValue(strategy=GenerationType.AUTO,generator="serial") //@GeneratedValue(strategy=GenerationType.SEQUENCE,generator="SEQ_MYBATIS_STUD") //@GeneratedValue(strategy=GenerationType.IDENTITY,generator="SEQ_MYBATIS_STUD") private String id; @Column private String stdNo; @Column private String stdName; @Column private String stdGender; @Column private int stdAge; @Column private String stdMajor; @Column private String stdClass; public Students() { super(); } public String getStdNo() { return stdNo; } public void setStdNo(String stdNo) { this.stdNo = stdNo; } public String getStdName() { return stdName; } public void setStdName(String stdName) { this.stdName = stdName; } public String getStdGender() { return stdGender; } public void setStdGender(String stdGender) { this.stdGender = stdGender; } public int getStdAge() { return stdAge; } public void setStdAge(int stdAge) { this.stdAge = stdAge; } public String getStdMajor() { return stdMajor; } public void setStdMajor(String stdMajor) { this.stdMajor = stdMajor; } public String getStdClass() { return stdClass; } public void setStdClass(String stdClass) { this.stdClass = stdClass; } public String getId() { return id; } public void setId(String id) { this.id = id; } @Override public String toString() { return "Students [stdNo=" + stdNo + ", stdName=" + stdName + ", stdgender=" + stdGender + ", stdAge=" + stdAge + ", stdMajor=" + stdMajor + ", stdClass=" + stdClass + "]"; }}

2、單表新增、修改、刪除、查詢

package org.apache.mybatis.jpa.test;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Date;import java.util.List;import org.apache.mybatis.jpa.test.dao.service.StudentsService;import org.apache.mybatis.jpa.test.domain.Students;import org.apache.mybatis.jpa.util.WebContext;import org.junit.Before;import org.junit.Test;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;public class MyBatisTestRunner { private static final Logger _logger = LoggerFactory.getLogger(MyBatisTestRunner.class); public static ApplicationContext context; public static StudentsService service; @Test public void insert() throws Exception{ _logger.info("insert..."); Students student=new Students(); student.setStdNo("10024"); student.setStdGender("M"); student.setStdName("司馬昭"); student.setStdAge(20); student.setStdMajor("政治"); student.setStdClass("4"); service.insert(student); Thread.sleep(1000); service.remove(student.getId()); } @Test public void get() throws Exception{ _logger.info("get..."); Students student=service.get("921d3377-937a-4578-b1e2-92fb23b5e512"); _logger.info("Students "+student); } @Test public void remove() throws Exception{ _logger.info("remove..."); Students student=new Students(); student.setId("921d3377-937a-4578-b1e2-92fb23b5e512"); service.remove(student.getId()); } @Test public void batchDelete() throws Exception{ _logger.info("batchDelete..."); List<String> idList=new ArrayList<String>(); idList.add("8584804d-b5ac-45d2-9f91-4dd8e7a090a7"); idList.add("ab7422e9-a91a-4840-9e59-9d911257c918"); idList.add("12b6ceb8-573b-4f01-ad85-cfb24cfa007c"); idList.add("dafd5ba4-d2e3-4656-bd42-178841e610fe"); service.batchDelete(idList); } @Test public void findAll() throws Exception{ _logger.info("findAll..."); _logger.info("findAll "+service.findAll()); } @Before public void initSpringContext(){ if(context!=null) return; _logger.info("init Spring Context..."); SimpleDateFormat sdf_ymdhms =new SimpleDateFormat("yyyy-MM-dd HH🇲🇲ss"); String startTime=sdf_ymdhms.format(new Date()); try{ MyBatisTestRunner runner=new MyBatisTestRunner(); runner.init(); }catch(Exception e){ e.printStackTrace(); } _logger.info("-- --Init Start at " + startTime+" , End at "+sdf_ymdhms.format(new Date())); } //Initialization ApplicationContext for Project public void init(){ _logger.info("init ..."); context = new ClassPathXmlApplicationContext(new String[] {"spring/applicationContext.xml"}); WebContext.applicationContext=context; service =(StudentsService)WebContext.getBean("studentsService"); } }

3、支持分頁查詢

package org.apache.mybatis.jpa.test;import java.util.ArrayList;import java.util.List;import org.apache.mybatis.jpa.test.dao.service.StudentsService;import org.apache.mybatis.jpa.test.domain.Students;import org.apache.mybatis.jpa.util.WebContext;import org.junit.Before;import org.junit.Test;import org.junit.runner.RunWith;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.boot.test.context.SpringBootTest;import org.springframework.context.ApplicationContext;import org.springframework.test.context.junit4.SpringRunner;@RunWith(SpringRunner.class)@SpringBootTest(classes = MybatisJpaApplication.class)public class MybatisJpaApplicationTest{ private static final Logger _logger = LoggerFactory.getLogger(MybatisJpaApplicationTest.class); @Autowired StudentsService studentsService; @Autowired org.apache.ibatis.session.SqlSessionFactory SqlSessionFactory; @Autowired private ApplicationContext applicationContext; @Before public void before() { _logger.info("---------------- before"); WebContext.applicationContext=applicationContext; } @Test public void insert() throws Exception{ _logger.info("insert..."); Students student=new Students(); student.setStdNo("10024"); student.setStdGender("M"); student.setStdName("司馬昭"); student.setStdAge(20); student.setStdMajor("政治"); student.setStdClass("4"); studentsService.insert(student); Thread.sleep(1000); studentsService.remove(student.getId()); } @Test public void get() throws Exception{ _logger.info("get..."); Students student=studentsService.get("921d3377-937a-4578-b1e2-92fb23b5e512"); System.out.println("Students "+student); _logger.info("Students "+student); } @Test public void remove() throws Exception{ _logger.info("remove..."); Students student=new Students(); student.setId("921d3377-937a-4578-b1e2-92fb23b5e512"); studentsService.remove(student.getId()); } @Test public void batchDelete() throws Exception{ _logger.info("batchDelete..."); List<String> idList=new ArrayList<String>(); idList.add("8584804d-b5ac-45d2-9f91-4dd8e7a090a7"); idList.add("ab7422e9-a91a-4840-9e59-9d911257c918"); idList.add("12b6ceb8-573b-4f01-ad85-cfb24cfa007c"); idList.add("dafd5ba4-d2e3-4656-bd42-178841e610fe"); studentsService.batchDelete(idList); } @Test public void queryPageResults() throws Exception{ _logger.info("queryPageResults..."); Students student=new Students(); //student.setId("af04d610-6092-481e-9558-30bd63ef783c"); student.setStdGender("M"); //student.setStdMajor(政治"); student.setPageSize(10); student.setPageNumber(2); List<Students> allListStudents = studentsService.queryPageResults(student).getRows(); for (Students s : allListStudents) { _logger.info("Students "+s); } } @Test public void queryPageResultsByMapperId() throws Exception{ _logger.info("queryPageResults by mapperId..."); Students student=new Students(); student.setStdGender("M"); //student.setStdMajor(政治"); student.setPageSize(10); student.setPageNumber(2); List<Students> allListStudents = studentsService.queryPageResults("queryPageResults1",student).getRows(); for (Students s : allListStudents) { _logger.info("Students "+s); } } @Test public void findAll() { _logger.info("---------------- ALL"); List<Students> allListStudents=studentsService.findAll(); for (Students s : allListStudents) { _logger.info("Students "+s); } }}package org.apache.mybatis.jpa.test;import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;import javax.sql.DataSource;import org.springframework.beans.factory.annotation.Value;import org.springframework.boot.context.properties.ConfigurationProperties;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import org.springframework.context.annotation.Primary;@Configurationpublic class MybatisJpaConfig { private int port; public int getPort() { return port; } public void setPort(int port) { this.port = port; } @Bean @Primary @ConfigurationProperties("spring.datasource") public DataSource dataSource() { return DruidDataSourceBuilder.create().build(); }}

4、映射文件配置

<mapper namespace="org.apache.mybatis.jpa.test.dao.persistence.StudentsMapper" > <sql id="sql_condition"> WHERE 1 = 1 <if test="id != null"> AND ID = '${id}' </if> <if test="stdName != null and stdName != '' "> AND STDNAME like '%${stdName}%' </if> <if test="stdGender != null and stdGender != '' "> AND STDGENDER = #{stdGender} </if> <if test="stdMajor != null"> <![CDATA[AND STDMAJOR = #{stdMajor}]]> </if> </sql> <select id="queryPageResults" parameterType="Students" resultType="Students"> SELECT ID , STDNO , STDNAME , STDGENDER , STDAGE , STDMAJOR , STDCLASS FROM STUDENTS <include refid="sql_condition"/> </select> <select id="queryPageResults1" parameterType="Students" resultType="Students"> SELECT ID , STDNO , STDNAME , STDGENDER , STDAGE , STDMAJOR , STDCLASS FROM STUDENTS <include refid="sql_condition"/> </select> <select id="queryBy" parameterType="Students" resultType="Students"> SELECT ID , STDNO , STDNAME , STDGENDER , STDAGE , STDMAJOR , STDCLASS FROM ROLES <include refid="sql_condition"/> </select> <delete id="delete" parameterType="Students" > DELETE FROM STUDENTS WHERE ID=#{id} </delete>

5、SpringBoot配置

spring.main.web-application-type=NONE#spring.datasource.username=rootspring.datasource.password=maxkeyspring.datasource.url=jdbc:mysql://localhost/test?autoReconnect=true&characterEncoding=UTF-8&serverTimezone=UTCspring.datasource.driver-class-name=com.mysql.jdbc.Driverspring.datasource.type=com.alibaba.druid.pool.DruidDataSourcemybatis.type-aliases-package=org.apache.mybatis.jpa.test.domainmybatis.mapper-locations=classpath*:/org/apache/mybatis/jpa/test/dao/persistence/xml/mysql/*.xmlmybatis.table-column-escape=true#mybatis.table-column-escape-char=`

相關焦點

  • 芋道 Spring Boot JPA 入門(一)之快速入門
    所以整個調用過程是：應用程式 => Repository => Spring Data JPA => Hibernate2. 快速入門示例代碼對應倉庫：lab-13-jpa 。本小節，我們會使用 spring-boot-starter-data-jpa 自動化配置 Spring Data JPA 。
  • mybatis中SqlSessionFactory類創建過程
    上一篇介紹了mybatis源碼環境的搭建，今天就來開始看源碼。mybatis執行主要流程上一篇文章中介紹的mybatis源碼環境中的測試代碼如下圖：可以看到可mybatis相關的實際上就只有三步：創建SqlSessionFactory、通過SqlSessionFactory創建SqlSession、SqlSession
  • 小學妹問:Mybatis常見註解有哪些?
    org.mybatis.spring.annotation.MapperScan使用方式@SpringBootApplication@MapperScan("com.tian.mybatis.mapper")public class Application {}
  • SpringBoot + MyBatis + MySQL讀寫分離實踐!
    <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot
  • 看到Mybatis源碼就感到煩躁,怎麼辦?
    Mybatis源碼分析今天，我們就來看看Mybatis源碼的閱讀，具體舉個例子來看看：案例和疑問從我們最初的demo中開始：publicstaticvoidmain(String[] args) { String resource = "mybatis-config.xml
  • 徹底搞懂MyBatis插件原理及PageHelper原理
    package com.lonelyWolf.mybatis.plugin;import org.apache.ibatis.executor.Executor;import org.apache.ibatis.mapping.MappedStatement;import
  • 重學Java 設計模式:實戰代理模式「模擬mybatis-spring中定義DAO...
    2.2.2 Dao層接口publicinterfaceIUserDao{@Select("select userName from user where id = #{uId}")String queryUserInfo(String uId);
  • 從0 開始手寫一個 Mybatis 框架,三步搞定!
    MyBatis框架的核心功能其實不難，無非就是動態代理和jdbc的操作，難的是寫出來可擴展，高內聚，低耦合的規範的代碼。本文完成的Mybatis功能比較簡單，代碼還有許多需要改進的地方，大家可以結合Mybatis源碼去動手完善。
  • 比mybatis 強大優雅的 sqltoy-orm-4.11.6 發版了
    在目前有這麼多ORM框架的情況下，再搞一個開源框架的前提就是必須要比之前的好很多，而在中國如果不超過mybatis(plus)就根本沒有必要投入精力做這件事！因為大家知道開源就是在別人忙掙錢或者玩樂的時候而你卻在不計得失的奉獻！而我希望給大家奉獻一個真正有趣的有靈魂的框架！
  • Mybatis中mapper的xml解析詳解
    configuration.getSqlFragments()四個參數初始化一個XMLMapperBuilder；然後執行XMLMapperBuilder對象的parse方法；初始化XMLMapperBuilder初始化過程源碼已在上圖的右側部分，初始化XMLMapperBuilder方法的流程與加載mybatis
  • 使用springboot jpa 時,遇到的save尷尬
    首先問下各位朋友，有沒有在springboot中使用jpa？那麼，在使用save方法，進行修改的時候，是不是有遇到過一些尷尬呢？遇到這些尷尬，由於自己是位稱職的程式設計師，有沒有傷下腦筋去解決解決呢？問號三連！
  • A.CTable 框架 v1.4.0.RELEASE 發布
    A.CTable框架 v1.4.0.RELEASE 已經發布。
  • 面試官:Mybatis 使用了哪些設計模式?
    2、工廠模式在Mybatis中比如SqlSessionFactory使用的是工廠模式，該工廠沒有那麼複雜的邏輯，是一個簡單工廠模式。Mybatis支持動態SQL的強大功能，比如下面的這個SQL：<update id="update"parameterType="org.format.dynamicproxy.mybatis.bean.User">UPDATE users <trim
  • Mybatis中SqlSource解析流程詳解
    今天我們只關注mybatis自帶的一個實現XMLLanguageDriver。
  • 清華畢業大佬用了一個項目就把SpringMVC+Spring+MyBatis給講完了
    MyBatis 的優勢認識第一個MyBatis程序MyBatis日誌第二章為 MyBatis 置選項，在配置MyBatis的時候，我們可以通過一一個 XML(第一章 中用mybatis-config.xml
  • 「純手打」2萬字長文從0開始Spring Boot(上)
    鑑於 SpringBoot 版本變化或環境不同容易導致難以解決的問題，筆者假定讀者 SpringBoot 版本為 2.2.5，並且編輯器為 IntellijIDEA2019.3.11. SpringBoot 是什麼？
  • J2eeFAST 2.1.1 版本發布、支持 PostgreSql 資料庫
    system模塊 修復多選表格組件回顯勾選問題 增強輸入組件支持日期時間選擇 細化前端模板引擎libs引入JS,按需引入減少無關JS引入 優化表格邊框設置、允許表格列拉伸、支持通過參數配置是否需要顯示邊框 新增表單單元格過長使用隱藏函數可以複製單元格內容 升級Spring Boot 2.2.10