sss整合(spring+springMVC+spring Data Jpa)

最新推荐文章于 2022-04-14 01:40:19 发布

ReLive27

最新推荐文章于 2022-04-14 01:40:19 发布

阅读量685

点赞数

分类专栏： Spring Boot 文章标签： java spring hibernate jpa

本文链接：https://blog.csdn.net/new_ord/article/details/106230876

版权

Spring Boot 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

导入jar包

<?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>com.relive</groupId>
  <artifactId>sssp</artifactId>

  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>sssp 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.7</maven.compiler.source>
    <spring.version>5.1.8.RELEASE</spring.version>
    <spring-data-jpa.version>2.1.9.RELEASE</spring-data-jpa.version>
    <hibernate.version>5.0.11.Final</hibernate.version>
    <slf4j.version>1.7.2</slf4j.version>
    <log4j.version>2.11.2</log4j.version>
    <mysql.version>8.0.11</mysql.version>
    <oracle.version>11.2.0</oracle.version>
  </properties>

  <dependencies>
    <!--spring IOC核心包-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context-support</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <!--spring AOP切面-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aspects</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <!--spring 事务-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>${spring.version}</version>
    </dependency>

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

    <!--spring data jpa-->
    <dependency>
      <groupId>org.springframework.data</groupId>
      <artifactId>spring-data-jpa</artifactId>
      <version>${spring-data-jpa.version}</version>
    </dependency>

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

   <!--hibernate 相关包-->
    <dependency>
      <groupId>org.hibernate</groupId>
      <artifactId>hibernate-core</artifactId>
      <version>${hibernate.version}</version>
    </dependency>
    <dependency>
      <groupId>org.hibernate</groupId>
      <artifactId>hibernate-entitymanager</artifactId>
      <version>${hibernate.version}</version>
    </dependency>

    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-nop</artifactId>
      <version>${slf4j.version}</version>
    </dependency>
    <dependency>
      <groupId>org.apache.logging.log4j</groupId>
      <artifactId>log4j-core</artifactId>
      <version>${log4j.version}</version>
    </dependency>

    <dependency>
      <groupId>org.apache.logging.log4j</groupId>
      <artifactId>log4j-api</artifactId>
      <version>${log4j.version}</version>
    </dependency>

    <!--mysql 数据库驱动-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>${mysql.version}</version>
    </dependency>

    <!--oracle 数据库驱动-->
    <dependency>
      <groupId>com.oracle</groupId>
      <artifactId>ojdbc6</artifactId>
      <version>${oracle.version}</version>
    </dependency>

    <!--druid 连接池-->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.10</version>
    </dependency>

    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>

     <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>servlet-api</artifactId>
      <version>3.0-alpha-1</version>
      <!--不参与打包，不参与部署-->
      <scope>provided</scope>
    </dependency>

    <dependency>
      <groupId>javax.servlet.jsp</groupId>
      <artifactId>javax.servlet.jsp-api</artifactId>
      <version>2.3.3</version>
      <scope>provided</scope>
    </dependency>


    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>test</scope>
    </dependency>

  </dependencies>

</project>

jdbc.properties

#mysql
jdbc.driverClassName=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=CONVERT_TO_NULL
jdbc.username=root
jdbc.password=123456

#Oracle
#jdbc.driver=oracle.jdbc.driver.OracleDriver
#jdbc.url=jdbc:oracle:thin:@192.168.1.14:1521:orcl
#jdbc.username=re_live
#jdbc.password=123
#jdbc.minIdle=10
#jdbc.maxTotal=20

applicationContext.xml

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:tx="http://www.springframework.org/schema/tx"
       xmlns:jpa="http://www.springframework.org/schema/data/jpa" xmlns:cache="http://www.alibaba.com/schema/stat"
       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/tx
       http://www.springframework.org/schema/tx/spring-tx.xsd
       http://www.springframework.org/schema/data/jpa
       http://www.springframework.org/schema/data/jpa/spring-jpa.xsd http://www.alibaba.com/schema/stat http://www.alibaba.com/schema/stat.xsd">

    <!--配置自动扫描的包-->
    <context:component-scan base-package="com.sss">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
        <context:exclude-filter type="annotation"
                                expression="org.springframework.web.bind.annotation.ControllerAdvice"/>
    </context:component-scan>
    
    <!--读取properties 文件-->
    <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
    
    <!--配置数据源-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${jdbc.driverClassName}"></property>
        <property name="url" value="${jdbc.url}"></property>
        <property name="username" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>
    
    <!--配置JPA 的entityManager-->
    <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <!--注入数据源-->
        <property name="dataSource" ref="dataSource"></property>
        <!--配置实现的厂商-->
        <property name="jpaVendorAdapter">
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"></bean>
        </property>
        <!--配置扫描的实体类-->
        <property name="packagesToScan" value="com.sss.entity"></property>
        <!--配置jpa的可选属性-->
        <property name="jpaProperties">
            <props>
                <!--生成数据表的列的映射策略-->
                <prop key="hibernate.ejb.naming_strategy">org.hibernate.cfg.ImprovedNamingStrategy</prop>
                <!--生成Sql方言-->
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
                <!--输出sql-->
                <prop key="hibernate.show_sql">true</prop>
                <!--格式化sql-->
                <prop key="hibernate.format_sql">true</prop>
                <!--自动建表-->
                <prop key="hibernate.hbm2ddl.auto">update</prop>

                <!--二级缓存可以参考以下设置-->
             	<--  <prop key="cache.use_second_level_cache">true</prop>
               <prop key="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.EhCacheRegionFactory</prop>
               <prop key="cache.use_query_cache">true</prop>-->
            </props>
        </property>
     <!--配置二级缓存策略-->
	 <!--<property name="sharedCacheMode" value="ENABLE_SELECTIVE"></property>-->
    </bean>
 
    <!--配置事务管理器-->
    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory"></property>
    </bean>

    <!--开启注解事务-->
    <tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>

    <!--配置spring data-->
    <jpa:repositories base-package="com.sss.dao" entity-manager-factory-ref="entityManagerFactory"></jpa:repositories>
</beans>

spring-mvc.xml

<?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:mvc="http://www.springframework.org/schema/mvc"
       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/mvc
       https://www.springframework.org/schema/mvc/spring-mvc.xsd">

    <!--配置自动扫描的包-->
    <context:component-scan base-package="com.sss.controller"></context:component-scan>

    <!--配置视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/pages/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>

    <!--处理静态资源-->
    <mvc:default-servlet-handler></mvc:default-servlet-handler>
    <mvc:annotation-driven></mvc:annotation-driven>
</beans>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
          http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
         id="WebApp_ID" version="3.1">

    <display-name>Archetype Created Web Application</display-name>

    <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>
    <listener>
        <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
    </listener>

    <!--字符编码过滤器-->
    <filter>
        <filter-name>characterEncodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
        <init-param>
            <param-name>forceEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>characterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <!--hiddenHttpMethodFilter 过滤器-->
    <filter>
        <filter-name>hiddenHttpMethodFilter</filter-name>
        <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>hiddenHttpMethodFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
    
    <servlet>
        <servlet-name>dispatcherServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring-mvc.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>dispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
</web-app>

实体类

员工类和员工类双向多对一映射关系（也可以单向多对一，那么部门类就不用加@OneToMany）

员工类

/**
  *注：
  *@GeneratedValue：主键映射策略
  *@Temporal：调整时间精度
  *@DateTimeFormat：时间类型格式化
  */
package com.sss.entity;

import org.hibernate.annotations.GenericGenerator;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.*;
import java.util.Date;

@Entity
@Table(name = "db_employee")
public class Employee {
    private String id;
    private String name;
    private String email;
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    private Date birth;
    private Date createTime;
    private Department department;

    @Id
    @GeneratedValue(generator = "paramId")
    @GenericGenerator(name = "paramId",strategy = "uuid")
    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    @Temporal(TemporalType.DATE)
    public Date getBirth() {
        return birth;
    }

    public void setBirth(Date birth) {
        this.birth = birth;
    }

    @Temporal(TemporalType.TIMESTAMP)
    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    @JoinColumn(name = "DEPARTMENT_ID")
    @ManyToOne
    public Department getDepartment() {
        return department;
    }

    public void setDepartment(Department department) {
        this.department = department;
    }

    @Override
    public String toString() {
        return "Employee{" +
                "id='" + id + '\'' +
                ", name='" + name + '\'' +
                ", email='" + email + '\'' +
                ", birth=" + birth +
                ", createTime=" + createTime +
                ", department=" + department +
                '}';
    }
}

部门类

package com.sss.entity;

import org.hibernate.annotations.GenericGenerator;
import javax.persistence.*;
import java.util.List;

@Entity
@Table(name = "db_department")
public class Department {
    private String id;
    private String departmentName;
    private List<Employee> employee;

    @GeneratedValue(generator = "paramId")
    @GenericGenerator(name = "paramId",strategy = "uuid")
    @Id
    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }


    public String getDepartmentName() {
        return departmentName;
    }

    public void setDepartmentName(String departmentName) {
        this.departmentName = departmentName;
    }

    //mappedBy：对应员工类中部门属性
    @OneToMany(mappedBy = "department")
    public List<Employee> getEmployee() {
        return employee;
    }

    public void setEmployee(List<Employee> employee) {
        this.employee = employee;
    }

    @Override
    public String toString() {
        return "Department{" +
                "id='" + id + '\'' +
                ", departmentName='" + departmentName + '\'' +
                '}';
    }
}

dao层

EmployeeDao

package com.sss.dao;

import com.sss.entity.Employee;
import org.springframework.data.jpa.repository.JpaRepository;

public interface EmployeeDao extends JpaRepository<Employee,String> {

	/**
	  *1.查询方法以 find | read | get 开头
	  *2.涉及条件查询时，条件属性用条件关键字连接
	  *3.条件属性以首字母大写
	  *4.支持属性的级联查询，若当前类有符合条件的属性，则优先使用，
	  *  而不使用级联属性，若需要使用级联属性，则属性之间使用_连接
	  * /
	  
    Employee findByName(String name);
}

DepartmentDao

package com.sss.dao;

import com.relive.sss.Department;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import java.util.List;

public interface DepartmentDao extends JpaRepository<Department,String> {
	
	/**
	  *使用@Query可以自定义jpql
	  */
    @Query("from Department d")
    List<Department> getAll();
}

service层

以下service层接口就不粘了，可以根据实现类参考

package com.sss.service.impl;

import com.sss.dao.EmployeeDao;
import com.sss.entity.Employee;
import com.sss.service.EmployeeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Sort;
import org.springframework.stereotype.Service;

import java.util.Date;
import java.util.List;
import java.util.Optional;

@Service
public class EmployeeServiceImpl implements EmployeeService {
    //注入数据层
    @Autowired
    private EmployeeDao dao;
	
	//分页
    @Override
    public Page<Employee> page(Integer pageNo,Integer pageSize) {
    	//按创建时间降序排列
        Sort sort=new Sort(Sort.Direction.DESC,"createTime");
        PageRequest pageRequest=PageRequest.of(pageNo-1,pageSize,sort);
        Page<Employee> page = dao.findAll(pageRequest);
        return page;
    }

	//根据名称查询员工
    @Override
    public Employee findByName(String name) {
        return dao.findByName(name);
    }

	//保存操作
    @Override
    public void save(Employee employee) {
        if(employee.getId()==null) {
            employee.setCreateTime(new Date());
        }
        dao.saveAndFlush(employee);
    }

	//根据ID查询员工
    @Override
    public Employee findById(String id) {
        Optional<Employee> byId = dao.findById(id);
        Employee employee = byId.get();
        return employee;
    }

	//删除操作
    public void delete(String id){
        dao.deleteById(id);
    }

}

package com.sss.service.impl;

import com.sss.dao.DepartmentDao;
import com.sss.entity.Department;
import com.sss.service.DepartmentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class DepartmentServiceImpl implements DepartmentService {

    @Autowired
    private DepartmentDao dao;

	//获取所有部门
    @Override
    public List<Department> findAllDep() {
        List<Department> departments = dao.getAll();
        return departments;
    }
}

Controller层

package com.sss.controller;

import com.sss.entity.Department;
import com.sss.entity.Employee;
import com.sss.service.DepartmentService;
import com.sss.service.EmployeeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;

import java.util.List;
import java.util.Map;

@Controller
public class EmployeeController {
    //注入逻辑层
    @Autowired
    private EmployeeService service;
    @Autowired
    private DepartmentService departmentService;

    //分页
    @RequestMapping(value = "page",method = RequestMethod.GET)
    public String page(@RequestParam(value = "pageNo",
            required = false,defaultValue = "1")String pageNo, Map<String,Object> map){
        Integer pageNum=1;
        try {
            pageNum = Integer.parseInt(pageNo);
            if(pageNum<1){
                pageNum=1;
            }
        }catch (Exception e){}

        Page<Employee> page = service.page(pageNum,1);

        map.put("page",page);
        return "list";
    }

    //获取部门信息，显示添加页面
    @RequestMapping(value = "emps",method = RequestMethod.GET)
    public String add(Map<String,Object> map){
        List<Department> departments = departmentService.findAllDep();
        map.put("departments",departments);
        map.put("employee",new Employee());
        return "add";
    }

	/**
	  *以下保存信息，修改信息，删除信息，信息回显使用的是Rest风格的url。
	  *1.首先要在web.xml中配置HiddenHttpMethodFilter
	  *2.需要发送psot请求时携带一个name="_method"的隐藏域，值为DELETE或PUT
	  *3.在springmvc中的目标方法使用@PathVariable获取url中的值
	  *4.目标方法的请求方式要相对应
	  */
    //保存信息
    @RequestMapping(value = "emp",method = RequestMethod.POST)
    public String save(Employee employee){
        service.save(employee);
        return "redirect:page";
    }

	/**
	  *由@ModelAttribute标记的方法,会在每个目标方法执行之前被springmvc调用
	  *作用：
	  *   开发中前端页面有可能不会将数据库各个字段都显示，所以在这种情况更新数据时，
	  *前端页面传入后台的数据中，没有显示的字段就会为空值，在进行更新操作时，
	  *就会覆盖数据库中原有的值，此时数据库中的字段就会是空值，显然不符合要求。
	  *
	  *运行过程
	  *1.@ModelAttribute标记的方法会先从数据库中将对象取出来，把对象放入到Map中，建为”employee“
	  *2.springmvc会从Map中取出Employee对象，然后将表单的请求参数赋给对象中相应的属性。
	  *3.springmvc把上述对象传入目标方法的参数中
	  *
	  *注意：Map中的键名要和目标方法的参数类型首字母小写一致
	  */
	  
    @ModelAttribute
    public void find(@RequestParam(value = "id",required = false)String id,
                     Map<String,Object> map){
        if(id!=null) {
            Employee employee = service.findById(id);
            employee.setDepartment(null);
            map.put("employee", employee);
        }
    }
    //修改信息
    @RequestMapping(value = "emp",method = RequestMethod.PUT)
    public String update(Employee employee){
        service.save(employee);
        return "redirect:page";
    }

    //删除信息
    @ResponseBody
    @RequestMapping(value = "emp/{id}",method = RequestMethod.DELETE)
    public String del(@PathVariable("id")String id){
        try {
            service.delete(id);
            return "1";
        }catch (Exception e){}
        return "0";
    }

	//信息回显
    @RequestMapping(value = "emp/{id}",method = RequestMethod.GET)
    public ModelAndView get(@PathVariable(value = "id") String id) {
        Employee employee = service.findById(id);
        List<Department> departments = departmentService.findAllDep();
        ModelAndView modelAndView=new ModelAndView("add");
        modelAndView.addObject("employee",employee);
        modelAndView.addObject("departments",departments);
        return modelAndView;
    }
    
    //验证
    @ResponseBody
    @RequestMapping(value = "validationName",method = RequestMethod.POST)
    public String validationName(@RequestParam(value = "name",required = true)String name){
        Employee employee = service.findByName(name);
        if(employee==null){
            return "0";
        }else{
            return "1";
        }
    }
}

jsp页面

header.jsp
提供一些公共的设置

%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
   String basePath=request.getScheme()+"://"+request.getServerName()+":"+
   request.getServerPort()+"/"+request.getContextPath()+"/";
   pageContext.setAttribute("basePath",basePath);
%>
<base href="${basePath}">
<script type="text/javascript" src="${basePath}static/js/jquery-3.4.1.min.j

index.jsp

%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>首页</title>
    <%@include file="pages/common/header.jsp"%>
</head>
<body>
<a href="page">展示数据</a>
<a href="emps">添加数据</a>
</body>
</html>

list.jsp

%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<html>
<head>
    <title>Title</title>
    <%@include file="common/header.jsp"%>
    <script>
        $(function () {
           $(".delete").click(function () {
               var b = confirm("确定要删除["+$(this).parent().parent().find("td:first").text()+"]吗？");
               var url=$(this).attr("href");
               if(b){
                   $.post(url,{_method:"DELETE"},function (data) {
                       if(data=="1"){
                           alert("删除成功！");
                           window.location.reload();
                       }else {
                           alert("删除失败！")
                       }
                   });
               }
               return false;
           });
        });
    </script>
</head>
<body>
<c:if test="${page.getContent()==null||page.getNumberOfElements()==0}">
    没有数据！
</c:if>
<c:if test="${page.getContent()!=null&&page.getNumberOfElements()!=0}">
    <table border="2" cellpadding="5" cellspacing="0">
        <tr>
            <th>姓名</th>
            <th>邮箱</th>
            <th>出生日期</th>
            <th>创建时间</th>
            <th>部门</th>
            <th colspan="2">操作</th>
        </tr>
        <c:forEach items="${page.getContent()}" var="employee">
            <td hidden id="id">${employee.id}</td>
            <tr>
                <td>${employee.name}</td>
                <td>${employee.email}</td>
                <td>${employee.birth}</td>
                <td><fmt:formatDate pattern="yyyy-MM-dd HH:mm:ss" value="${employee.createTime}"></fmt:formatDate></td>
                <td>${employee.department.departmentName}</td>
                <td><a href="emp/${employee.id}" >修改</a></td>
                <td><a href="emp/${employee.id}" class="delete">删除</a></td>
            </tr>
        </c:forEach>
        <tr>
            <td colspan="7">
            <c:if test="${ (page.number+1)!=1}">
                <a href="page">首页</a>
                <a href="page?pageNo=${page.number}">上一页</a>
            </c:if>
                ${ page.number+1}
            <c:if test="${ (page.number+1)<page.totalPages}">
                <a href="page?pageNo=${page.number+2}">下一页</a>
                <a href="page?pageNo=${page.totalPages}">尾页</a>
            </c:if>

            当前第${ page.number+1}页
            一共${page.totalPages}页
            一共条${ page.totalElements}记录
            </td>
        </tr>
    </table>

</c:if>
</body>
</html>

add.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="form" uri="http://www.springframework.org/tags/form" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>添加</title>
    <%@include file="common/header.jsp" %>

    <script>
        $(function () {
            $("#name").blur(function () {
                var name = $("#name").val();
                var orderName = $("#orderName").val();
                orderName = orderName.trim()
                if (orderName != null && orderName != "" && orderName == name) {
                    alert("用户名可用");
                    return;
                }
                $.post("validationName", {name: name}, function (data) {
                    if (data == "0") {
                        alert("用户名可用")
                    } else {
                        alert("用户名不可用");
                    }
                }, "json");
            });
        })
    </script>
</head>
<body>


<form:form action="emp" method="post" modelAttribute="employee">
    <c:if test="${!empty employee.id}">
        <input type="hidden" id="orderName" value="${employee.name}">
        <input type="hidden" name="_method" value="PUT">
        <form:hidden path="id"></form:hidden>
    </c:if>
    姓名：<form:input path="name" id="name"></form:input><br>
    邮箱：<form:input path="email"></form:input><br>
    出生日期：<form:input path="birth"></form:input><br>
    部门：<form:select path="department.id" items="${departments}" itemValue="id"
                    itemLabel="departmentName"></form:select><br>
    <input type="submit" value="提交">
</form:form>
</body>
</html>

希望上述内容帮助到你！