Spring In Action 5 学习笔记 chapter3之JDBCTemplate 与JPA简单比较

目录

比较结论

JDBC部分关键代码

jdbc的关键依赖

H2 Database的依赖

完整pom.xml

Repository层的接口代码

Repository层-实现接口的代码-基于JDBCTemplate

原生的JDBC代码

Model层代码

controller层代码

application.properties

运行日志

JPA部分关键代码

与JDBC不同的，JPA关键的依赖

完整的pom.xml

SpringBootApplication

Repository层代码

Model层代码

Controller层代码

application.properties

运行日志

关于H2Database

其他说明

---

比较结论

JPA的Repository层基本不需要写代码，spring会帮你自动生成CRUD的代码；

JDBCTemplate的Repository层需要自己写接口，并且还要写具体实现类来实现Repository层的接口；

以上没有优劣，都是工具，存在即真理，根据项目场景和需求，选用合适的工具即可。

关于思维，顺带引用一句【查理.芒格】在《穷查理宝典》的话

手拿铁锤的人，看什么都像钉子

也有人说来自【马克.吐温】

To a man with a hammer, everything looks like a nail.

谨记：避开落入工具人和铁锤思维的陷阱。

二者依赖项不同，其他不同点见下图

JDBC部分关键代码

jdbc的关键依赖

        
            org.springframework.boot
            spring-boot-starter-jdbc
        

H2 Database的依赖

        
        
            com.h2database
            h2
            2.1.214
            runtime
        

完整pom.xml

"1.0" encoding="UTF-8"?>
"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">
    4.0.0
    com.wdh
    taco-cloud
    0.0.1-SNAPSHOT
    taco-cloud
    Demo project for Spring Boot
 
    
        1.8
        UTF-8
        UTF-8
        2.3.7.RELEASE
    
 
    
        
            org.springframework.boot
            spring-boot-starter-thymeleaf
        
        
            org.springframework.boot
            spring-boot-starter-web
        
 
        
            org.springframework.boot
            spring-boot-devtools
            runtime
            true
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
            
                
                    org.junit.vintage
                    junit-vintage-engine
                
            
        
 
        
            org.projectlombok
            lombok
            1.18.24
            provided
        
 
 
        
            org.springframework.boot
            spring-boot-starter-validation
            
        
 
        
 
        
            org.springframework.boot
            spring-boot-starter-jdbc
        
 
        
        
            com.h2database
            h2
            2.1.214
            runtime
        
 
 
 
    
 
    
        
            
                org.springframework.boot
                spring-boot-dependencies
                ${spring-boot.version}
                pom
                import
            
        
    
 
    
        
            
                org.apache.maven.plugins
                maven-compiler-plugin
                3.8.1
                
                    1.8
                    1.8
                    UTF-8
                
            
            
                org.springframework.boot
                spring-boot-maven-plugin
                2.3.7.RELEASE
                
                    com.wdh.tacocloud.TacoCloudApplication
                
                
                    
                        repackage
                        
                            repackage
                        
                    
                
            
        
    
 

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 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 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 tacos=order.getTacos();
        for(Taco taco:tacos){
            saveTacoToOrder(taco,orderId);
        }
        return order;
    }
 
    private long saveOrderDetails(Order order){
        Map 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 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 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 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 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 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 filterByType(List 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 {
 
    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关键的依赖

        
        <dependency>
            <groupId>org.springframework.bootgroupId>
            <artifactId>spring-boot-starter-data-jpaartifactId>
            
        dependency>
 
        
        <dependency>
            <groupId>org.eclipse.persistencegroupId>
            <artifactId>eclipselinkartifactId>
            <version>4.0.0-M3version>
        dependency>

完整的pom.xml

"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.0modelVersion>
    <groupId>com.wdhgroupId>
    <artifactId>tacocloudartifactId>
    <version>0.0.1-SNAPSHOTversion>
    <name>tacocloudname>
    <description>Demo project for Spring Bootdescription>
 
    <properties>
        <java.version>1.8java.version>
        <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8project.reporting.outputEncoding>
        <spring-boot.version>2.3.7.RELEASEspring-boot.version>
    properties>
 
    <dependencies>
        <dependency>
            <groupId>org.springframework.bootgroupId>
            <artifactId>spring-boot-starter-thymeleafartifactId>
        dependency>
        <dependency>
            <groupId>org.springframework.bootgroupId>
            <artifactId>spring-boot-starter-webartifactId>
        dependency>
 
        <dependency>
            <groupId>org.springframework.bootgroupId>
            <artifactId>spring-boot-devtoolsartifactId>
            <scope>runtimescope>
            <optional>trueoptional>
        dependency>
        <dependency>
            <groupId>org.projectlombokgroupId>
            <artifactId>lombokartifactId>
            <optional>trueoptional>
        dependency>
        <dependency>
            <groupId>org.springframework.bootgroupId>
            <artifactId>spring-boot-starter-testartifactId>
            <scope>testscope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintagegroupId>
                    <artifactId>junit-vintage-engineartifactId>
                exclusion>
            exclusions>
        dependency>
        <dependency>
            <groupId>org.projectlombokgroupId>
            <artifactId>lombokartifactId>
            <version>1.18.24version>
            <scope>providedscope>
        dependency>
 
 
        <dependency>
            <groupId>org.springframework.bootgroupId>
            <artifactId>spring-boot-starter-validationartifactId>
            
        dependency>
 
        
        <dependency>
            <groupId>org.springframework.bootgroupId>
            <artifactId>spring-boot-starter-data-jpaartifactId>
            
        dependency>
 
        
        <dependency>
            <groupId>org.eclipse.persistencegroupId>
            <artifactId>eclipselinkartifactId>
            <version>4.0.0-M3version>
        dependency>
 
        
        <dependency>
            <groupId>com.h2databasegroupId>
            <artifactId>h2artifactId>
            <version>2.1.214version>
            <scope>runtimescope>
        dependency>
    dependencies>
 
    <dependencyManagement>
        <dependencies>
            <dependency>
                <groupId>org.springframework.bootgroupId>
                <artifactId>spring-boot-dependenciesartifactId>
                <version>${spring-boot.version}version>
                <type>pomtype>
                <scope>importscope>
            dependency>
        dependencies>
    dependencyManagement>
 
    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.pluginsgroupId>
                <artifactId>maven-compiler-pluginartifactId>
                <version>3.8.1version>
                <configuration>
                    <source>1.8source>
                    <target>1.8target>
                    <encoding>UTF-8encoding>
                configuration>
            plugin>
            <plugin>
                <groupId>org.springframework.bootgroupId>
                <artifactId>spring-boot-maven-pluginartifactId>
                <version>2.3.7.RELEASEversion>
                <configuration>
                    <mainClass>com.wdh.tacocloud.TacocloudApplicationmainClass>
                configuration>
                <executions>
                    <execution>
                        <id>repackageid>
                        <goals>
                            <goal>repackagegoal>
                        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 {
    //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 {
    //CrudRepository 已经包含增删改查的实现，具体可看CrudRepository定义，这里不需要再写实现代码
 
    //以下是自定义JPA repository
    List findByDeliveryZip(String deliveryZip);
 
    List 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 {
    //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 extends Repository {
    extends T> S save(S var1);
 
    extends T> Iterable saveAll(Iterable var1);
 
    Optional findById(ID var1);
 
    boolean existsById(ID var1);
 
    Iterable findAll();
 
    Iterable findAllById(Iterable var1);
 
    long count();
 
    void deleteById(ID var1);
 
    void delete(T var1);
 
    void deleteAll(Iterable var1);
 
    void deleteAll();
}

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 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 ingredients;
 
    @PrePersist
    void createdAt(){
        this.createdAt=new Date();
    }
}

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 ingredients=new ArrayList<>();
        Iterable 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 filterByType(List 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";
    }
 
 
}