目录
Repository层-实现接口的代码-基于JDBCTemplate
比较结论
JPA的Repository层基本不需要写代码,spring会帮你自动生成CRUD的代码;
JDBCTemplate的Repository层需要自己写接口,并且还要写具体实现类来实现Repository层的接口;
以上没有优劣,都是工具,存在即真理,根据项目场景和需求,选用合适的工具即可。
关于思维,顺带引用一句【查理.芒格】在《穷查理宝典》的话
手拿铁锤的人,看什么都像钉子
也有人说来自【马克.吐温】
To a man with a hammer, everything looks like a nail.
谨记:避开落入工具人和铁锤思维的陷阱。
二者依赖项不同,其他不同点见下图
JDBC部分关键代码
jdbc的关键依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
H2 Database的依赖
<!-- https://mvnrepository.com/artifact/com.h2database/h2 -->
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>2.1.214</version>
<scope>runtime</scope>
</dependency>
完整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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.wdh</groupId>
<artifactId>taco-cloud</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>taco-cloud</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<spring-boot.version>2.3.7.RELEASE</spring-boot.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-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.24</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-validation</artifactId>
<!-- <version>2.3.7.RELEASE</version> 根据自己的版本引入-->
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-jdbc -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!-- https://mvnrepository.com/artifact/com.h2database/h2 -->
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>2.1.214</version>
<scope>runtime</scope>
</dependency>
</dependencies>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-dependencies</artifactId>
<version>${spring-boot.version}</version>
<type>pom</type>
<scope>import</scope>
</dependency>
</dependencies>
</dependencyManagement>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.1</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<version>2.3.7.RELEASE</version>
<configuration>
<mainClass>com.wdh.tacocloud.TacoCloudApplication</mainClass>
</configuration>
<executions>
<execution>
<id>repackage</id>
<goals>
<goal>repackage</goal>
</goals>
</execution>
</executions>
</plugin>
</plugins>
</build>
</project>
Repository层的接口代码
package com.wdh.tacocloud.data;
import com.wdh.tacocloud.model.Ingredient;
/**
* @author WangDH
* @create 2022-08-25 14:43
*
* Ingredient实体的数据访问接口
*/
public interface IngredientRepository {
Iterable<Ingredient> findAll();
Ingredient findById(String id);
Ingredient save(Ingredient ingredient);
}
package com.wdh.tacocloud.data;
import com.wdh.tacocloud.model.Order;
/**
* @author WangDH
* @create 2022-08-25 17:20
*/
public interface OrderRepository {
Order save(Order order);
}
package com.wdh.tacocloud.data;
import com.wdh.tacocloud.model.Taco;
/**
* @author WangDH
* @create 2022-08-25 17:18
*/
public interface TacoRepository {
Taco save(Taco design);
}
Repository层-实现接口的代码-基于JDBCTemplate
package com.wdh.tacocloud.data.impl;
import com.wdh.tacocloud.data.IngredientRepository;
import com.wdh.tacocloud.model.Ingredient;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* @author WangDH
* @create 2022-08-25 14:42
*/
@Repository
public class JdbcIngredientRepository implements IngredientRepository {
private JdbcTemplate jdbc;
@Autowired
public JdbcIngredientRepository(JdbcTemplate jdbc) {
this.jdbc = jdbc;
}
@Override
public Iterable<Ingredient> findAll() {
return jdbc.query("select id,name,type from Ingredient",
this::mapRowToIngredient);
}
@Override
public Ingredient findById(String id) {
return jdbc.queryForObject("select id,name,type from Ingredient where id=?",
this::mapRowToIngredient,id);
}
@Override
public Ingredient save(Ingredient ingredient) {
int rowsAffect= jdbc.update("insert into Ingredient(id,name,type) values(?,?,?)",
ingredient.getId(),
ingredient.getName(),
ingredient.getType().toString()
);
return ingredient;
}
private Ingredient mapRowToIngredient(ResultSet rs,int rowNum)
throws SQLException {
return new Ingredient(
rs.getString("id"),
rs.getString("name"),
Ingredient.Type.valueOf(rs.getString("type"))
);
}
}
package com.wdh.tacocloud.data.impl;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.wdh.tacocloud.data.OrderRepository;
import com.wdh.tacocloud.model.Order;
import com.wdh.tacocloud.model.Taco;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.simple.SimpleJdbcInsert;
import org.springframework.stereotype.Repository;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
* @author WangDH
* @create 2022-08-26 9:56
*
* 从JdbcTemplate创建一个SimpleJdbcTemplate
*/
@Repository
public class JdbcOrderRepository implements OrderRepository {
private SimpleJdbcInsert orderInserter;
private SimpleJdbcInsert orderTacoInserter;
private ObjectMapper objectMapper;
@Autowired
public JdbcOrderRepository(JdbcTemplate jdbc) {
this.orderInserter=new SimpleJdbcInsert(jdbc)
.withTableName("Taco_Order")
.usingGeneratedKeyColumns("id");
this.orderTacoInserter=new SimpleJdbcInsert(jdbc)
.withTableName("Taco_Order_Tacos");
this.objectMapper=new ObjectMapper();
}
@Override
public Order save(Order order) {
order.setPlacedAt(new Date());
long orderId=saveOrderDetails(order);
order.setId(orderId);
List<Taco> tacos=order.getTacos();
for(Taco taco:tacos){
saveTacoToOrder(taco,orderId);
}
return order;
}
private long saveOrderDetails(Order order){
Map<String,Object> values=objectMapper.convertValue(order,Map.class);
values.put("placedAt",order.getPlacedAt());
long orderId=orderInserter.executeAndReturnKey(values).longValue();
return orderId;
}
private void saveTacoToOrder(Taco taco,long orderId){
Map<String,Object> values=new HashMap<>();
values.put("tacoOrder",orderId);
values.put("taco",taco.getId());
orderTacoInserter.execute(values);
}
}
package com.wdh.tacocloud.data.impl;
import com.wdh.tacocloud.data.TacoRepository;
import com.wdh.tacocloud.model.Ingredient;
import com.wdh.tacocloud.model.Taco;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.core.PreparedStatementCreatorFactory;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.jdbc.support.KeyHolder;
import org.springframework.stereotype.Repository;
import java.sql.*;
import java.util.Arrays;
import java.util.Date;
/**
* @author WangDH
* @create 2022-08-25 17:22
*/
@Repository
public class JdbcTacoRepository implements TacoRepository {
private JdbcTemplate jdbc;
@Autowired
public JdbcTacoRepository(JdbcTemplate jdbc) {
this.jdbc = jdbc;
}
@Override
public Taco save(Taco taco) {
long tacoId=saveTacoInfo(taco);
taco.setId(tacoId);
for(Ingredient ingredient:taco.getIngredients()){
saveIngredientToTaco(ingredient,tacoId);
}
return taco;
}
private long saveTacoInfo(Taco taco){
taco.setCreatedAt(new Date());
PreparedStatementCreatorFactory pscf=new PreparedStatementCreatorFactory(
"insert into Taco(name,createdAt) values(?,?)",
Types.VARCHAR, Types.TIMESTAMP
);
pscf.setReturnGeneratedKeys(true);
PreparedStatementCreator psc=pscf.newPreparedStatementCreator(
Arrays.asList(
taco.getName(),
new Timestamp(taco.getCreatedAt().getTime())
)
);
KeyHolder keyHolder=new GeneratedKeyHolder();
int rowsAffected=jdbc.update(psc,keyHolder);
return keyHolder.getKey().longValue();
}
private void saveIngredientToTaco(Ingredient ingredient,long tacoId){
jdbc.update(
"insert into Taco_Ingredients(taco,ingredient) "
+" values (?,?)",
tacoId,ingredient.getId()
);
}
}
原生的JDBC代码
package com.wdh.tacocloud.data.impl;
import com.wdh.tacocloud.data.IngredientRepository;
import com.wdh.tacocloud.model.Ingredient;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* @author WangDH
* @create 2022-08-25 14:28
*
* 使用原生jdbc方式访问数据库
*
*/
public class RawJdbcIngredientRepository implements IngredientRepository {
private DataSource dataSource;
public RawJdbcIngredientRepository(DataSource dataSource) {
this.dataSource = dataSource;
}
public Ingredient findOne(String id){
Connection connection=null;
PreparedStatement statement=null;
ResultSet resultSet=null;
try {
connection=dataSource.getConnection();
statement=connection.prepareStatement(
"select id,name,type from Ingredient");
statement.setString(1,id);
resultSet=statement.executeQuery();
Ingredient ingredient=null;
if(resultSet.next()){
ingredient=new Ingredient(
resultSet.getString("id"),
resultSet.getString("name"),
Ingredient.Type.valueOf(resultSet.getString("type"))
);
}
return ingredient;
}catch (SQLException e){
}finally {
if(resultSet!=null){
try{
resultSet.close();
}catch (SQLException e){
}
}
if(statement!=null){
try{
statement.close();
}catch (SQLException e){
}
}
if(connection!=null){
try{
connection.close();
}catch (SQLException e){
}
}
}
return null;
}
@Override
public Iterable<Ingredient> findAll() {
return null;
}
@Override
public Ingredient findById(String id) {
return null;
}
@Override
public Ingredient save(Ingredient ingredient) {
return null;
}
}
Model层代码
package com.wdh.tacocloud.model;
import lombok.Data;
import lombok.RequiredArgsConstructor;
/**
* @author WangDH
* @create 2022-08-24 17:18
*/
@Data
@RequiredArgsConstructor
public class Ingredient {
private final String id;
private final String name;
private final Type type;
public static enum Type{
WRAP,PROTEIN,VEGGIES,CHEESE,SAUCE
}
}
package com.wdh.tacocloud.model;
import lombok.Data;
import javax.validation.constraints.Digits;
import javax.validation.constraints.NotBlank;
import javax.validation.constraints.Pattern;
import org.hibernate.validator.constraints.CreditCardNumber;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
/**
* @author WangDH
* @create 2022-08-25 10:10
*/
@Data
public class Order {
private Long id;
private Date placedAt;
@NotBlank(message="Delivery name is required")
private String deliveryName;
@NotBlank(message="Street is required")
private String deliveryStreet;
@NotBlank(message="City is required")
private String deliveryCity;
@NotBlank(message="State is required")
private String deliveryState;
@NotBlank(message="Zip code is required")
private String deliveryZip;
@CreditCardNumber(message = "Not a valid credit card number")
private String ccNumber; //Test VISA credit card number: 4005550000000019
@Pattern(regexp = "^(0[1-9]|1[0-2])([\\/])([1-9][0-9])$",message = "Must be formatted MM/YY")
private String ccExpiration;
@Digits(integer = 3,fraction = 0,message = "Invalid CVV")
private String ccCVV;
private List<Taco> tacos=new ArrayList<>();
public void addDesign(Taco design){
this.tacos.add(design);
}
}
package com.wdh.tacocloud.model;
import lombok.Data;
import javax.validation.constraints.NotNull;
import javax.validation.constraints.Size;
import java.util.Date;
import java.util.List;
/**
* @author WangDH
* @create 2022-08-25 9:12
*/
@Data
public class Taco {
private Long id;
private Date createdAt;
@NotNull
@Size(min = 5,message = "Name must be at least 5 characters long")
private String name;
@Size(min = 1,message = "You must choose at least 1 ingredient.")
private List<Ingredient> ingredients;
}
controller层代码
package com.wdh.tacocloud.controller;
import com.wdh.tacocloud.data.IngredientRepository;
import com.wdh.tacocloud.data.TacoRepository;
import com.wdh.tacocloud.model.Ingredient;
import com.wdh.tacocloud.model.Ingredient.Type;
import com.wdh.tacocloud.model.Order;
import com.wdh.tacocloud.model.Taco;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.Errors;
import org.springframework.web.bind.annotation.*;
import javax.validation.Valid;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import java.util.stream.Collectors;
/**
* @author WangDH
* @create 2022-08-24 17:34
*
* 在控制器中注入并使用repository
*/
@Slf4j
@Controller
@RequestMapping("/design")
@SessionAttributes("order")
public class DesignTacoController {
private final IngredientRepository ingredientRepository;
private TacoRepository designRepo;
@Autowired
public DesignTacoController(
IngredientRepository ingredientRepository,
TacoRepository tacoRepository
) {
this.ingredientRepository = ingredientRepository;
this.designRepo=tacoRepository;
}
@ModelAttribute(name="taco")
public Taco taco(){
return new Taco();
}
@ModelAttribute(name="order")
public Order order(){
return new Order();
}
@GetMapping
public String showDesignForm(Model model){
List<Ingredient> ingredients=new ArrayList<>();
ingredientRepository.findAll().forEach(i->ingredients.add(i));
Type[] types=Ingredient.Type.values();
for(Type type:types){
model.addAttribute(type.toString().toLowerCase(),
filterByType(ingredients,type));
}
return "design";
}
private List<Ingredient> filterByType(List<Ingredient> ingredients,Type type){
return ingredients.stream().filter(x->x.getType().equals(type)).collect(Collectors.toList());
}
//接收提交的信息
@PostMapping
public String processDesign(@Valid Taco design,
Errors errors,
@ModelAttribute Order order){
if(errors.hasErrors())
{
//log.info("processDesign enter,has error.errors="+errors);
log.info("processDesign enter,has error.errors");
return "design";
}
log.info("Process design:"+design);
Taco saved=designRepo.save(design);
order.addDesign(saved);
return "redirect:/orders/current";
}
}
package com.wdh.tacocloud.controller;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
/**
* @author WangDH
* @create 2022-08-24 16:25
*/
@Controller
public class HomeController {
@GetMapping("/")
public String home(){
return "home";
}
}
package com.wdh.tacocloud.controller;
import com.wdh.tacocloud.data.OrderRepository;
import com.wdh.tacocloud.model.Order;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.Errors;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.SessionAttributes;
import org.springframework.web.bind.support.SessionStatus;
import javax.validation.Valid;
/**
* @author WangDH
* @create 2022-08-25 10:07
*/
@Slf4j
@Controller
@RequestMapping("/orders")
@SessionAttributes("order")
public class OrderController {
private OrderRepository orderRepo;
public OrderController(OrderRepository orderRepo){
this.orderRepo=orderRepo;
}
@GetMapping("/current") //与OrderController的url联合组成/orders/current
public String orderForm(){
return "orderForm";
}
@PostMapping
public String processOrder(
@Valid Order order,
Errors errors,
SessionStatus sessionStatus
){
if(errors.hasErrors()){
//log.info("processOrder tips,has errors="+errors);
log.info("processOrder tips,has errors=");
return "orderForm";
}
orderRepo.save(order);
sessionStatus.setComplete();//清除session中的缓存
log.info("Order submitted:"+order);
return "redirect:/";
}
}
package com.wdh.tacocloud.controller;
import com.wdh.tacocloud.data.IngredientRepository;
import com.wdh.tacocloud.model.Ingredient;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.core.convert.converter.Converter;
import org.springframework.stereotype.Component;
/**
* @author WangDH
* @create 2022-08-26 11:31
*/
@Component
public class IngredientByIdConverter implements Converter<String, Ingredient> {
private IngredientRepository ingredientRepo;
@Autowired
public IngredientByIdConverter(IngredientRepository ingredientRepo) {
this.ingredientRepo = ingredientRepo;
}
@Override
public Ingredient convert(String id) {
return ingredientRepo.findById(id);
}
}
application.properties
# 应用名称
spring.application.name=taco-cloud
# 应用服务 WEB 访问端口
server.port=8080
# THYMELEAF (ThymeleafAutoConfiguration)
# 开启模板缓存(默认值: true ) wdh:正式上线时设置为true,开发调试时设置为false便于刷新页面获取最新目标
spring.thymeleaf.cache=false
# 检查模板是否存在,然后再呈现
spring.thymeleaf.check-template=true
# 检查模板位置是否正确(默认值 :true )
spring.thymeleaf.check-template-location=true
#Content-Type 的值(默认值: text/html )
spring.thymeleaf.content-type=text/html
# 开启 MVC Thymeleaf 视图解析(默认值: true )
spring.thymeleaf.enabled=true
# 模板编码
spring.thymeleaf.encoding=UTF-8
# 要被排除在解析之外的视图名称列表,⽤逗号分隔
spring.thymeleaf.excluded-view-names=
# 要运⽤于模板之上的模板模式。另⻅ StandardTemplate-ModeHandlers( 默认值: HTML5)
spring.thymeleaf.mode=HTML5
# 在构建 URL 时添加到视图名称前的前缀(默认值: classpath:/templates/ )
spring.thymeleaf.prefix=classpath:/templates/
# 在构建 URL 时添加到视图名称后的后缀(默认值: .html )
spring.thymeleaf.suffix=.html
运行日志
"C:\Program Files\Java\jdk1.8.0_111\bin\java.exe" -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-javaagent:D:\JavaDevEnv\JetBrains\IntelliJ IDEA 2018.3.6\lib\idea_rt.jar=4346:D:\JavaDevEnv\JetBrains\IntelliJ IDEA 2018.3.6\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_111\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\rt.jar;D:\JavaWorkspace\IdeaProjects\SpringInAction5Test\chapter03\taco-cloud\target\classes;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-thymeleaf\2.3.7.RELEASE\spring-boot-starter-thymeleaf-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter\2.3.7.RELEASE\spring-boot-starter-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-logging\2.3.7.RELEASE\spring-boot-starter-logging-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;D:\JavaDevEnv\maven_repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;D:\JavaDevEnv\maven_repository\org\apache\logging\log4j\log4j-to-slf4j\2.13.3\log4j-to-slf4j-2.13.3.jar;D:\JavaDevEnv\maven_repository\org\apache\logging\log4j\log4j-api\2.13.3\log4j-api-2.13.3.jar;D:\JavaDevEnv\maven_repository\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;D:\JavaDevEnv\maven_repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;D:\JavaDevEnv\maven_repository\org\yaml\snakeyaml\1.26\snakeyaml-1.26.jar;D:\JavaDevEnv\maven_repository\org\thymeleaf\thymeleaf-spring5\3.0.11.RELEASE\thymeleaf-spring5-3.0.11.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\thymeleaf\thymeleaf\3.0.11.RELEASE\thymeleaf-3.0.11.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\attoparser\attoparser\2.0.5.RELEASE\attoparser-2.0.5.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\unbescape\unbescape\1.1.6.RELEASE\unbescape-1.1.6.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;D:\JavaDevEnv\maven_repository\org\thymeleaf\extras\thymeleaf-extras-java8time\3.0.4.RELEASE\thymeleaf-extras-java8time-3.0.4.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-web\2.3.7.RELEASE\spring-boot-starter-web-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-json\2.3.7.RELEASE\spring-boot-starter-json-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\jackson\core\jackson-databind\2.11.3\jackson-databind-2.11.3.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\jackson\core\jackson-annotations\2.11.3\jackson-annotations-2.11.3.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\jackson\core\jackson-core\2.11.3\jackson-core-2.11.3.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.3\jackson-datatype-jdk8-2.11.3.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.3\jackson-datatype-jsr310-2.11.3.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.3\jackson-module-parameter-names-2.11.3.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-tomcat\2.3.7.RELEASE\spring-boot-starter-tomcat-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.41\tomcat-embed-core-9.0.41.jar;D:\JavaDevEnv\maven_repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.41\tomcat-embed-websocket-9.0.41.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-web\5.2.12.RELEASE\spring-web-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-beans\5.2.12.RELEASE\spring-beans-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-webmvc\5.2.12.RELEASE\spring-webmvc-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-aop\5.2.12.RELEASE\spring-aop-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-context\5.2.12.RELEASE\spring-context-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-expression\5.2.12.RELEASE\spring-expression-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-devtools\2.3.7.RELEASE\spring-boot-devtools-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot\2.3.7.RELEASE\spring-boot-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-autoconfigure\2.3.7.RELEASE\spring-boot-autoconfigure-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-core\5.2.12.RELEASE\spring-core-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-jcl\5.2.12.RELEASE\spring-jcl-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\projectlombok\lombok\1.18.24\lombok-1.18.24.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-validation\2.3.7.RELEASE\spring-boot-starter-validation-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\glassfish\jakarta.el\3.0.3\jakarta.el-3.0.3.jar;D:\JavaDevEnv\maven_repository\org\hibernate\validator\hibernate-validator\6.1.6.Final\hibernate-validator-6.1.6.Final.jar;D:\JavaDevEnv\maven_repository\jakarta\validation\jakarta.validation-api\2.0.2\jakarta.validation-api-2.0.2.jar;D:\JavaDevEnv\maven_repository\org\jboss\logging\jboss-logging\3.4.1.Final\jboss-logging-3.4.1.Final.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\classmate\1.5.1\classmate-1.5.1.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-jdbc\2.3.7.RELEASE\spring-boot-starter-jdbc-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\com\zaxxer\HikariCP\3.4.5\HikariCP-3.4.5.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-jdbc\5.2.12.RELEASE\spring-jdbc-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-tx\5.2.12.RELEASE\spring-tx-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\com\h2database\h2\2.1.214\h2-2.1.214.jar" com.wdh.tacocloud.TacoCloudApplication
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v2.3.7.RELEASE)
2022-09-02 14:32:49.796 INFO 120 --- [ restartedMain] com.wdh.tacocloud.TacoCloudApplication : Starting TacoCloudApplication on 14JPYI7CBESDNFK with PID 120 (D:\JavaWorkspace\IdeaProjects\SpringInAction5Test\chapter03\taco-cloud\target\classes started by Administrator in D:\JavaWorkspace\IdeaProjects\SpringInAction5Test\chapter03\taco-cloud)
2022-09-02 14:32:49.798 INFO 120 --- [ restartedMain] com.wdh.tacocloud.TacoCloudApplication : No active profile set, falling back to default profiles: default
2022-09-02 14:32:49.848 INFO 120 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
2022-09-02 14:32:49.848 INFO 120 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
2022-09-02 14:32:50.964 INFO 120 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http)
2022-09-02 14:32:50.975 INFO 120 --- [ restartedMain] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2022-09-02 14:32:50.976 INFO 120 --- [ restartedMain] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.41]
2022-09-02 14:32:51.048 INFO 120 --- [ restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
2022-09-02 14:32:51.049 INFO 120 --- [ restartedMain] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1201 ms
2022-09-02 14:32:51.097 INFO 120 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2022-09-02 14:32:51.216 INFO 120 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2022-09-02 14:32:51.272 INFO 120 --- [ restartedMain] o.s.b.a.h2.H2ConsoleAutoConfiguration : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:bb2bca5c-d509-4b72-94fd-37b54548cee3'
2022-09-02 14:32:51.320 INFO 120 --- [ restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 35729
2022-09-02 14:32:51.753 INFO 120 --- [ restartedMain] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor'
2022-09-02 14:32:51.856 WARN 120 --- [ restartedMain] org.thymeleaf.templatemode.TemplateMode : [THYMELEAF][restartedMain] Template Mode 'HTML5' is deprecated. Using Template Mode 'HTML' instead.
2022-09-02 14:32:51.931 INFO 120 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path ''
2022-09-02 14:32:51.939 INFO 120 --- [ restartedMain] com.wdh.tacocloud.TacoCloudApplication : Started TacoCloudApplication in 2.439 seconds (JVM running for 3.165)
2022-09-02 14:33:14.123 INFO 120 --- [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet'
2022-09-02 14:33:14.123 INFO 120 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'
2022-09-02 14:33:14.128 INFO 120 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 5 ms
JPA部分关键代码
与JDBC不同的,JPA关键的依赖
<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-data-jpa -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
<!--<version>2.7.3</version>-->
</dependency>
<!-- https://mvnrepository.com/artifact/org.eclipse.persistence/eclipselink -->
<dependency>
<groupId>org.eclipse.persistence</groupId>
<artifactId>eclipselink</artifactId>
<version>4.0.0-M3</version>
</dependency>
完整的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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.wdh</groupId>
<artifactId>tacocloud</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>tacocloud</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<spring-boot.version>2.3.7.RELEASE</spring-boot.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-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
<optional>true</optional>
</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>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.24</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-validation</artifactId>
<!-- <version>2.3.7.RELEASE</version> 根据自己的版本引入-->
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-data-jpa -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
<!--<version>2.7.3</version>-->
</dependency>
<!-- https://mvnrepository.com/artifact/org.eclipse.persistence/eclipselink -->
<dependency>
<groupId>org.eclipse.persistence</groupId>
<artifactId>eclipselink</artifactId>
<version>4.0.0-M3</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.h2database/h2 -->
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>2.1.214</version>
<scope>runtime</scope>
</dependency>
</dependencies>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-dependencies</artifactId>
<version>${spring-boot.version}</version>
<type>pom</type>
<scope>import</scope>
</dependency>
</dependencies>
</dependencyManagement>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.1</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<version>2.3.7.RELEASE</version>
<configuration>
<mainClass>com.wdh.tacocloud.TacocloudApplication</mainClass>
</configuration>
<executions>
<execution>
<id>repackage</id>
<goals>
<goal>repackage</goal>
</goals>
</execution>
</executions>
</plugin>
</plugins>
</build>
</project>
SpringBootApplication
package com.wdh.tacocloud;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class TacocloudApplication {
//注意,使用spring data Jdbc时 会自动执行data.sql和schema.sql
//注意,使用spring data JPA时 不会自动执行data.sql,仅会执行schema.sql
//可以打开http://localhost:8080/h2-console,根据idea 控制台打印的H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:27598f8c-e777-4993-83df-7076ce35376b'信息登录进行手动录入数据
//参考https://docs.spring.io/spring-boot/docs/current/reference/html/howto.html#howto.data-initialization.using-jpa
public static void main(String[] args) {
SpringApplication.run(TacocloudApplication.class, args);
}
}
Repository层代码
package com.wdh.tacocloud.data;
import com.wdh.tacocloud.model.Ingredient;
import org.springframework.data.repository.CrudRepository;
/**
* @author WangDH
* @create 2022-08-25 14:43
*
* Ingredient实体的数据访问接口
*/
public interface IngredientRepository extends CrudRepository<Ingredient,String> {
//CrudRepository 已经包含增删改查的实现,这里不需要再写常规的实现代码
}
package com.wdh.tacocloud.data;
import com.wdh.tacocloud.model.Order;
import org.springframework.data.repository.CrudRepository;
import java.util.Date;
import java.util.List;
/**
* @author WangDH
* @create 2022-08-25 17:20
*/
public interface OrderRepository extends CrudRepository<Order,Long> {
//CrudRepository 已经包含增删改查的实现,具体可看CrudRepository定义,这里不需要再写实现代码
//以下是自定义JPA repository
List<Order> findByDeliveryZip(String deliveryZip);
List<Order> readOrdersByDeliveryZipAndPlacedAtBetween(
String deliveryZip, Date startdate, Date endDate
);
}
package com.wdh.tacocloud.data;
import com.wdh.tacocloud.model.Taco;
import org.springframework.data.repository.CrudRepository;
/**
* @author WangDH
* @create 2022-08-25 17:18
*/
public interface TacoRepository extends CrudRepository<Taco,Long> {
//CrudRepository 已经包含增删改查的实现,这里不需要再写实现代码
}
需要注意的是在Repository层基本不用写增删改查的代码,因为Spring的CrudRepository已经自动帮你做了。spring自带的CrudRepository的代码如下,可以看到spring已经帮我们实现了基本的crud.
//
// Source code recreated from a .class file by IntelliJ IDEA
// (powered by Fernflower decompiler)
//
package org.springframework.data.repository;
import java.util.Optional;
@NoRepositoryBean
public interface CrudRepository<T, ID> extends Repository<T, ID> {
<S extends T> S save(S var1);
<S extends T> Iterable<S> saveAll(Iterable<S> var1);
Optional<T> findById(ID var1);
boolean existsById(ID var1);
Iterable<T> findAll();
Iterable<T> findAllById(Iterable<ID> var1);
long count();
void deleteById(ID var1);
void delete(T var1);
void deleteAll(Iterable<? extends T> var1);
void deleteAll();
}
Model层代码
package com.wdh.tacocloud.model;
import lombok.AccessLevel;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.RequiredArgsConstructor;
import javax.persistence.Entity;
import javax.persistence.Id;
/**
* @author WangDH
* @create 2022-08-24 17:18
*/
@Data
@RequiredArgsConstructor
@NoArgsConstructor(access = AccessLevel.PRIVATE,force = true) //因JPA需要一个无参构造函数,这里通过注解让lombok生成构造函数
@Entity //JPA需要的注解
public class Ingredient {
@Id //jpa需要的注解,表明该字段为主键
private final String id;
private final String name;
private final String mytype;
public static enum Type{
WRAP,PROTEIN,VEGGIES,CHEESE,SAUCE
}
}
package com.wdh.tacocloud.model;
import lombok.Data;
import javax.persistence.*;
import javax.validation.constraints.Digits;
import javax.validation.constraints.NotBlank;
import javax.validation.constraints.Pattern;
import org.hibernate.validator.constraints.CreditCardNumber;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
/**
* @author WangDH
* @create 2022-08-25 10:10
*/
@Data
@Entity
@Table(name="Taco_Order")
public class Order implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Long id;
private Date placedAt;
@NotBlank(message="Delivery name is required")
private String deliveryName;
@NotBlank(message="Street is required")
private String deliveryStreet;
@NotBlank(message="City is required")
private String deliveryCity;
@NotBlank(message="State is required")
private String deliveryState;
@NotBlank(message="Zip code is required")
private String deliveryZip;
@CreditCardNumber(message = "Not a valid credit card number")
private String ccNumber; //Test VISA credit card number: 4005550000000019
@Pattern(regexp = "^(0[1-9]|1[0-2])([\\/])([1-9][0-9])$",message = "Must be formatted MM/YY")
private String ccExpiration;
@Digits(integer = 3,fraction = 0,message = "Invalid CVV")
private String ccCVV;
@ManyToMany(targetEntity = Taco.class)
private List<Taco> tacos=new ArrayList<>();
public void addDesign(Taco design){
this.tacos.add(design);
}
@PrePersist
void placedAt(){
this.placedAt=new Date();
}
}
package com.wdh.tacocloud.model;
import lombok.Data;
import javax.persistence.*;
import javax.validation.constraints.NotNull;
import javax.validation.constraints.Size;
import java.util.Date;
import java.util.List;
/**
* @author WangDH
* @create 2022-08-25 9:12
*/
@Data
@Entity
public class Taco {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Long id;
private Date createdAt;
@NotNull
@Size(min = 5,message = "Name must be at least 5 characters long")
private String name;
@ManyToMany(targetEntity = Ingredient.class)
@Size(min = 1,message = "You must choose at least 1 ingredient.")
private List<Ingredient> ingredients;
@PrePersist
void createdAt(){
this.createdAt=new Date();
}
}
Controller层代码
package com.wdh.tacocloud.controller;
import com.wdh.tacocloud.data.IngredientRepository;
import com.wdh.tacocloud.data.TacoRepository;
import com.wdh.tacocloud.model.Ingredient;
import com.wdh.tacocloud.model.Ingredient.Type;
import com.wdh.tacocloud.model.Order;
import com.wdh.tacocloud.model.Taco;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.Errors;
import org.springframework.web.bind.annotation.*;
import javax.validation.Valid;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import java.util.stream.Collectors;
/**
* @author WangDH
* @create 2022-08-24 17:34
*
* 在控制器中注入并使用repository
*/
@Slf4j
@Controller
@RequestMapping("/design")
@SessionAttributes("order")
public class DesignTacoController {
private final IngredientRepository ingredientRepository;
private TacoRepository designRepo;
@Autowired
public DesignTacoController(
IngredientRepository ingredientRepository,
TacoRepository tacoRepository
) {
this.ingredientRepository = ingredientRepository;
this.designRepo=tacoRepository;
}
@ModelAttribute(name="taco")
public Taco taco(){
return new Taco();
}
@ModelAttribute(name="order")
public Order order(){
return new Order();
}
@GetMapping
public String showDesignForm(Model model){
List<Ingredient> ingredients=new ArrayList<>();
Iterable<Ingredient> listAll= ingredientRepository.findAll();
listAll.forEach(i->ingredients.add(i));
Type[] types=Ingredient.Type.values();
for(Type type:types){
model.addAttribute(type.toString().toLowerCase(),
filterByType(ingredients,type));
}
return "design";
}
private List<Ingredient> filterByType(List<Ingredient> ingredients,Type type){
return ingredients.stream().filter(x->x.getMytype().equals(type.toString())).collect(Collectors.toList());
}
//接收提交的信息
@PostMapping
public String processDesign(@Valid Taco design,
Errors errors,
@ModelAttribute Order order){
if(errors.hasErrors())
{
//log.info("processDesign enter,has error.errors="+errors);
log.info("processDesign enter,has error.errors");
return "design";
}
log.info("Process design:"+design);
Taco saved=designRepo.save(design);
order.addDesign(saved);
return "redirect:/orders/current";
}
}
package com.wdh.tacocloud.controller;
import com.wdh.tacocloud.data.OrderRepository;
import com.wdh.tacocloud.model.Order;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.Errors;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.SessionAttributes;
import org.springframework.web.bind.support.SessionStatus;
import javax.validation.Valid;
/**
* @author WangDH
* @create 2022-08-25 10:07
*/
@Slf4j
@Controller
@RequestMapping("/orders")
@SessionAttributes("order")
public class OrderController {
private OrderRepository orderRepo;
public OrderController(OrderRepository orderRepo){
this.orderRepo=orderRepo;
}
@GetMapping("/current") //与OrderController的url联合组成/orders/current
public String orderForm(){
return "orderForm";
}
@PostMapping
public String processOrder(
@Valid Order order,
Errors errors,
SessionStatus sessionStatus
){
if(errors.hasErrors()){
//log.info("processOrder tips,has errors="+errors);
log.info("processOrder tips,has errors=");
return "orderForm";
}
orderRepo.save(order);
sessionStatus.setComplete();//清除session中的缓存
log.info("Order submitted:"+order);
return "redirect:/";
}
}
package com.wdh.tacocloud.controller;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
/**
* @author WangDH
* @create 2022-08-24 16:25
*/
@Controller
public class HomeController {
@GetMapping("/")
public String home(){
return "home";
}
}
application.properties
# 应用名称
spring.application.name=tacocloud
# 应用服务 WEB 访问端口
server.port=8080
# THYMELEAF (ThymeleafAutoConfiguration)
# 开启模板缓存(默认值: true ) wdh:正式上线时设置为true,开发调试时设置为false便于刷新页面获取最新目标
spring.thymeleaf.cache=false
# 检查模板是否存在,然后再呈现
spring.thymeleaf.check-template=true
# 检查模板位置是否正确(默认值 :true )
spring.thymeleaf.check-template-location=true
#Content-Type 的值(默认值: text/html )
spring.thymeleaf.content-type=text/html
# 开启 MVC Thymeleaf 视图解析(默认值: true )
spring.thymeleaf.enabled=true
# 模板编码
spring.thymeleaf.encoding=UTF-8
# 要被排除在解析之外的视图名称列表,⽤逗号分隔
spring.thymeleaf.excluded-view-names=
# 要运⽤于模板之上的模板模式。另⻅ StandardTemplate-ModeHandlers( 默认值: HTML5)
spring.thymeleaf.mode=HTML5
# 在构建 URL 时添加到视图名称前的前缀(默认值: classpath:/templates/ )
spring.thymeleaf.prefix=classpath:/templates/
# 在构建 URL 时添加到视图名称后的后缀(默认值: .html )
spring.thymeleaf.suffix=.html
View层代码就不放了。
运行日志
"C:\Program Files\Java\jdk1.8.0_111\bin\java.exe" -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-javaagent:D:\JavaDevEnv\JetBrains\IntelliJ IDEA 2018.3.6\lib\idea_rt.jar=4174:D:\JavaDevEnv\JetBrains\IntelliJ IDEA 2018.3.6\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_111\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_111\jre\lib\rt.jar;D:\JavaWorkspace\IdeaProjects\SpringInAction\tacocloud_jpa\target\classes;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-thymeleaf\2.3.7.RELEASE\spring-boot-starter-thymeleaf-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter\2.3.7.RELEASE\spring-boot-starter-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-logging\2.3.7.RELEASE\spring-boot-starter-logging-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;D:\JavaDevEnv\maven_repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;D:\JavaDevEnv\maven_repository\org\apache\logging\log4j\log4j-to-slf4j\2.13.3\log4j-to-slf4j-2.13.3.jar;D:\JavaDevEnv\maven_repository\org\apache\logging\log4j\log4j-api\2.13.3\log4j-api-2.13.3.jar;D:\JavaDevEnv\maven_repository\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;D:\JavaDevEnv\maven_repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;D:\JavaDevEnv\maven_repository\org\yaml\snakeyaml\1.26\snakeyaml-1.26.jar;D:\JavaDevEnv\maven_repository\org\thymeleaf\thymeleaf-spring5\3.0.11.RELEASE\thymeleaf-spring5-3.0.11.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\thymeleaf\thymeleaf\3.0.11.RELEASE\thymeleaf-3.0.11.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\attoparser\attoparser\2.0.5.RELEASE\attoparser-2.0.5.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\unbescape\unbescape\1.1.6.RELEASE\unbescape-1.1.6.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;D:\JavaDevEnv\maven_repository\org\thymeleaf\extras\thymeleaf-extras-java8time\3.0.4.RELEASE\thymeleaf-extras-java8time-3.0.4.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-web\2.3.7.RELEASE\spring-boot-starter-web-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-json\2.3.7.RELEASE\spring-boot-starter-json-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\jackson\core\jackson-databind\2.11.3\jackson-databind-2.11.3.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\jackson\core\jackson-annotations\2.11.3\jackson-annotations-2.11.3.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\jackson\core\jackson-core\2.11.3\jackson-core-2.11.3.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.3\jackson-datatype-jdk8-2.11.3.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.3\jackson-datatype-jsr310-2.11.3.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.3\jackson-module-parameter-names-2.11.3.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-tomcat\2.3.7.RELEASE\spring-boot-starter-tomcat-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.41\tomcat-embed-core-9.0.41.jar;D:\JavaDevEnv\maven_repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.41\tomcat-embed-websocket-9.0.41.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-web\5.2.12.RELEASE\spring-web-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-beans\5.2.12.RELEASE\spring-beans-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-webmvc\5.2.12.RELEASE\spring-webmvc-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-aop\5.2.12.RELEASE\spring-aop-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-context\5.2.12.RELEASE\spring-context-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-expression\5.2.12.RELEASE\spring-expression-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-devtools\2.3.7.RELEASE\spring-boot-devtools-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot\2.3.7.RELEASE\spring-boot-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-autoconfigure\2.3.7.RELEASE\spring-boot-autoconfigure-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\projectlombok\lombok\1.18.24\lombok-1.18.24.jar;D:\JavaDevEnv\maven_repository\jakarta\xml\bind\jakarta.xml.bind-api\2.3.3\jakarta.xml.bind-api-2.3.3.jar;D:\JavaDevEnv\maven_repository\jakarta\activation\jakarta.activation-api\1.2.2\jakarta.activation-api-1.2.2.jar;D:\JavaDevEnv\maven_repository\net\bytebuddy\byte-buddy\1.10.18\byte-buddy-1.10.18.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-core\5.2.12.RELEASE\spring-core-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-jcl\5.2.12.RELEASE\spring-jcl-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-validation\2.3.7.RELEASE\spring-boot-starter-validation-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\glassfish\jakarta.el\3.0.3\jakarta.el-3.0.3.jar;D:\JavaDevEnv\maven_repository\org\hibernate\validator\hibernate-validator\6.1.6.Final\hibernate-validator-6.1.6.Final.jar;D:\JavaDevEnv\maven_repository\jakarta\validation\jakarta.validation-api\2.0.2\jakarta.validation-api-2.0.2.jar;D:\JavaDevEnv\maven_repository\org\jboss\logging\jboss-logging\3.4.1.Final\jboss-logging-3.4.1.Final.jar;D:\JavaDevEnv\maven_repository\com\fasterxml\classmate\1.5.1\classmate-1.5.1.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-data-jpa\2.3.7.RELEASE\spring-boot-starter-data-jpa-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-aop\2.3.7.RELEASE\spring-boot-starter-aop-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\aspectj\aspectjweaver\1.9.6\aspectjweaver-1.9.6.jar;D:\JavaDevEnv\maven_repository\org\springframework\boot\spring-boot-starter-jdbc\2.3.7.RELEASE\spring-boot-starter-jdbc-2.3.7.RELEASE.jar;D:\JavaDevEnv\maven_repository\com\zaxxer\HikariCP\3.4.5\HikariCP-3.4.5.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-jdbc\5.2.12.RELEASE\spring-jdbc-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\jakarta\transaction\jakarta.transaction-api\1.3.3\jakarta.transaction-api-1.3.3.jar;D:\JavaDevEnv\maven_repository\jakarta\persistence\jakarta.persistence-api\2.2.3\jakarta.persistence-api-2.2.3.jar;D:\JavaDevEnv\maven_repository\org\hibernate\hibernate-core\5.4.25.Final\hibernate-core-5.4.25.Final.jar;D:\JavaDevEnv\maven_repository\org\javassist\javassist\3.27.0-GA\javassist-3.27.0-GA.jar;D:\JavaDevEnv\maven_repository\antlr\antlr\2.7.7\antlr-2.7.7.jar;D:\JavaDevEnv\maven_repository\org\jboss\jandex\2.1.3.Final\jandex-2.1.3.Final.jar;D:\JavaDevEnv\maven_repository\org\dom4j\dom4j\2.1.3\dom4j-2.1.3.jar;D:\JavaDevEnv\maven_repository\org\hibernate\common\hibernate-commons-annotations\5.1.2.Final\hibernate-commons-annotations-5.1.2.Final.jar;D:\JavaDevEnv\maven_repository\org\glassfish\jaxb\jaxb-runtime\2.3.3\jaxb-runtime-2.3.3.jar;D:\JavaDevEnv\maven_repository\org\glassfish\jaxb\txw2\2.3.3\txw2-2.3.3.jar;D:\JavaDevEnv\maven_repository\com\sun\istack\istack-commons-runtime\3.0.11\istack-commons-runtime-3.0.11.jar;D:\JavaDevEnv\maven_repository\com\sun\activation\jakarta.activation\1.2.2\jakarta.activation-1.2.2.jar;D:\JavaDevEnv\maven_repository\org\springframework\data\spring-data-jpa\2.3.6.RELEASE\spring-data-jpa-2.3.6.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\data\spring-data-commons\2.3.6.RELEASE\spring-data-commons-2.3.6.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-orm\5.2.12.RELEASE\spring-orm-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-tx\5.2.12.RELEASE\spring-tx-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\springframework\spring-aspects\5.2.12.RELEASE\spring-aspects-5.2.12.RELEASE.jar;D:\JavaDevEnv\maven_repository\org\eclipse\persistence\eclipselink\4.0.0-M3\eclipselink-4.0.0-M3.jar;D:\JavaDevEnv\maven_repository\com\sun\xml\bind\jaxb-xjc\4.0.0-M3\jaxb-xjc-4.0.0-M3.jar;D:\JavaDevEnv\maven_repository\com\sun\xml\bind\jaxb-core\4.0.0-M3\jaxb-core-4.0.0-M3.jar;D:\JavaDevEnv\maven_repository\org\eclipse\angus\angus-activation\1.0.0\angus-activation-1.0.0.jar;D:\JavaDevEnv\maven_repository\com\h2database\h2\2.1.214\h2-2.1.214.jar" com.wdh.tacocloud.TacocloudApplication
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v2.3.7.RELEASE)
2022-09-02 14:11:40.249 INFO 4256 --- [ restartedMain] com.wdh.tacocloud.TacocloudApplication : Starting TacocloudApplication on 14JPYI7CBESDNFK with PID 4256 (D:\JavaWorkspace\IdeaProjects\SpringInAction\tacocloud_jpa\target\classes started by Administrator in D:\JavaWorkspace\IdeaProjects\SpringInAction\tacocloud_jpa)
2022-09-02 14:11:40.249 INFO 4256 --- [ restartedMain] com.wdh.tacocloud.TacocloudApplication : No active profile set, falling back to default profiles: default
2022-09-02 14:11:40.311 INFO 4256 --- [ restartedMain] o.s.b.devtools.restart.ChangeableUrls : The Class-Path manifest attribute in D:\JavaDevEnv\maven_repository\com\sun\xml\bind\jaxb-xjc\4.0.0-M3\jaxb-xjc-4.0.0-M3.jar referenced one or more files that do not exist: file:/D:/JavaDevEnv/maven_repository/com/sun/xml/bind/jaxb-xjc/4.0.0-M3/jaxb-core.jar,file:/D:/JavaDevEnv/maven_repository/com/sun/xml/bind/jaxb-xjc/4.0.0-M3/jaxb-impl.jar
2022-09-02 14:11:40.311 INFO 4256 --- [ restartedMain] o.s.b.devtools.restart.ChangeableUrls : The Class-Path manifest attribute in D:\JavaDevEnv\maven_repository\com\sun\xml\bind\jaxb-core\4.0.0-M3\jaxb-core-4.0.0-M3.jar referenced one or more files that do not exist: file:/D:/JavaDevEnv/maven_repository/com/sun/xml/bind/jaxb-core/4.0.0-M3/jakarta.activation-api.jar,file:/D:/JavaDevEnv/maven_repository/com/sun/xml/bind/jaxb-core/4.0.0-M3/jakarta.xml.bind-api.jar
2022-09-02 14:11:40.311 INFO 4256 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
2022-09-02 14:11:40.311 INFO 4256 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
2022-09-02 14:11:41.013 INFO 4256 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2022-09-02 14:11:41.076 INFO 4256 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 51ms. Found 3 JPA repository interfaces.
2022-09-02 14:11:41.622 INFO 4256 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http)
2022-09-02 14:11:41.622 INFO 4256 --- [ restartedMain] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2022-09-02 14:11:41.622 INFO 4256 --- [ restartedMain] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.41]
2022-09-02 14:11:41.700 INFO 4256 --- [ restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
2022-09-02 14:11:41.700 INFO 4256 --- [ restartedMain] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1389 ms
2022-09-02 14:11:41.746 INFO 4256 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2022-09-02 14:11:41.840 INFO 4256 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2022-09-02 14:11:41.965 INFO 4256 --- [ restartedMain] o.s.b.a.h2.H2ConsoleAutoConfiguration : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:7e960301-9877-4814-932c-1b30639ea100'
2022-09-02 14:11:41.996 INFO 4256 --- [ restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 35729
2022-09-02 14:11:42.058 INFO 4256 --- [ restartedMain] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2022-09-02 14:11:42.105 INFO 4256 --- [ restartedMain] org.hibernate.Version : HHH000412: Hibernate ORM core version 5.4.25.Final
2022-09-02 14:11:42.199 INFO 4256 --- [ restartedMain] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
2022-09-02 14:11:42.292 INFO 4256 --- [ restartedMain] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.H2Dialect
2022-09-02 14:11:42.870 INFO 4256 --- [ restartedMain] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2022-09-02 14:11:42.870 INFO 4256 --- [ restartedMain] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2022-09-02 14:11:43.182 WARN 4256 --- [ restartedMain] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
2022-09-02 14:11:43.291 INFO 4256 --- [ restartedMain] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor'
2022-09-02 14:11:43.400 WARN 4256 --- [ restartedMain] org.thymeleaf.templatemode.TemplateMode : [THYMELEAF][restartedMain] Template Mode 'HTML5' is deprecated. Using Template Mode 'HTML' instead.
2022-09-02 14:11:43.478 INFO 4256 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path ''
2022-09-02 14:11:43.494 INFO 4256 --- [ restartedMain] com.wdh.tacocloud.TacocloudApplication : Started TacocloudApplication in 3.586 seconds (JVM running for 4.316)
关于H2Database
springboot程序启动后,查看IDEA控制台日志包含如下提示。该提示表明H2DataBase已经启动了,可以用浏览器访问了,并且JDBCUrl也打印出来了。
2022-09-02 14:11:41.746 INFO 4256 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2022-09-02 14:11:41.840 INFO 4256 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.2022-09-02 14:11:41.965 INFO 4256 --- [ restartedMain] o.s.b.a.h2.H2ConsoleAutoConfiguration : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:7e960301-9877-4814-932c-1b30639ea100'
在浏览器输入
http://localhost:8080/h2-console
可以进入H2Database的web登录界面
从IDEA的控制台输出日志中找到H2Database的连接字符串
2022-09-02 14:11:41.965 INFO 4256 --- [ restartedMain] o.s.b.a.h2.H2ConsoleAutoConfiguration : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:7e960301-9877-4814-932c-1b30639ea100'
将【jdbc:h2:mem:7e960301-9877-4814-932c-1b30639ea100】输入到登录页面的jdbc url栏,然后点击connect即可进入H2Database的管理界面
其他说明
//注意,使用spring data Jdbc时 会自动执行data.sql和schema.sql //注意,使用spring data JPA时 不会自动执行data.sql,仅会执行schema.sql //可以打开http://localhost:8080/h2-console,根据idea 控制台打印的H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:27598f8c-e777-4993-83df-7076ce35376b'信息登录进行手动录入数据 //参考https://docs.spring.io/spring-boot/docs/current/reference/html/howto.html#howto.data-initialization.using-jpa