SSSDJ项目day1

最新推荐文章于 2019-07-19 21:14:30 发布

Maybe?

最新推荐文章于 2019-07-19 21:14:30 发布

阅读量313

点赞数

本文链接：https://blog.csdn.net/GG__bond1/article/details/95251688

版权

一.SpringDataJpa
SpringData -> SpringDataJpa:操作数据库变得更好简单
1.pom.xml配置

<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<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>

org.springframework
spring-core
${org.springframework.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>$ {org.springframework.version}

org.springframework
spring-context-support
${org.springframework.version}

<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>

2.SpringDataJpa基本配置

1.配置对应的Spring-data-jpa
<jpa:repositories base-package=“cn.itsource.aisell.repository”
entity-manager-factory-ref=“entityManagerFactory”
transaction-manager-ref=“transactionManager”
></jpa:repositories>
2.继承JpaRepository interface EmployeeRepository extends JpaRepository<Employee,Long>, JpaSpecificationExecutor
3.完成相应的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”);

如果要把分页和排序结合起来: new PageRequest(0, 5,sort);
3.高级查询
1.名称规则
findByUsername(String username) -> 根据名称查询 username = ?
findByUsernameLike(String username) -> username like ?
findByUsernameLikeAndEmailLike(String username,String email) -> username like ? and email like ?
详细规则请看文件(idea也有提示)
2.Query注解
@Query(“jpql的语句”)
@Query(“select o from Employee o where o.name like ?1”)
//@Query(“select o from Employee o where o.name like :name”)
@Query(nativeQuery = true,value=“select * from employee”)
二.高级查询与分页
1.JpaSpecificationExecutor
可以不写SQL也能够完成功能
1.我们的Repository继承JpaSpecificationExecutor
EmployeeRepository extends JpaRepository<Employee,Long>,
JpaSpecificationExecutor2.findAll的查询方法
employeeRepository.findAll(Specification spec)
employeeRepository.findAll(Specification spec,Pageable pageable)
new Specification{
//root:(根,表)获取字段
//query:where,group by ,order by…
//cb: 条件判断(一个或者多个)
@Override
public Predicate toPredicate(Root root,
CriteriaQuery<?> query,
CriteriaBuilder cb) {
Path path = root.get(“username”);//拿到要做查询的字段
Predicate p = cb.like(path, “%1%”);//like代表做模糊查询，后面就是它的条件值
return p;
}
}
2.jpa-spec

com.github.wenhao
jpa-spec
3.1.0

//第一个参数: true -> 条件过滤启用//第二个参数: 需要过滤的属性//第三个参数: 过滤条件的？对应的值
Specification specification = Specifications.and()
.eq(StringUtils.isNotBlank(request.getName()), “name”, name)
.gt(Objects.nonNull(request.getAge()), “age”, 18)
.build();
3.Query的抽取
Query作用:接收前台传过来的查询条件(分页,数据)BaseQuery:公共的查询【规范,公共的代码】
int currentPage=1;
getJpaPage{return currentPage-1}
int pageSize=10;
String orderName;
Boolean orderType=true;
提供getter,setter方法
//规定子类必需提供一个拿到条件的方法
protected abstract Specification createSpec();
//提供获取排序的方法
Sort createSort(){
//1.如果orderName没有值，就返回null【不排序】
//2.如果orderType是DESC,就升级(反之就降序)
}EmployeeQuery:Employee单独的查询
username,email,age,…
Specification createSpec(){…}

Maybe?

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SSSDJ项目day1

一.SpringDataJpaSpringData -> SpringDataJpa:操作数据库变得更好简单1.pom.xml配置<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><org.springframework.version>4.2.5.RELEASE&...
复制链接

扫一扫