未能转换“java”类型的值。lang.String“to required type”java。util。日期“on swagger

Question

我想用spring boot api访问数据库中的一个函数，并获取它返回的值。当我们在swagger中输入参数时，日期部分会出现错误。

2021 4月1日，我在oracle中调用函数的日期参数时，没有错误，但我无法从spring开始以这种方式发送。

Oracle功能代码：

    CREATE OR REPLACE PACKAGE BODY MET.Z_PKG_OEE_NEW
      FUNCTION Z_OEE_A1AfterReworkRatio(V_plant_config_num_id IN number, p_start_date in date, p_stop_date in date) RETURN NUMBER IS 
        v_result NUMBER;
        p_cur001 SYS_REFCURSOR;
      BEGIN
        Z_OEE_A1AfterReworkRatio_Detail(V_plant_config_num_id,p_start_date,p_stop_date,p_cur001, v_result);


        
        RETURN round(v_result,4);
      END Z_OEE_A1AfterReworkRatio;
end;

ooeController：

    @RestController
@RequestMapping("/api/oeeReports")
@CrossOrigin
public class OeeController {

    private OeeReportService oeeReportService;
    
    @Autowired
    public OeeController(OeeReportService oeeReportService) {
        this.oeeReportService=oeeReportService;
    }
    
    @GetMapping("A1AfterReworkRatio")
    BigDecimal A1AfterReworkRatio(@RequestParam int V_plant_config_num_id, @RequestParam @DateTimeFormat(iso = DateTimeFormat.ISO.DATE) Date p_start_date ,@RequestParam @DateTimeFormat(iso = DateTimeFormat.ISO.DATE) Date p_stop_date) {
        return this.oeeReportService.A1AfterReworkRatio( V_plant_config_num_id , p_start_date,  p_stop_date);
    }
    
}

其他服务：

@Service
public class OeeReportManager implements OeeReportService {
    
    private OeeDao oeeDao;  
    
    @Autowired
    public OeeReportManager(OeeDao oeeDao) {
        super();
        this.oeeDao=oeeDao;
    }

    @Override
    public BigDecimal A1AfterReworkRatio(int V_plant_config_num_id, Date p_start_date, Date p_stop_date) {
        // TODO Auto-generated method stub
        return this.oeeDao.A1AfterReworkRatio(V_plant_config_num_id, p_start_date, p_stop_date);
    }

    

}

oeedao：

@Repository
public class OeeDao  {
    
    
    @Autowired
    private EntityManager entitymanager;
    

    

    public BigDecimal A1AfterReworkRatio(int V_plant_config_num_id,Date p_start_date,Date p_stop_date) {
        
            BigDecimal commentCount = (BigDecimal) entitymanager
                    .createNativeQuery(
                        "SELECT Z_OEE_A1AfterReworkRatio(:V_plant_config_num_id:p_start_date:p_stop_date) FROM DUAL"
                    )
                    .setParameter("V_plant_config_num_id", V_plant_config_num_id).setParameter("p_start_date", p_start_date).setParameter("p_stop_date", p_stop_date)
                    .getSingleResult();
              return commentCount;
       
        }
    
    }

昂首阔步：

错误：

 {
  "timestamp": "2021-08-26T07:00:23.487+00:00",
  "status": 500,
  "error": "Internal Server Error",
  "trace": "org.springframework.dao.InvalidDataAccessApiUsageException: Could not locate named parameter [V_plant_config_num_id], expecting one of [V_plant_config_num_id:p_start_date:p_stop_date]; nested exception is java.lang.IllegalArgumentException: Could not locate named parameter [V_plant_config_num_id], expecting one of [V_plant_config_num_id:p_start_date:p_stop_date]\r\n\tat 

如何解决这个问题？

Answer 1

根据https://www.baeldung.com/spring-date-parameters您可以在OeeController中用DateTimeFormat（iso=DateTimeFormat.iso.date）注释日期参数（来自：spring boot application{while creating beans error}）：

@GetMapping("A1AfterReworkRatio")
int A1AfterReworkRatio(@RequestParam int V_plant_config_num_id, 
    @RequestParam @DateTimeFormat(iso = DateTimeFormat.ISO.DATE) Date p_start_date, 
    @RequestParam @DateTimeFormat(iso = DateTimeFormat.ISO.DATE) Date p_stop_date) {
        return this.oeeReportService.A1AfterReworkRatio( V_plant_config_num_id , p_start_date,  p_stop_date);
}

如果你通读它，上面的文章还描述了实现它的其他方法。