package com.whyc.controller;
|
|
import com.whyc.dto.ActionUtil;
|
import com.whyc.dto.Response;
|
import com.whyc.service.FileParamService;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.format.annotation.DateTimeFormat;
|
import org.springframework.web.bind.annotation.GetMapping;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RequestParam;
|
import org.springframework.web.bind.annotation.RestController;
|
|
import java.text.ParseException;
|
import java.util.Date;
|
|
@RestController
|
@RequestMapping("fileParam")
|
@Api(tags = "数据库管理")
|
public class FileParamController {
|
@Autowired
|
private FileParamService service;
|
|
@ApiOperation("查询数据中存在的电池标称电压类型")
|
@GetMapping("getMonVolStd")
|
public Response getMonVolStd(){
|
return service.getMonVolStd();
|
}
|
@ApiOperation("按照筛选条件查询数据库信息")
|
@GetMapping("getDataByCondition")
|
public Response getDataByCondition(@RequestParam(required = false ,defaultValue = "1982-01-01 00:00:00") String startTime
|
, @RequestParam(required = false,defaultValue = "2222-01-01 00:00:00") String endTime
|
, @RequestParam(required = false) int battVol) {
|
Date testTime1= null;
|
Date testTime2= null;
|
try {
|
testTime1 = ActionUtil.sdfwithALL.parse(startTime);
|
testTime2 = ActionUtil.sdfwithALL.parse(endTime);
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}
|
return service.getDataByCondition(testTime1,testTime2,battVol);
|
}
|
}
|