Spring Boot结和Spring Data（Ehcache缓存，Thymeleaf页面，自定义异常页面跳转，Swagger2）

最新推荐文章于 2022-10-19 11:32:51 发布

有园人

最新推荐文章于 2022-10-19 11:32:51 发布

阅读量210

点赞数

分类专栏： JavaEE 文章标签： Spring Boot结和Spring Data（Ehcac

本文链接：https://blog.csdn.net/qq_42031653/article/details/103232432

版权

JavaEE 专栏收录该内容

90 篇文章 2 订阅

订阅专栏

项目结构

pom文件

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.9.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.bjsxt</groupId>
    <artifactId>spring-bootdata-hotel</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>spring-bootdata-hotel</name>
    <description>spring-bootdata-hotel</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger2</artifactId>
            <version>2.9.2</version>
        </dependency>
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger-ui</artifactId>
            <version>2.9.2</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!-- Spring Boot 缓存支持启动器 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-cache</artifactId>
        </dependency>
        <!-- Ehcache 坐标 -->
        <dependency>
            <groupId>net.sf.ehcache</groupId>
            <artifactId>ehcache</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

俩个配置文件

application.properties

#项目端口配置
server.port=8080
server.address=0.0.0.0
#Mysql数据源配置
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/sys?characterEncoding=UTF8&useSSL=false
spring.datasource.username=root
spring.datasource.password=root

#JPA相关配置
#项目启动生成数据库
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true
#josn数据格式
spring.jackson.serialization.indent-output=true


#对于ehcache缓存进行相关配置
spring.cache.ehcache.config=classpath:ehcache.xml

ehcache.xml

<ehcache xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../config/ehcache.xsd">
    <diskStore path="java.io.tmpdir"/> <!--defaultCache:echcache 的默认缓存策略 -->
    <defaultCache maxElementsInMemory="10000"
                  eternal="false"
                  timeToIdleSeconds="120"
                  timeToLiveSeconds="120"
                  maxElementsOnDisk="10000000"
                  diskExpiryThreadIntervalSeconds="120"
                  memoryStoreEvictionPolicy="LRU">
        <persistence strategy="localTempSwap"/>
    </defaultCache> <!-- 自定义缓存策略 -->
    <cache name="room"
           maxElementsInMemory="10000"
           eternal="false"
           timeToIdleSeconds="120"
           timeToLiveSeconds="120"
           maxElementsOnDisk="10000000"
           diskExpiryThreadIntervalSeconds="120"
           memoryStoreEvictionPolicy="LRU">
        <persistence strategy="localTempSwap"/>
    </cache>
</ehcache>

三个页面，一个异常处理页面，一个添加页面，一个主页面（所有的查询操作，以及删除操作）

templates/error.html

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.w3.org/1999/xhtml">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<h1>页面崩溃了呢，主人~~~</h1>
<br/>
<h1>主人，页面异常是因为</h1>
<span th:text="${error}"></span>
</body>
</html>

templates/addhotel.html

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.w3.org/1999/xhtml">
<head>
    <meta charset="UTF-8">
    <title>添加房间</title>
</head>
<body>
<h1 align="center">添加房间</h1>
<hr/>
<form method="post" th:action="@{/addroom}" >
    <p>
        房型:<select name="type" >
        <option value="1" selected="selected">标准间</option>
        <option value="2">双人间</option>
        <option value="3">豪华间</option>
        <option value="4">总统间</option>
        <option value="5">大床房</option>
    </select>
    </p>
    <p>
        价格:<input type="number" name="price"><font color="red" th:errors="${room.price}"></font>
    </p>
    <p>
        所属酒店:
        <select name="hotel" >
            <option value="0">=请选择=</option>
            <span th:each="h:${hotel}">
                <option th:value="${h.hid}"><span th:text="${h.hname}"></span></option>
            </span>
        </select>
    </p>
    <p>描述:</p>
    <textarea name="info" style="height: 60px"></textarea>
    <p>
        <input type="submit" value="发布">
    </p>
</form>
</body>
</html>

templates/index.html

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.w3.org/1999/xhtml">
<head>
    <meta charset="UTF-8">
    <title>主页面</title>
</head>
<body>
<h1 align="center">酒店管理系统</h1>
<hr/>
<form th:action="@{/findlike}" method="post">
    按照酒店名称:<input type="text" name="hname">&nbsp;
    <input type="submit" value="查询">
</form>

<hr/>
<a th:href="@{/hotel}">添加宾馆</a>
<h1>房型：</h1>
<h1>1:标准间 2:双人间 3:豪华间</h1>
<h1>4:总统间 5:大床房</h1>
<hr/>
<table border="1" align="center" width="50%">
    <tr>
        <th>ID</th>
        <th>酒店名称</th>
        <th>房型</th>
        <th>价格</th>
        <th>地址</th>
        <th>电话</th>
        <th>操作</th>
    </tr>
    <tr th:each="room:${room}">
        <th th:text="${room.id}"></th>
        <th th:text="${room.hotel.hname}">
        <th th:text="${room.type}"></th>
        <th th:text="${room.price}"></th>
        <th th:text="${room.hotel.address}"></th>
        <th th:text="${room.hotel.mobile}"></th>
        <th><a th:href="@{/deleteById(id=${room.id})}">删除</a></th>
    </tr>
</table>
</body>
</html>

业务代码

处理异常

package com.bjsxt.exception;

import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.HandlerExceptionResolver;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@Configuration
public class GolableException implements HandlerExceptionResolver {
    @Override
    public ModelAndView resolveException(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, Exception e) {
        ModelAndView mav=new ModelAndView();
        if (e instanceof Exception){
            mav.setViewName("error");
        }
        mav.addObject("error",e.toString());
        return mav;
    }
}

Spring Boot正向工程

俩个实体类，表是一对多的关系

com.bjsxt.pojo.Hotel

package com.bjsxt.pojo;

import lombok.Data;

import javax.persistence.*;
import java.io.Serializable;
import java.util.HashSet;
import java.util.Set;

@Entity
@Table(name = "hotel")
@Data
public class Hotel implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "hid")
    private int hid;

    @Column(name = "hname")
    private String hname;

    @Column(name = "address")
    private String address;

    @Column(name = "mobile")
    private String mobile;

    @OneToMany(mappedBy = "hotel",cascade = CascadeType.PERSIST)
    private Set<Room> room=new HashSet<>();

    public Hotel() {
    }

    public Hotel(String hname, String address, String mobile, Set<Room> room) {
        this.hname = hname;
        this.address = address;
        this.mobile = mobile;
        this.room = room;
    }
}

com.bjsxt.pojo.Room

package com.bjsxt.pojo;

import lombok.Data;

import javax.persistence.*;
import javax.validation.constraints.NotBlank;
import javax.validation.constraints.NotNull;
import java.io.Serializable;

@Entity
@Table(name = "room")
@Data
public class Room implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id")
    private int id;

    @Column(name = "type")
    private int type;

    @Column(name = "price")
    @NotNull
    private double price;

    @Column(name = "info")
    private String  info;

    @ManyToOne(cascade = CascadeType.PERSIST)
    @JoinColumn(name = "hid")
    private Hotel hotel;

    public Room() {
    }

    public Room(int type, double price, String info, Hotel hotel) {
        this.type = type;
        this.price = price;
        this.info = info;
        this.hotel = hotel;
    }
}

dao层

com.bjsxt.dao.HotelDao

package com.bjsxt.dao;

import com.bjsxt.pojo.Hotel;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;

public interface HotelDao extends JpaRepository<Hotel,Integer> , JpaSpecificationExecutor<Hotel> {
}

com.bjsxt.dao.RoomDao

package com.bjsxt.dao;

import com.bjsxt.pojo.Room;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface RoomDao extends JpaRepository<Room,Integer>, JpaSpecificationExecutor<Room> {

    @Query(value = "select h.*,r.*  from hotel h,room r where h.hid=r.hid and h.hname like ?",nativeQuery = true)
    List<Room> findLikeByhname(String hname);

}

service层（接口）

com.bjsxt.service.impl.HotelService

package com.bjsxt.service;

import com.bjsxt.pojo.Hotel;

import java.util.List;

public interface HotelService {
    /**
     * 查询所有的宾馆信息
     * @return
     */
    List<Hotel> findall();
}

com.bjsxt.service.RoomService

package com.bjsxt.service;

import com.bjsxt.pojo.Hotel;
import com.bjsxt.pojo.Room;
import org.springframework.data.domain.Page;

import java.util.List;

public interface RoomService {

    /**
     * 添加房间
     * @param room
     */
    void addRoom(Room room);

    /**
     * 查询所有房间

     * @return
     */
    public List<Room> findAll();

    /**
     * 模糊查询
     * @param hname
     * @return
     */
    public List<Room> findLike(String hname);


    /**
     * 指定id删除
     * @param id
     */
    void deleteid(int id);
}

实现类

com.bjsxt.service.impl.HotelServiceImpl

package com.bjsxt.service.impl;

import com.bjsxt.dao.HotelDao;
import com.bjsxt.pojo.Hotel;
import com.bjsxt.service.HotelService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class HotelServiceImpl implements HotelService {

    @Autowired
    private HotelDao hotelDao;

    @Override
    public List<Hotel> findall() {
        List<Hotel> hotels = hotelDao.findAll();
        return hotels;
    }
}

com.bjsxt.service.impl.RoomServiceImpl

package com.bjsxt.service.impl;

import com.bjsxt.dao.HotelDao;
import com.bjsxt.dao.RoomDao;
import com.bjsxt.pojo.Hotel;
import com.bjsxt.pojo.Room;
import com.bjsxt.service.RoomService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.cache.annotation.CacheEvict;
import org.springframework.cache.annotation.Cacheable;
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.jpa.domain.Specification;
import org.springframework.stereotype.Service;

import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Predicate;
import javax.persistence.criteria.Root;
import java.util.List;

/**
 * 处理放假的操作
 */
@Service
public class RoomServiceImpl implements RoomService {
    @Autowired
    private RoomDao roomDao;


    /**
     * 添加房间
     * @param room
     */
    @CacheEvict(value = "room",allEntries = true)//清空缓存
    @Override
    public void addRoom(Room room) {
        roomDao.save(room);
    }

    /**
     * 查询所有房间
     * @return
     */
    @Cacheable(value = "room")//配置缓存
    @Override
    public List<Room> findAll() {
        List<Room> roomList = roomDao.findAll();
        return roomList;
    }

    @Override
    public List<Room> findLike(String hname) {
        List<Room> roomList = roomDao.findLikeByhname(hname);
        return roomList;
    }

    @Override
    @CacheEvict(value = "room",allEntries = true)//清空缓存
    public void deleteid(int id) {
        roomDao.deleteById(id);
    }
}

控制层

com.bjsxt.controller.HotelController

package com.bjsxt.controller;

import com.bjsxt.pojo.Hotel;
import com.bjsxt.pojo.Room;
import com.bjsxt.service.HotelService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import java.util.List;

@Controller
public class HotelController {

    /**
     * 跳转页面
     */
    @RequestMapping("/go")
    private String goIndex(){
        return "index";
    }

    @Autowired
    private HotelService hs;

    /**
     * 查询所有的酒店
     */
    @RequestMapping("/hotel")
    private String findAll(Model model,Room room){
        List<Hotel> hotel = hs.findall();
        model.addAttribute("hotel",hotel);
        return "addhotel";
    }


}

com.bjsxt.controller.RoomController

package com.bjsxt.controller;

import com.bjsxt.pojo.Hotel;
import com.bjsxt.pojo.Room;
import com.bjsxt.service.RoomService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.BindingResult;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import javax.validation.Valid;
import java.util.List;

@Controller
public class RoomController {

    @Autowired
    private RoomService rs;

    /**
     * 新增
     * @param room
     * @return
     */
    @RequestMapping("/addroom")
    private String addRoom(@Valid Room room, BindingResult result){
        if(result.hasErrors()){
            return "addhotel";
        }else {
            rs.addRoom(room);
            return "redirect:/findall";
        }
    }

    /**
     * 查询所有
     * @param model
     * @return
     */
    @RequestMapping("/findall")
    public String findAll(Model model){
        List<Room> rooms = rs.findAll();
        model.addAttribute("room",rooms);
        return "index";
    }


    /**
     * 模糊查询
     * @param hname

     * @param model
     * @return
     */
    @RequestMapping("/findlike")
    public String findLike(String hname,Model model){
        List<Room> rooms ;
        if (hname==""){
             rooms = rs.findAll();
        }else {
            hname="%"+hname+"%";
            rooms = rs.findLike(hname);
        }
        model.addAttribute("room",rooms);
        return "index";
    }

    @RequestMapping("/deleteById")
    public String deleteById(int id){
        rs.deleteid(id);
        return "redirect:/findall";
    }

}

启动类

com.bjsxt.SpringBootdataHotelApplication

package com.bjsxt;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.cache.annotation.EnableCaching;
import springfox.documentation.swagger2.annotations.EnableSwagger2;

@SpringBootApplication
@EnableCaching
@EnableSwagger2
public class SpringBootdataHotelApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringBootdataHotelApplication.class, args);
    }

}