智能商贸1之SpringDataJpa

最新推荐文章于 2022-05-08 17:24:02 发布

Sign_L

最新推荐文章于 2022-05-08 17:24:02 发布

阅读量229

点赞数

分类专栏： Java 文章标签： SpringDataJpa

本文链接：https://blog.csdn.net/Sign_L/article/details/94715247

版权

Java 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

SpringDataJpa

pom.xml配置

1.导包

<dependency>
      <groupId>org.springframework.data</groupId>
      <artifactId>spring-data-jpa</artifactId>
      <version>1.9.0.RELEASE</version>
</dependency>

2.配置SpringDataJpa

<jpa:repositories base-package="cn.itsource.aisell.repository"
            entity-manager-factory-ref="entityManagerFactory"
            transaction-manager-ref="transactionManager"
></jpa:repositories>

3.pom.xml

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>cn.liqiuyang</groupId>
  <artifactId>aisale</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>aisale Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

    <properties>
      <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
      <maven.compiler.source>1.8</maven.compiler.source>
      <maven.compiler.target>1.8</maven.compiler.target>
      <org.springframework.version>4.2.5.RELEASE</org.springframework.version>
      <org.hibernate.version>4.3.8.Final</org.hibernate.version>
      <spring-data-jpa.version>1.9.0.RELEASE</spring-data-jpa.version>
      <com.fasterxml.jackson.version>2.5.0</com.fasterxml.jackson.version>
      <org.slf4j.version>1.6.1</org.slf4j.version>
    </properties>
    <dependencies>
      <!-- Spring的支持包 -->
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${org.springframework.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${org.springframework.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${org.springframework.version}</version>
      </dependency>

      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${org.springframework.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>${org.springframework.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${org.springframework.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</artifactId>
        <version>${org.springframework.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-test</artifactId>
        <version>${org.springframework.version}</version>
        <scope>test</scope>
      </dependency>
      <!-- 引入web前端的支持 -->
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${org.springframework.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${org.springframework.version}</version>
      </dependency>
      <!-- SpringMCV上传需要用到io包-->
      <dependency>
        <groupId>org.apache.commons</groupId>
        <artifactId>commons-io</artifactId>
        <version>1.3.2</version>
      </dependency>
      <!-- 文件上传用到的包 -->
      <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.2.2</version>
      </dependency>
      <!-- SpringMVC的json支持包 -->
      <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>${com.fasterxml.jackson.version}</version>
      </dependency>
      <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-annotations</artifactId>
        <version>${com.fasterxml.jackson.version}</version>
      </dependency>
      <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>${com.fasterxml.jackson.version}</version>
      </dependency>
      <!-- hibernate的支持包 -->
      <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-core</artifactId>
        <version>${org.hibernate.version}</version>
      </dependency>
      <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-entitymanager</artifactId>
        <version>${org.hibernate.version}</version>
      </dependency>
      <!-- SpringData的支持包 -->
      <dependency>
        <groupId>org.springframework.data</groupId>
        <artifactId>spring-data-jpa</artifactId>
        <version>${spring-data-jpa.version}</version>
      </dependency>
      <!-- SpringData的擴展包 -->
      <dependency>
        <groupId>com.github.wenhao</groupId>
        <artifactId>jpa-spec</artifactId>
        <version>3.1.1</version>
        <!-- 把所有的依賴都去掉 -->
        <exclusions>
          <exclusion>
            <groupId>*</groupId>
            <artifactId>*</artifactId>
          </exclusion>
        </exclusions>
      </dependency>

      <dependency>
        <groupId>commons-dbcp</groupId>
        <artifactId>commons-dbcp</artifactId>
        <version>1.2.2</version>
      </dependency>

      <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.6</version>
      </dependency>

      <dependency>
        <groupId>org.apache.commons</groupId>
        <artifactId>commons-lang3</artifactId>
        <version>3.5</version>
      </dependency>
      <!-- 測試包 -->
      <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>test</scope>
      </dependency>
      <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>javax.servlet-api</artifactId>
        <version>3.1.0</version>
        <!-- 这个scope 只能作用在编译和测试时，同时没有传递性。表示在运行的时候不添加此jar文件 -->
        <scope>provided</scope>
      </dependency>
      <!-- 日志文件 -->
      <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${org.slf4j.version}</version>
      </dependency>
      <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-log4j12</artifactId>
        <version>${org.slf4j.version}</version>
        <scope>runtime</scope>
      </dependency>
      <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.14</version>
      </dependency>
      <!-- 代码生成器模版技术 -->
      <dependency>
        <groupId>org.apache.velocity</groupId>
        <artifactId>velocity</artifactId>
        <version>1.6</version>
      </dependency>
      <!-- shiro的支持包 -->
      <dependency>
        <groupId>org.apache.shiro</groupId>
        <artifactId>shiro-all</artifactId>
        <version>1.4.0</version>
        <type>pom</type>
      </dependency>
      <!-- shiro与Spring的集成包 -->
      <dependency>
        <groupId>org.apache.shiro</groupId>
        <artifactId>shiro-spring</artifactId>
        <version>1.4.0</version>
      </dependency>
      <!-- poi支持的jar包 -->
      <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>3.11</version>
      </dependency>
      <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>3.11</version>
      </dependency>
      <!-- 图片压缩功能 -->
      <!-- 缩略图 -->
      <dependency>
        <groupId>net.coobird</groupId>
        <artifactId>thumbnailator</artifactId>
        <version>0.4.6</version>
      </dependency>
      <!-- 定时调度 -->
      <dependency>
        <groupId>quartz</groupId>
        <artifactId>quartz</artifactId>
        <version>1.5.2</version>
      </dependency>
      <!-- 邮件支持 -->
      <dependency>
        <groupId>javax.mail</groupId>
        <artifactId>mail</artifactId>
        <version>1.4.1</version>
      </dependency>
    </dependencies>

    <build>
      <finalName>yxb</finalName>
      <plugins>
        <plugin>
          <groupId>org.apache.maven.plugins</groupId>
          <artifactId>maven-compiler-plugin</artifactId>
          <configuration>
            <source>1.8</source>
            <target>1.8</target>
          </configuration>
        </plugin>
        <plugin>
          <groupId>org.mortbay.jetty</groupId>
          <artifactId>jetty-maven-plugin</artifactId>
          <version>8.1.15.v20140411</version>
          <configuration>
            <stopPort>9966</stopPort>
            <stopKey>foo</stopKey>
            <webAppConfig>
              <contextPath>/</contextPath>
            </webAppConfig>
          </configuration>
        </plugin>
      </plugins>
    </build>
  </project>

使用SpringDataJpa

抽取basedomain,注意@MappedSuperclass注解
Repository 包下->写接口->继承JpaRepository

使用employeeRepository对象上的方法完成CRUD及普通条件查询,分页及排序

employeeRepository.findAll();
   employeeRepository.findOne(Long id);
   employeeRepository.save(对象); //添加或者修改
   employeeRepository.delete(id/对象);
   employeeRepository.findAll(Pageable) -> 分页
       Pageable pageable = new PageRequest(0, 5); //0就是第一页
   employeeRepository.findAll(Sort) -> 排序
       Sort sort = new Sort(Sort.Direction.DESC,"username");

高级查询

在接口内定义规范的方法,名称按要求取!!

public interface EmployeeRepository extends JpaRepository<Employee, Long> {
    //根据名称模糊查询
    List<Employee> findByUsernameLike(String username);
    //根据名称进行查询
    List<Employee> findByUsername(String username);
}

@Query注解查询

注意: 占位符 ? 后面必须跟上位置编号!!!

@Query("select o from cn.itsource.pss.domain.Employee o where  o.username like ?1 and o.email like ?2")
List<Employee> query02(String username,String email);

原生sql

@Query(value="SELECT COUNT(*) FROM employee",nativeQuery = true)
Long queryCount();

接口继承JpaSpecificationExecutor

employeeRepository.findAll(Specification<T> spec)
    employeeRepository.findAll(Specification<T> spec,Pageable pageable)
    new Specification<Employee>{
        //root:(根,表)获取字段  
        //query:where,group by ,order by...
        //cb: 条件判断(一个或者多个)
         @Override
        public Predicate toPredicate(Root<Employee> root, 
                                    CriteriaQuery<?> query, 
                                    CriteriaBuilder cb) {
            Path path = root.get("username");//拿到要做查询的字段
            Predicate p = cb.like(path, "%1%");//like代表做模糊查询，后面就是它的条件值
            return p;
        }
    }

jpa-spec插件

导包

<dependency>
  <groupId>com.github.wenhao</groupId>
  <artifactId>jpa-spec</artifactId>
  <version>3.1.1</version>
  <!-- 把所有依赖都过滤 -->
  <exclusions>
    <exclusion>
      <groupId>*</groupId>
      <artifactId>*</artifactId>
    </exclusion>
  </exclusions>
</dependency>

使用

@Test
public void testSpecFind03() {
    Specification<Employee> spec = Specifications.<Employee>and().like("username", "%1%").build();
    //排序 ：第一个参数是排序的规则(DESC/ASC)  后面参数是排序的字符
    Sort sort = new Sort(Sort.Direction.DESC,"username");
    Pageable pageable = new PageRequest(0, 10,sort);

    Page<Employee> page = employeeRepository.findAll(spec, pageable);
    for (Employee emp : page) {
        System.out.println(emp);
    }
}

Query查询条件

父类BaseQuery,主要写分页内容,排序方法及定义获取查询条件的方法

public  abstract class BaseQuery {
    private int currentPage = 1;
    private int pageSize = 10;
    //定义1个字段表示排序规则
    private String OrderName;
    //排序类型
    private String OrderType = "ASC";
    //统一创建对象方法的名称
    public abstract Specification createSpec();
    //方法返回排序对象
    public Sort createSort(){
        if (StringUtils.isNotBlank(OrderName)){
            return new Sort(Sort.Direction.valueOf(OrderType),OrderName);
        }
        return null;
    }
}

子类EmployeeQuery,主要写对象上的字段及实现的父类的方法

public class EmployeeQuery extends BaseQuery {
    private String username;
    private String email;
    private Integer age;
    //覆写方法
    @Override
    public Specification createSpec() {
        Specification<Employee> specification = Specifications.<Employee>and().like("username", "%" + username + "%")
                .like("email", "%" + email + "%")
                .gt("age", age).build();
        return specification;
    }
}