1. 創(chuàng)建一個(gè)名為spring-data-jpa-specification-executor的Java項(xiàng)目, 同時(shí)添加相關(guān)jar包, 并添加JUnit能力。

2. 查看JpaSpecificationExecutor接口下的方法?

3. 新建User.java?

package com.bjbs.pojo;import java.io.Serializable; import java.util.Date; 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.springframework.format.annotation.DateTimeFormat;@Entity // 指定該類(lèi)是實(shí)體類(lèi) @Table(name = "user") // 指定數(shù)據(jù)庫(kù)表名(表名和實(shí)體類(lèi)對(duì)應(yīng)) public class User implements Serializable {private static final long serialVersionUID = 1L;@Id // 指定為主鍵@GeneratedValue(strategy = GenerationType.IDENTITY) // 指定主鍵生成策略@Column(name = "id") // 指定表中列名(列名和屬性名對(duì)應(yīng))private Integer id;@Column(name = "name")private String name;@Column(name = "sex")private String sex;@Column(name = "birthday")@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")private Date birthday;@Column(name = "address")private String address;public User() {}public User(String name, String sex, Date birthday, String address) {this.name = name;this.sex = sex;this.birthday = birthday;this.address = address;}public User(Integer id, String name, String sex, Date birthday, String address) {this.id = id;this.name = name;this.sex = sex;this.birthday = birthday;this.address = address;}public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getSex() {return sex;}public void setSex(String sex) {this.sex = sex;}public Date getBirthday() {return birthday;}public void setBirthday(Date birthday) {this.birthday = birthday;}public String getAddress() {return address;}public void setAddress(String address) {this.address = address;}@Overridepublic String toString() {return "User [id=" + id + ", name=" + name + ", sex=" + sex + ", birthday=" + birthday + ", address=" + address+ "]";} }

4. 新建UserRepository.java, 實(shí)現(xiàn)Repository和JpaSpecificationExecutor接口。

package com.bjbs.dao;import org.springframework.data.jpa.repository.JpaSpecificationExecutor; import org.springframework.data.repository.Repository; import com.bjbs.pojo.User;/*** 參數(shù)一T: 當(dāng)前需要映射的實(shí)體; 參數(shù)二 T: 當(dāng)前映射的實(shí)體中的id的類(lèi)型*/ public interface UserRepository extends Repository<User, Integer>, JpaSpecificationExecutor<User> {}

5. 新建UserService.java

package com.bjbs.service;import java.util.List; import org.springframework.data.domain.Page; import org.springframework.data.domain.Pageable; import org.springframework.data.domain.Sort; import org.springframework.data.jpa.domain.Specification; import com.bjbs.pojo.User;public interface UserService {public User findOne(Specification<User> spec);public List<User> findAll(Specification<User> spec);public Page<User> findAll(Specification<User> spec, Pageable pageable);public List<User> findAll(Specification<User> spec, Sort sort); }

6. 新建UserServiceImpl.java

package com.bjbs.service.impl;import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.Page; import org.springframework.data.domain.Pageable; import org.springframework.data.domain.Sort; import org.springframework.data.jpa.domain.Specification; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import com.bjbs.dao.UserRepository; import com.bjbs.pojo.User; import com.bjbs.service.UserService;@Service @Transactional public class UserServiceImpl implements UserService {@Autowiredprivate UserRepository userRepository;@Overridepublic User findOne(Specification<User> spec) {return userRepository.findOne(spec);}@Overridepublic List<User> findAll(Specification<User> spec) {return userRepository.findAll(spec);}@Overridepublic Page<User> findAll(Specification<User> spec, Pageable pageable) {return userRepository.findAll(spec, pageable);}@Overridepublic List<User> findAll(Specification<User> spec, Sort sort) {return userRepository.findAll(spec, sort);}}

7. 新建TestUserRepository.java

package com.bjbs.test;import java.util.ArrayList; import java.util.List; import javax.persistence.criteria.CriteriaBuilder; import javax.persistence.criteria.CriteriaQuery; import javax.persistence.criteria.Predicate; import javax.persistence.criteria.Root; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.Page; import org.springframework.data.domain.PageRequest; import org.springframework.data.domain.Pageable; import org.springframework.data.domain.Sort; import org.springframework.data.domain.Sort.Direction; import org.springframework.data.jpa.domain.Specification; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; import com.bjbs.pojo.User; import com.bjbs.service.UserService;@RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration("classpath:applicationContext.xml") public class TestUserRepository {@Autowiredprivate UserService userService;/*** 查詢名字叫'曹操'的用戶*/@Testpublic void findOne() {Specification<User> spe = new Specification<User>() {/*** @return Predicate: 定義了查詢條件。* @param Root<Users> root: 根對(duì)象, 封裝了查詢條件的對(duì)象。* @param CriteriaQuery<?> query: 定義了一個(gè)基本的查詢, 一般不使用。* @param CriteriaBuilder cb: 創(chuàng)建一個(gè)查詢條件。*/@Overridepublic Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder cb) {Predicate pre = cb.equal(root.get("name"), "曹操");return pre;}};User userDb = userService.findOne(spe);System.out.println(userDb);}/*** 查詢名字叫'曹操'和性別為'男'的用戶*/@Testpublic void findOneByNameAndSex() {Specification<User> spe = new Specification<User>() {@Overridepublic Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder cb) {List<Predicate> list = new ArrayList<Predicate>();list.add(cb.equal(root.get("name"), "曹操"));list.add(cb.equal(root.get("sex"), "男"));Predicate[] arr = new Predicate[list.size()];return cb.and(list.toArray(arr));}};User userDb = userService.findOne(spe);System.out.println(userDb);}/*** 查詢名字叫'曹操'和住址為'安徽省亳州市'的用戶*/@Testpublic void findOneByNameAndAddress() {Specification<User> spe = new Specification<User>() {@Overridepublic Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder cb) {return cb.and(cb.equal(root.get("name"), "曹操"), cb.equal(root.get("address"), "安徽省亳州市"));}};User userDb = userService.findOne(spe);System.out.println(userDb);}/*** 查詢名字叫'曹操'或'曹植'的用戶*/@Testpublic void findByNameOr() {Specification<User> spe = new Specification<User>() {@Overridepublic Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder cb) {return cb.or(cb.equal(root.get("name"), "曹操"), cb.equal(root.get("name"), "曹植"));}};List<User> list = userService.findAll(spe);for (User user : list) {System.out.println(user);}}/*** 查詢姓李的用戶*/@Testpublic void findByNameLike() {Specification<User> spe = new Specification<User>() {@Overridepublic Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder cb) {return cb.like(root.get("name"), "李%");}};List<User> list = userService.findAll(spe);for (User user : list) {System.out.println(user);}}/*** 分頁(yè)查詢id在47和51之間的用戶*/@Testpublic void pageable() {Specification<User> spe = new Specification<User>() {@Overridepublic Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder cb) {return cb.between(root.get("id"), 47, 51);}};Pageable pageable = new PageRequest(0, 5);Page<User> list = userService.findAll(spe, pageable);for (User user : list) {System.out.println(user);}}/*** 排序查詢id>51*/@Testpublic void sort() {Specification<User> spe = new Specification<User>() {@Overridepublic Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder cb) {return cb.greaterThan(root.get("id"), 51);}};Sort sort = new Sort(Direction.DESC, "id");List<User> list = userService.findAll(spe, sort);for (User user : list) {System.out.println(user);}}/*** 分頁(yè)排序查詢id>=51*/@Testpublic void pageableAndSort() {Specification<User> spe = new Specification<User>() {@Overridepublic Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder cb) {return cb.ge(root.get("id"), 51);}};Sort sort = new Sort(Direction.DESC, "id");Pageable pageable = new PageRequest(0, 3, sort);Page<User> list = userService.findAll(spe, pageable);for (User user : list) {System.out.println(user);}} }

8. 在src下新建application.properties

spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://192.168.25.138:3306/StudyMybatis?useSSL=true&useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai spring.datasource.username=root spring.datasource.password=lyw123456

9. 在src下新建applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?> <beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns="http://www.springframework.org/schema/beans"xmlns:context="http://www.springframework.org/schema/context"xmlns:tx="http://www.springframework.org/schema/tx"xmlns:jpa="http://www.springframework.org/schema/data/jpa"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsdhttp://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa.xsdhttp://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"><!-- 配置讀取properties文件的工具類(lèi) --><context:property-placeholder location="classpath:application.properties" /><!-- 配置c3p0數(shù)據(jù)庫(kù)連接池 --><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="jdbcUrl" value="${spring.datasource.url}" /><property name="driverClass" value="${spring.datasource.driverClassName}" /><property name="user" value="${spring.datasource.username}" /><property name="password" value="${spring.datasource.password}" /></bean><!-- Spring整合JPA 配置EntityManagerFactory --><bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"><property name="dataSource" ref="dataSource" /><property name="jpaVendorAdapter"><bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"><!-- hibernate相關(guān)的屬性的注入 --><!-- 配置數(shù)據(jù)庫(kù)類(lèi)型 --><property name="database" value="MYSQL" /><!-- 正向工程 自動(dòng)創(chuàng)建表 --><!-- <property name="generateDdl" value="true" /> --><!-- 顯示執(zhí)行的SQL --><property name="showSql" value="true" /></bean></property><!-- 掃描實(shí)體的包 --><property name="packagesToScan"><list><value>com.bjbs.pojo</value></list></property></bean><!-- 配置Hibernate的事務(wù)管理器 --><bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager"><property name="entityManagerFactory" ref="entityManagerFactory" /></bean><!-- 配置開(kāi)啟注解事務(wù)處理 --><tx:annotation-driven transaction-manager="transactionManager" /><!-- 配置springIOC的注解掃描 --><context:component-scan base-package="com.bjbs.service" /><!-- Spring Data JPA 的配置 --><!-- base-package: 掃描dao接口所在的包 --><jpa:repositories base-package="com.bjbs.dao" /> </beans>

10. 數(shù)據(jù)庫(kù)user表

11. 查詢名字叫'曹操'的用戶?

12. 查詢名字叫'曹操'和性別為'男'的用戶?

13. 查詢名字叫'曹操'和住址為'安徽省亳州市'的用戶?

14. 查詢名字叫'曹操'或'曹植'的用戶?

15. 查詢姓'李'的用戶?

16. 分頁(yè)查詢id在47和51之間的用戶?

17. 排序查詢id>51?

18. 分頁(yè)排序查詢id>=51?

總結(jié)

以上是生活随笔為你收集整理的005_Spring Data JPA条件查询的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。