簡(jiǎn)化mybatis的使用方式：通用插件JpaMapper之PagingAndSortingMapper

簡(jiǎn)介

JpaMapper以Jpa hibernate的風(fēng)格寫(xiě)mybatis的代碼，可以減少手動(dòng)寫(xiě)sql的煩惱。

PagingAndSortingMapper可以實(shí)現(xiàn)帶分頁(yè)和排序的增刪改查，簡(jiǎn)化mybatis的使用。

這里介紹如何快速配置JpaMapper。

maven依賴

首先配置好mybatis的依賴，這是必須的。

配置JpaMapper的依賴，JpaMapper已經(jīng)上傳到maven中央倉(cāng)庫(kù)。

springboot啟動(dòng)方式：

<dependency>
    <groupId>com.github.ffch</groupId>
    <artifactId>jpa-mapper-spring-boot-starter</artifactId>
    <version>1.2.2</version>
</dependency>

如果當(dāng)前的spring不支持boot-starter方式，可以只依賴core包：

<dependency>
    <groupId>com.github.ffch</groupId>
    <artifactId>jpa-mapper-core</artifactId>
    <version>1.2.2</version>
</dependency>

1.2.2版本已經(jīng)比較完善。

啟動(dòng)

springboot配置依賴之后就可以直接啟動(dòng)了，如果當(dāng)前的spring不支持boot-starter方式，還需要配置：

使用@Autowired注入List<SqlSessionFactory> sqlSessionFactoryList;
在需要調(diào)用的類(lèi)中的初始化方法中加入以下代碼：

MapperScanner mapperScanner = new MapperScanner();
mapperScanner.scanAndRegisterJpaMethod(sqlSessionFactoryList);

分頁(yè)排序

以上配置完成以后，mybatis的Mapper直接繼承PagingAndSortingMapper，其中定義的方法可以直接使用，因?yàn)槔^承自CrudMapper，因此CrudMapper的方法也可以使用，同時(shí)也支持CrudMapper的findBy等功能。

實(shí)體類(lèi)需要加上@Table注解，指明數(shù)據(jù)庫(kù)表，同時(shí)需要和數(shù)據(jù)庫(kù)字段對(duì)應(yīng)的變量加上@Column注解，主鍵加@Id即可

支持功能如下：

1. CrudMapper中定義的方法
2. findBy和deleteBy功能
3. PagingAndSortingMapper中定義的方法
4. pageBy分頁(yè)查詢。

mapper示例：

import org.apache.ibatis.annotations.Mapper;
import com.github.ffch.jpamapper.core.domain.page.Page;
import com.github.ffch.boot.domain.UserInfo;
import com.github.ffch.jpamapper.core.domain.page.Pageable;
import com.github.ffch.jpamapper.core.mapper.PagingAndSortingMapper;
@Mapper
public interface UserInfoSortDao extends PagingAndSortingMapper<UserInfo, String> {
    Page<UserInfo> pageByPasswd(String passwd, Pageable pageable);
}

調(diào)用示例：

@RequestMapping("/selectAll")
public Collection<UserInfo> selectAll(){
    return userInfoSortDao.findAll();
}

@RequestMapping("/findAllSorted")
public Collection<UserInfo> findAllSorted(){
    Order order = new Order(Direction.ASC, "mobile");
    Order order1 = new Order(Direction.ASC, "userName");
    Sort sort = new Sort(order, order1);
    return userInfoSortDao.findAllSorted(sort );
}
@RequestMapping("/findAllPageable")
public com.github.ffch.jpamapper.core.domain.page.Page findAllPageable(){
    Pageable pageable = new Pageable();
    pageable.setPage(1);
    pageable.setSize(5);
    com.github.ffch.jpamapper.core.domain.page.Page<UserInfo> page =  userInfoSortDao.findAllPageable(pageable);
    return page;
}

@RequestMapping("/findAllPageableSort")
public com.github.ffch.jpamapper.core.domain.page.Page findAllPageableSort(){
    Pageable pageable = new Pageable();
    pageable.setPage(1);
    pageable.setSize(5);
    Order order = new Order(Direction.ASC, "mobile");
    Order order1 = new Order(Direction.ASC, "userName");
    Sort sort = new Sort(order, order1);
    pageable.setSort(sort);
    com.github.ffch.jpamapper.core.domain.page.Page<UserInfo> page =  userInfoSortDao.findAllPageable(pageable);
    return page;
}

@RequestMapping("/findPageable")
public com.github.ffch.jpamapper.core.domain.page.Page findPageable(){
    Pageable pageable = new Pageable();
    pageable.setPage(1);
    pageable.setSize(5);
    com.github.ffch.jpamapper.core.domain.page.Page<UserInfo> page =  userInfoSortDao.pageByPasswd("123", pageable);
    return page;
}

@RequestMapping("/findPageableSort")
public com.github.ffch.jpamapper.core.domain.page.Page findPageableSort(){
    Pageable pageable = new Pageable();
    pageable.setPage(1);
    pageable.setSize(5);
    Order order = new Order(Direction.ASC, "mobile");
    Order order1 = new Order(Direction.ASC, "userName");
    Sort sort = new Sort(order, order1);
    pageable.setSort(sort);
    com.github.ffch.jpamapper.core.domain.page.Page<UserInfo> page =  userInfoSortDao.pageByPasswd("123", pageable);
    return page;
}

Pageable類(lèi)支持分頁(yè)和排序；
Sort類(lèi)提供排序功能。

Page<T> 是分頁(yè)數(shù)據(jù)實(shí)體。
getPage是頁(yè)碼；getSize是分頁(yè)大??；getTotalPages分頁(yè)總數(shù)；getTotalElements是所有數(shù)量；getContent是分頁(yè)實(shí)體列表。

實(shí)體示例：

import java.io.Serializable;
import javax.persistence.*;

/**
 * The persistent class for the user_info database table.
 * 
 */
@Table(name="user_info")
public class UserInfo implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    @Column(unique=true, nullable=false, length=64)
    private String userName;

    @Column(length=20)
    private String mobile;

    @Column(length=64)
    private String name;

    @Column(nullable=false, length=32)
    private String passwd;

    @Column(length=2)
    private String valid;

    public UserInfo() {
    }

    public String getUserName() {
        return this.userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getMobile() {
        return this.mobile;
    }

    public void setMobile(String mobile) {
        this.mobile = mobile;
    }

    public String getName() {
        return this.name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPasswd() {
        return this.passwd;
    }

    public void setPasswd(String passwd) {
        this.passwd = passwd;
    }

    public String getValid() {
        return this.valid;
    }

    public void setValid(String valid) {
        this.valid = valid;
    }

    @Override
    public String toString() {
        return "UserInfo [userName=" + userName + ", mobile=" + mobile + ", name=" + name + ", passwd=" + passwd
                + ", valid=" + valid + "]";
    }
}

項(xiàng)目地址

gitee地址：https://gitee.com/xiaoyaofeiyang/JpaMapper

github地址：https://github.com/feiyangtianyao/jpa-mapper