基于springWeb+Spring Data Jpa项目配置

创建spring web项目

导入相关依赖

<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>
    <spring.version>5.2.8.RELEASE</spring.version>
    <hibnate.version>5.4.32.Final</hibnate.version>
    <mysql.version>8.0.21</mysql.version>
  </properties>

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

<!--    spring web依赖-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${spring.version}</version>
    </dependency>

<!--data jpa-->
    <dependency>
      <groupId>org.springframework.data</groupId>
      <artifactId>spring-data-jpa</artifactId>
      <version>2.3.2.RELEASE</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->
    <dependency>
      <groupId>org.hibernate</groupId>
      <artifactId>hibernate-core</artifactId>
      <version>${hibnate.version}</version>
    </dependency>
    <dependency>
      <groupId>org.hibernate</groupId>
      <artifactId>hibernate-entitymanager</artifactId>
      <version>${hibnate.version}</version>
    </dependency>

<!--lombok-->
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.20</version>
      <scope>provided</scope>
    </dependency>
<!--mysql-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>${mysql.version}</version>
    </dependency>

<!--测试-->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.13</version>
      <scope>test</scope>
    </dependency>
  </dependencies>

配置property文件

mysql.driverClass = com.mysql.cj.jdbc.Driver
mysql.url = jdbc:mysql://127.0.0.1:3306/数据库名?serverTimezone=UTC
mysql.userName = mysql用户名
mysql.password = mysql用户密码

配置spring配置文件

<?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:context="http://www.springframework.org/schema/context"
       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.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/data/jpa https://www.springframework.org/schema/data/jpa/spring-jpa.xsd">
    <!--注解扫描-->
    <context:component-scan base-package="项目路径"/>
    <!--引入配置文件-->
    <context:property-placeholder location="classpath:jdbc配置文件.property"/>
    <!--配置datasource-->
    <bean name="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="url" value="${mysql.url}"/>
        <property name="driverClassName" value="${mysql.driverClass}"/>
        <property name="username" value="${mysql.userName}"/>
        <property name="password" value="${mysql.password}"/>
    </bean>
    <!--spring与spring data的配置-->
    <!--配置entityManageFactory对象交给spring容器管理  指定实体类所在的包名称-->
    <bean id="entityManager" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <!--配置包的扫描实体类所在的包-->
        <property name="packagesToScan" value="实体类路径"/>
        <!--jpa的实现厂家-->
        <property name="persistenceProvider">
            <bean class="org.hibernate.jpa.HibernatePersistenceProvider"/>
        </property>
        <!--配置操作数据库的适配器-->
        <property name="jpaVendorAdapter">
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
                <!--配置是否自定创建数据表-->
                <property name="generateDdl" value="true"/>
                <!--指定数据库类型-->
                <property name="database" value="MYSQL"/>
                <!--指定数据库方言-->
                <property name="databasePlatform" value="org.hibernate.dialect.MySQL5Dialect"/>
                <!--是否现实SQL语句-->
                <property name="showSql" value="true"/>
            </bean>
        </property>
        <!--配置方言的高级特性-->
        <property name="jpaDialect">
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect"/>
        </property>
    </bean>
    <!--spring与spring data jpa的整和配置-->
    <jpa:repositories base-package="持久层(dao)路径" transaction-manager-ref="transactionManager" entity-manager-factory-ref="entityManager"/>

    <!--配置事物管理器-->
    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManager"/>
    </bean>

</beans>

web.xml中配置监听

<web-app>
	<display-name>Archetype Created Web Application</display-name>
	<!--初始化spring容器，value值是spring配置文件-->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath*:applicationContext.xml</param-value>
	</context-param>
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
</web-app>

创建实体类

依赖lombok的注解

@Data
@NoArgsConstructor
@AllArgsConstructor

剩下的其他注解都是依赖hibernate的

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import javax.persistence.*;
import java.util.Date;
@Data
@NoArgsConstructor
@AllArgsConstructor
@Entity//代表当前class是实体类
@Table(name ="rd_book")//映射的数据库表
public class Book {
    /**
     *GenerationType.SEQUENCE:序列 oracle数据库
     *GenerationType.IDENTITY:自增
     *GenerationType.TAB:主键生成策略
     *GenerationType.AUTO:程序自动帮助我们选择主键生成策略
     */
    @Id//主键
    @GeneratedValue(strategy = GenerationType.SEQUENCE)//设置主键生成策略
//    @Column(name = "id")//映射数据库表中的字段
    private Integer id;
    private String name;
    private String author;
    private String address;
    private double price;
    @Column(name = "create_time")
    private Date createTime;
}

实现Dao层

jparepository继承了PagingAndSortingRepository继承了CrudRepository所以我们只需要继承JpaRepository就可以了，第一个参数传我们实体类，第二个参数传我们的ID数据类型

import com.spring.pojo.Book;
import org.springframework.data.jpa.repository.JpaRepository;

public interface BookDao extends JpaRepository<Book,Integer> {

}

测试

import com.spring.dao.BookDao;
import com.spring.pojo.Book;
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.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import javax.transaction.Transactional;
import java.util.Date;
import java.util.List;


@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class DataJpa {
    @Autowired
    private BookDao bookDao;

    /**
     * 插入数据
     */
    @Test
    public void saveTest(){
        for (int i = 1;i<20;i++){
            Book book = new Book();
            book.setAddress("北京大学"+i);
            book.setAuthor("王小二");
            book.setPrice(23.0);
            book.setName("神鬼七杀令");
            book.setCreateTime(new Date());
            bookDao.save(book);
        }
    }

    /**
     * 获取单个数据
     */
    @Test
    @Transactional
    public void getOne(){
        Book book = bookDao.getOne(1);
        System.out.println(book);
    }

    /**
     * 删除单个数据
     */
    @Test
    public void getDeleteTest(){
        bookDao.deleteById(19);
    }

    /**
     * 分页
     */
    @Test
    public void getPageTest(){
        /**
         * 参数一：第几页
         * 参数二：每页显示几条记录
         * 参数三：排序规则
         *
         * 分页下标数时从0开始，总记录数是从1开始
         */
        Pageable pageable = PageRequest.of(3,5, Sort.by(Sort.Direction.DESC,"id"));
        Page<Book> page =  bookDao.findAll(pageable);
        List<Book> bookList = page.getContent();
        System.out.println("总记录数："+page.getTotalElements());
        System.out.println("总页数："+page.getTotalPages());
        System.out.println("当前第几页："+page.getNumber());
        System.out.println("当前显示的记录数："+page.getNumberOfElements());
        for(Book book:bookList){
            System.out.println(book);
        }
    }
}