Spring整合JpaMapper(Mybatis通用插件)详情

品茗IT

发布于 2019-09-12 10:42:38

1.3K0

发布于 2019-09-12 10:42:38

文章被收录于专栏：品茗IT

Spring整合JpaMapper(Mybatis通用插件)详情

一、概述

如果你喜欢Jpa hibernate的简洁写法；

或许你不喜欢写sql；

或许你用了Mapper工具之后还是要写sql；

那就用JpaMapper吧！JpaMapper是尽量按照JPA hibernate的书写风格，对mybatis进行封装，是CRUD操作更加简单易用，免于不断写sql。

前面一篇《Spring和Mybatis整合详解》介绍了Spring如何结合mybatis进行数据库访问操作。这一篇介绍下springmvc环境下JpaMapper的使用。

代码可以在Spring组件化构建https://www.pomit.cn/java/spring/spring.html中的JpaMapper组件中查看，并下载。

**如果大家正在寻找一个java的学习环境，或者在开发中遇到困难，可以<a

href="https://jq.qq.com/?_wv=1027&k=52sgH1J"

target="_blank">

加入我们的java学习圈，点击即可加入

</a>

，共同学习，节约学习时间，减少很多在学习中遇到的难题。**

二、环境配置

本文假设你已经引入Spring必备的一切了，已经是个Spring项目了,如果不会搭建，可以打开这篇文章看一看《Spring和Spring Mvc 5整合详解》。

2.1 maven依赖

和前面的《Spring和Mybatis整合详解》的配置一样，

使用Mybatis需要引入mybatis和mybatis-spring，已经数据源和connector;另外，需要引入jpa-mapper-core。

注意：jpa-mapper要求Mybatis版本在3.4.6以上，如果mybatis-spring版本是1.3.2, Mybatis版本就是3.4.6。

<?xml version="1.0"?>
<project
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"
	xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>cn.pomit</groupId>
		<artifactId>SpringWork</artifactId>
		<version>0.0.1-SNAPSHOT</version>
	</parent>
	<artifactId>JpaMapper</artifactId>
	<packaging>jar</packaging>
	<name>JpaMapper</name>
	<url>http://maven.apache.org</url>
	<dependencies>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-web</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
		</dependency>
		<dependency>
			<groupId>org.apache.commons</groupId>
			<artifactId>commons-dbcp2</artifactId>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
		</dependency>
		<dependency>
			<groupId>cn.pomit</groupId>
			<artifactId>jpa-mapper-core</artifactId>
			<version>2.1</version>
		</dependency>
				<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-annotations</artifactId>
		</dependency>
		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-core</artifactId>
		</dependency>
		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-databind</artifactId>
		</dependency>
	</dependencies>
	<build>
		<finalName>JpaMapper</finalName>
	</build>
</project>

父模块可以在https://www.pomit.cn/spring/SpringWork/pom.xml获取。

2.2 Spring配置

需要配置数据源、jdbcTemplate、sqlSessionFactory、transactionManager和MapperScannerConfigurer。

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="
                    http://www.springframework.org/schema/beans
                    http://www.springframework.org/schema/beans/spring-beans.xsd
                    http://www.springframework.org/schema/tx 
                    http://www.springframework.org/schema/tx/spring-tx.xsd
                    http://www.springframework.org/schema/aop 
                    http://www.springframework.org/schema/aop/spring-aop.xsd
                    http://www.springframework.org/schema/context      
                    http://www.springframework.org/schema/context/spring-context.xsd">

	<bean id="annotationPropertyConfigurerJpaMapper"
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="order" value="1" />
		<property name="ignoreUnresolvablePlaceholders" value="true" />
		<property name="locations">
			<list>
				<value>classpath:db.properties</value>
			</list>
		</property>
	</bean>
	
	<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close">
		<property name="driverClassName" value="${db.dirverClass}"></property>
		<property name="url" value="${db.url}" />
		<property name="username" value="${db.username}" />
		<property name="password" value="${db.password}" />

		<property name="initialSize" value="1" />
		<property name="minIdle" value="1" />
		<property name="maxTotal" value="20" />

		<property name="validationQuery" value="SELECT 1" />
		<property name="testWhileIdle" value="true" />
		<property name="testOnBorrow" value="false" />
		<property name="testOnReturn" value="false" />
	</bean>

	<bean id="transactionManager"
		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"></property>
	</bean>

	<tx:annotation-driven transaction-manager="transactionManager" />

	<!-- jdbcTemplate -->
	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="dataSource"></property>
	</bean>

	<!-- mybatis -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="configLocation" value="classpath:mybatis/mybatis-config.xml" />
		
	</bean>
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="cn.pomit.springwork.mybatis.mapper" />
	</bean>
</beans>

这里面，需要注意的是：

dataSource，这里用的是dbcp2数据源。
sqlSessionFactory，是mybatis的连接信息配置。
MapperScannerConfigurer，指明mapper的路径，要使用Mybatis的注解sql必须指明。
transactionManager，事务处理器。
tx:annotation-driven:开启事务注解。

mybatis.properties中存放数据库的地址端口等连接信息。

mybatis.properties：

db.url=jdbc:mysql://127.0.0.1:3306/boot?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
db.username=cff
db.password=123456
db.dirverClass=com.mysql.cj.jdbc.Driver

mybatis/mybatis-config.xml：

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">  
<configuration> 
<settings>    
        <setting name="logImpl" value="STDOUT_LOGGING" />      
    </settings> 
</configuration>

这里我只配置了日志打印功能。

三、JpaMapper配置

@Configuration配置JpaMapper，@Autowired注入List<SqlSessionFactory> sqlSessionFactoryList。

如果启动过程中出现：

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):出现这种问题，是因为JpaMapper处理Mapper的过程中，Mapper还未生成，而mapper是在service注入的时候才生成的。所以需要调整bean的生成顺序。可以使用下面两种方式：将MapperScanner作为bean生成，需要使用@Order将MapperScanner生成顺序调整到最低，以便在生成mapper的所有bean之后再初始化。经试验，这种方式不带@Order也可以将bean的生成顺序调整到Service相关bean之后。将JpaMapperConfig的bean生成时间使用@DependsOn("userInfoService")调整顺序到userInfoService之后。JpaMapperConfig:

package cn.pomit.springwork.mybatis;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import org.apache.ibatis.binding.MapperRegistry;

import org.apache.ibatis.session.SqlSessionFactory;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import cn.pomit.jpamapper.core.MapperScanner;

import cn.pomit.jpamapper.core.mapper.register.MappedStatementRegister;

/**

Mapper 配置
@author cff */ @Configuration public class JpaMapperConfig {

@Bean

public MapperScanner mapperScanner(List<SqlSessionFactory> sqlSessionFactoryList) throws SQLException {

	MapperScanner mapperScanner = new MapperScanner();

	for (SqlSessionFactory sqlSessionFactory : sqlSessionFactoryList) {

		org.apache.ibatis.session.Configuration configuration = sqlSessionFactory.getConfiguration();

		MapperRegistry mapperRegistry = configuration.getMapperRegistry();

		List<Class<?>> mappers = new ArrayList<>(mapperRegistry.getMappers());

		MappedStatementRegister mappedStatementRegister = new MappedStatementRegister(configuration);

		mappedStatementRegister.addMappers(mappers);

		mapperScanner.addMappedStatementRegister(mappedStatementRegister);

	mapperScanner.scanAndRegisterJpaMethod();

	return mapperScanner;

}

这里，使用 mapperScanner.scanAndRegisterJpaMethod(); 对mybatis已有的mapper进行扫描，自动记录jpaMapper支持的方法，并加入mybatis的mapper管理中。

## 四、数据访问

### 4.1 普通CRUD

#### 4.1.1 Mapper
mybatis的Mapper直接继承CrudMapper即可.

可以使用以下方式进行数据库的操作：

- CrudMapper中定义的方法
- findBy+字段名进行查询。
- deleteBy + 字段名进行查询。
- 主键取回策略@GeneratedValue与@SelectKey；@GeneratedValue(generator="JDBC")代表使用mybatis的Jdbc3KeyGenerator。对应自增。@SelectKey注解（非mybatis的注解，但和mybatis的注解一致，这里是为了将SelectKey注解扩展到字段上）添加到字段上，和mybatis的@SelectKey注解功能一致

UserInfoDao :

```java

package cn.pomit.springwork.mybatis.mapper;

import java.util.Collection;

import java.util.List;

import org.apache.ibatis.annotations.Insert;

import org.apache.ibatis.annotations.Mapper;

import org.apache.ibatis.annotations.Param;

import cn.pomit.jpamapper.core.mapper.CrudMapper;

import cn.pomit.springwork.mybatis.domain.UserInfo;

@Mapper

public interface UserInfoDao extends CrudMapper<UserInfo, String> {

```javascript

List<UserInfo> findByMobile(String mobile);

```javascript

int saveAllWithId(@Param("list") Collection<UserInfo> entities);

```javascript

@Insert({"<script> ",

```javascript

"INSERT INTO user_info",

```javascript

"( ",

```javascript

"<if test='_parameter.userName != null'> userName , </if> ",

```javascript

"<if test='_parameter.mobile != null'> mobile , </if> ",

```javascript

"<if test='_parameter.name != null'> name , </if> ",

```javascript

"<if test='_parameter.passwd != null'> passwd , </if> ",

```javascript

"<if test='_parameter.valid != null'> valid </if> ",

```javascript

") ",

```javascript

" values ",

```javascript

"( ",

```javascript

"<if test='_parameter.userName != null'> #{_parameter.userName}, </if> ",

```javascript

"<if test='_parameter.mobile != null'> #{_parameter.mobile}, </if> ",

```javascript

"<if test='_parameter.name != null'> #{_parameter.name}, </if> ",

```javascript

"<if test='_parameter.passwd != null'> #{_parameter.passwd}, </if> ",

```javascript

" <if test='_parameter.valid != null'> #{_parameter.valid} </if> ",

```javascript

" ) ",

```javascript

"</script>"})

```javascript

int saveTest(UserInfo entity);

```javascript

int deleteByUserName(String userName);

```javascript

List<UserInfo> findByNameAndMobile(String name, String mobile);

```javascript

int deleteByNameAndMobile(String name, String mobile);

}

```javascript

4.1.2 实体

实体类需要加上@Table注解，指明数据库表，同时需要和数据库字段对应的变量加上@Column注解，主键加@Id即可。

注意：所有非主键字段都要加上@Column注解，无论是否需要改变字段名称。

UserInfo :

package cn.pomit.springwork.mybatis.domain;

import java.io.Serializable;

import javax.persistence.Column;

import javax.persistence.Id;

import javax.persistence.Table;

/**

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(name="user_name")

private String userName;

@Column()

private String mobile;

@Column()

private String name;

@Column()

private String passwd;

@Column()

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 + "]";

}

### 4.2 分表查询

#### 4.2.1 Mapper

新建Mapper直接继承SimpleShardingMapper即可。但是需要在泛型实体中对分表字段做配置。

```java

package cn.pomit.springwork.mybatis.mapper;

import org.apache.ibatis.annotations.Mapper;

import cn.pomit.jpamapper.core.mapper.SimpleShardingMapper;

import cn.pomit.springwork.mybatis.domain.UserInfoHis;

@Mapper

public interface UserInfoHisDao extends SimpleShardingMapper<UserInfoHis, String> {

}

```javascript

4.2.2 实体

实体类需要加上@Table注解，指明数据库表，同时需要和数据库字段对应的变量加上@Column注解，主键加@Id即可。

在分表字段上，使用@ShardingKey注解。

注意：所有非主键字段都要加上@Column注解，无论是否需要改变字段名称。

SimpleShardingMapper只支持SimpleShardingMapper中定义的方法。不支持xxxBy这样写法。

这里的@Table指明的是分表的通用前缀。结合@ShardingKey注解，构成了多个表名称。

@ShardingKey注解：

prefix，表名称与分表策略返回值之间的分割符。
methodPrecis，唯一表的指定策略。
methodRange，多个表的指定策略。
suffix，表名称与分表策略返回值组合后可以添加的后缀。

UserInfoHis :

package cn.pomit.springwork.mybatis.domain;

import java.io.Serializable;

import javax.persistence.*;

import com.fasterxml.jackson.annotation.JsonIgnore;

import cn.pomit.jpamapper.core.annotation.ShardingKey;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

/**

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

@Id

@Column(name="user_name")

private String userName;

@Column()

@ShardingKey(prefix="_", methodPrecis="getTable", methodRange = "getTables")

private String mobile;

@Column()

private String name;

@Column()

private String passwd;

@Column()

private String valid;

public UserInfoHis() {

public String getUserName() {

	return this.userName;

public void setUserName(String userName) {

	this.userName = userName;

public String getMobile() {

	return this.mobile;

@JsonIgnore

public static String getTable(Object mobile) {

	int index = Integer.parseInt(mobile.toString()) % 5;

	return String.valueOf(index);

@JsonIgnore

public static String[] getTables(Object start, Object end) {

	Map<Integer, String> maps = new HashMap<>();

	int index = 0;

	for(int i = Integer.parseInt(start.toString()); i < Integer.parseInt(end.toString()); i++){

		if(index >= 5)break;

		maps.put(index, String.valueOf(i % 5));

		index++;

	List<String> mapValueList = new ArrayList<String>(maps.values());

	String[] arr = new String[mapValueList.size()];

	return mapValueList.toArray(arr);

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 + "]";

}

这里：

- @ShardingKey的**methodPrecis和methodRange**指定是**该实体**中的**static**方法，这一点一定要注意。

- @ShardingKey的prefix是分表策略与表名称结合时候的前缀。如上面的实体指定表名为user_info_his，prefix是&#95;。**methodPrecis和methodRange**指定的两个方法返回的是数字1、2、3 ...;这时，分表就包含了user&#95;info&#95;his&#95;1、user&#95;info&#95;his&#95;2、user&#95;info&#95;his&#95;3 ...

- 上面的getTable方法是按照mobile取余标明了从哪一张表中取数据。getTables方法根据起始字段查出一个表的范围。


### 4.3 分页查询

#### 4.3.1 Mapper
mybatis的Mapper直接继承PagingAndSortingMapper即可实现分页功能.

支持功能如下：
1. CrudMapper中定义的方法
2. findBy和deleteBy功能(不能带分页实体)
3. PagingAndSortingMapper中定义的方法
4. pageBy分页查询(类似带分页实体的findBy)。
5. sortBy排序条件查询(**2.0版本新特性**)。

UserInfoSortDao :

```java

package cn.pomit.springwork.mybatis.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import cn.pomit.jpamapper.core.domain.page.Page;

import cn.pomit.jpamapper.core.domain.page.Pageable;

import cn.pomit.jpamapper.core.domain.page.Sort;

import cn.pomit.jpamapper.core.mapper.PagingAndSortingMapper;

import cn.pomit.springwork.mybatis.domain.UserInfo;

@Mapper

public interface UserInfoSortDao extends PagingAndSortingMapper<UserInfo, String> {

```javascript

Page<UserInfo> pageByPasswd(String passwd, Pageable pageable);

```javascript

List<UserInfo> sortByPasswd(String passwd, Sort sort);

}

```javascript

4.3.2 实体

实体类需要加上@Table注解，指明数据库表，同时需要和数据库字段对应的变量加上@Column注解，主键加@Id即可

实体和4.1.2的实体一致。

4.4 联表查询

4.4.1 Mapper

同样，将新建的Mybatis的Mapper直接继承CrudMapper即可.

在需要联表查询的字段上，增加@Many或者@One注解，同时增加@JoinColumns或者@JoinColumn注解。即可实现联表查询。

分表情况下不能使用联表操作，联表默认无效。

UserInfoUnionDao:

package cn.pomit.springwork.mybatis.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import cn.pomit.jpamapper.core.mapper.CrudMapper;

import cn.pomit.springwork.mybatis.domain.UserInfoUnion;

@Mapper

public interface UserInfoUnionDao extends CrudMapper<UserInfoUnion, String> {

List<UserInfoUnion> findByMobile(String mobile);

}

#### 4.4.2 实体

在需要联表查询的字段上，增加@Many或者@One注解，同时增加@JoinColumns或者@JoinColumn注解。即可实现联表查询。

其中，@Many和@One是JpaMapper的注解。@JoinColumns和@JoinColumn使用了javax.persistence包中的注解。

@JoinColumn注解只有name和referencedColumnName字段有效，并且这两个字段分别对应着两个实体中的属性名，而不是表字段名。

UserInfoUnion :

```java

package cn.pomit.springwork.mybatis.domain;

import java.io.Serializable;

import java.util.List;

import javax.persistence.Column;

import javax.persistence.Id;

import javax.persistence.JoinColumn;

import javax.persistence.JoinColumns;

import javax.persistence.Table;

import org.apache.ibatis.mapping.FetchType;

import cn.pomit.jpamapper.core.annotation.Many;

/\*\*

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

```javascript

@Id

```javascript

@Column(name = "user_name")

```javascript

private String userName;

```javascript

@Column()

```javascript

private String mobile;

```javascript

@Column()

```javascript

private String name;

```javascript

@Column()

```javascript

private String passwd;

```javascript

@Column()

```javascript

private String valid;

```javascript

@Many(fetchType = FetchType.EAGER)

```javascript

@JoinColumns({ @JoinColumn(name = "userName", referencedColumnName = "userName") })

```javascript

private List<UserRole> userRole;

```javascript

public UserInfoUnion() {

```javascript

}

```javascript

public String getUserName() {

```javascript

return this.userName;

```javascript

}

```javascript

public void setUserName(String userName) {

```javascript

this.userName = userName;

```javascript

}

```javascript

public String getMobile() {

```javascript

return this.mobile;

```javascript

}

```javascript

public void setMobile(String mobile) {

```javascript

this.mobile = mobile;

```javascript

}

```javascript

public String getName() {

```javascript

return this.name;

```javascript

}

```javascript

public void setName(String name) {

```javascript

this.name = name;

```javascript

}

```javascript

public String getPasswd() {

```javascript

return this.passwd;

```javascript

}

```javascript

public void setPasswd(String passwd) {

```javascript

this.passwd = passwd;

```javascript

}

```javascript

public String getValid() {

```javascript

return this.valid;

```javascript

}

```javascript

public void setValid(String valid) {

```javascript

this.valid = valid;

```javascript

}

```javascript

public List<UserRole> getUserRole() {

```javascript

return userRole;

```javascript

}

```javascript

public void setUserRole(List<UserRole> userRole) {

```javascript

this.userRole = userRole;

```javascript

}

```javascript

@Override

```javascript

public String toString() {

```javascript

return "UserInfo [userName=" + userName + ", mobile=" + mobile + ", name=" + name + ", passwd=" + passwd

```javascript

		+ ", valid=" + valid + "]";

```javascript

}

}

```javascript

五、Service层逻辑

service分别对各个mapper进行调用。

UserInfoService :

package cn.pomit.springwork.mybatis.service;

import java.util.Collection;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import cn.pomit.jpamapper.core.domain.page.Page;

import cn.pomit.jpamapper.core.domain.page.Pageable;

import cn.pomit.springwork.mybatis.domain.UserInfo;

import cn.pomit.springwork.mybatis.domain.UserInfoHis;

import cn.pomit.springwork.mybatis.domain.UserInfoUnion;

import cn.pomit.springwork.mybatis.mapper.UserInfoDao;

import cn.pomit.springwork.mybatis.mapper.UserInfoHisDao;

import cn.pomit.springwork.mybatis.mapper.UserInfoSortDao;

import cn.pomit.springwork.mybatis.mapper.UserInfoUnionDao;

@Service

public class UserInfoService {

@Autowired

UserInfoDao userInfoDao;

@Autowired

UserInfoHisDao userInfoHisDao;

@Autowired

UserInfoSortDao userInfoSortDao;

@Autowired

UserInfoUnionDao userInfoUnionDao;

public UserInfo getUserInfoByUserName(String userName) {

	return userInfoDao.findOne(userName);

public List<UserInfo> findByMobile(String mobile) {

	return userInfoDao.findByMobile(mobile);

public Collection<UserInfoHis> findByMobileSharding(String mobile) {

	UserInfoHis userInfoHis = new UserInfoHis();

	userInfoHis.setMobile(mobile);

	return userInfoHisDao.find(userInfoHis);

public Page<UserInfo> findByPage(String passwd) {

	Pageable pageable = new Pageable();

	pageable.setPage(1);

	pageable.setSize(5);

	Page<UserInfo> page = userInfoSortDao.pageByPasswd(passwd, pageable);

	return page;

public List<UserInfoUnion> findUnion(String mobile) {

	return userInfoUnionDao.findByMobile(mobile);

}

## 六、测试web

写一个测试web对这些mapper进行测试。

JpaMapperRest :
```java

package cn.pomit.springwork.mybatis.web;

import java.util.Collection;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RestController;

import cn.pomit.jpamapper.core.domain.page.Page;

import cn.pomit.springwork.mybatis.domain.UserInfo;

import cn.pomit.springwork.mybatis.domain.UserInfoHis;

import cn.pomit.springwork.mybatis.domain.UserInfoUnion;

import cn.pomit.springwork.mybatis.service.UserInfoService;

@RestController

@RequestMapping("/jpamapper")

public class JpaMapperRest {

```javascript

@Autowired

```javascript

UserInfoService userInfoService;

```javascript

@RequestMapping("/user")

```javascript

public UserInfo getUserInfoByUserName() {

```javascript

return userInfoService.getUserInfoByUserName("cff");

```javascript

}

```javascript

@RequestMapping("/findByMobile")

```javascript

public List<UserInfo> findByMobile() {

```javascript

return userInfoService.findByMobile("3242");

```javascript

}

```javascript

@RequestMapping("/findByMobileSharding")

```javascript

public Collection<UserInfoHis> findByMobileSharding() {

```javascript

return userInfoService.findByMobileSharding("3242");

```javascript

}

```javascript

@RequestMapping("/findByPage")

```javascript

public Page<UserInfo> findByPage() {

```javascript

return userInfoService.findByPage("123455");

```javascript

}

```javascript

@RequestMapping("/findUnion")

```javascript

public List<UserInfoUnion> findUnion() {

```javascript

return userInfoService.findUnion("3242");

```javascript

}

}

```javascript

七、过程中用到的其他实体

UserRole :

package cn.pomit.springwork.mybatis.domain;

import java.io.Serializable;

import javax.persistence.*;

/**

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

@Id

@GeneratedValue(generator="JDBC")

@Column()

private Integer id;

@Column(length=10)

private String role;

@Column(name="user_name")

private String userName;

@Column(name ="phone")

private String phone;

public String getUserName() {

	return userName;

public void setUserName(String userName) {

	this.userName = userName;

public UserRole() {

public Integer getId() {

	return id;

public void setId(Integer id) {

	this.id = id;

public String getRole() {

	return this.role;

public void setRole(String role) {

	this.role = role;

@Override

public String toString() {

	return "UserRole [id=" + id + ", role=" + role + ", userName=" + userName + "]";

public String getPhone() {

	return phone;

public void setPhone(String phone) {

	this.phone = phone;

}

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。

原始发表：2019/08/05 ，如有侵权请联系 cloudcommunity@tencent.com 删除

mybatis

本文分享自作者个人站点/博客前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

本文参与腾讯云自媒体同步曝光计划，欢迎热爱写作的你一起参与！

Spring整合JpaMapper(Mybatis通用插件)详情

Spring整合JpaMapper(Mybatis通用插件)详情

Spring整合JpaMapper(Mybatis通用插件)详情

一、概述

二、环境配置

2.1 maven依赖

2.2 Spring配置

三、JpaMapper配置

4.1.2 实体

4.2.2 实体

4.3.2 实体

4.4 联表查询

4.4.1 Mapper

五、Service层逻辑

七、过程中用到的其他实体

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐