From 07ee6872dcbc977ad0b3c902e452d571d3a01661 Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期三, 14 八月 2024 09:46:30 +0800
Subject: [PATCH] 备用数据库
---
src/main/java/com/whyc/service/MonInfService.java | 79 +++++++++++++++++++
src/main/resources/mapper/MonInfMapper.xml | 8 ++
src/main/resources/config/application-dev.yml | 2
src/main/java/com/whyc/mapper/MonInfMapper.java | 8 ++
src/main/resources/config/application-prod.yml | 2
src/main/java/com/whyc/controller/MonInfController.java | 51 ++++++++++++
src/main/java/com/whyc/pojo/MonInf.java | 72 ++++++++++++++++++
7 files changed, 222 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/controller/MonInfController.java b/src/main/java/com/whyc/controller/MonInfController.java
new file mode 100644
index 0000000..a435027
--- /dev/null
+++ b/src/main/java/com/whyc/controller/MonInfController.java
@@ -0,0 +1,51 @@
+package com.whyc.controller;
+
+import com.whyc.dto.Response;
+import com.whyc.pojo.MonInf;
+import com.whyc.service.MonInfService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+
+import javax.servlet.http.HttpServletRequest;
+
+@RequestMapping("mon")
+@RestController
+@Api(tags = "澶囩敤钃勭數姹犵鐞�")
+public class MonInfController {
+
+ @Autowired
+ private MonInfService service;
+
+
+ @PostMapping("addLaidUp")
+ @ApiOperation("鍏ュ簱")
+ public Response addLaidUp(@RequestBody MonInf monInf){
+ return service.addLaidUp(monInf);
+ }
+
+ @PostMapping("updateMon")
+ @ApiOperation("淇敼鍗曚綋淇℃伅")
+ public Response updateMonInf(@RequestBody MonInf monInf){
+ return service.updateMonInf(monInf);
+ }
+
+ @GetMapping("updateType")
+ @ApiOperation("淇敼鍗曚綋鍒嗙被")
+ public Response updateMonType(@RequestParam int monId,@RequestParam String monType){
+ return service.updateMonType(monId,monType);
+ }
+
+ @GetMapping("updateMonBad")
+ @ApiOperation("鎶ュ簾鍗曚綋")
+ public Response updateMonBad(@RequestParam int monId){
+ return service.updateMonBad(monId);
+ }
+
+ @GetMapping("getAllMon")
+ @ApiOperation("鏌ヨ鍗曚綋淇℃伅")
+ public Response getAllMon(@RequestParam(required = false) String monType,@RequestParam int pageNum,@RequestParam int pageSize){
+ return service.getAllMon(monType,pageNum,pageSize);
+ }
+}
\ No newline at end of file
diff --git a/src/main/java/com/whyc/mapper/MonInfMapper.java b/src/main/java/com/whyc/mapper/MonInfMapper.java
new file mode 100644
index 0000000..1a3e572
--- /dev/null
+++ b/src/main/java/com/whyc/mapper/MonInfMapper.java
@@ -0,0 +1,8 @@
+package com.whyc.mapper;
+
+import com.whyc.pojo.MonInf;
+
+public interface MonInfMapper extends CustomMapper<MonInf>{
+ //鏌ヨ鏈�澶х殑鍗曚綋缂栧彿
+ Integer getMaxMonId();
+}
\ No newline at end of file
diff --git a/src/main/java/com/whyc/pojo/MonInf.java b/src/main/java/com/whyc/pojo/MonInf.java
new file mode 100644
index 0000000..b8a5e38
--- /dev/null
+++ b/src/main/java/com/whyc/pojo/MonInf.java
@@ -0,0 +1,72 @@
+package com.whyc.pojo;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+import lombok.ToString;
+
+import java.util.Date;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+@ToString
+@ApiModel(value="鍗曚綋", description="")
+@TableName(schema = "db_batt",value = "mon_inf")
+public class MonInf {
+ @TableField("mon_id")
+ @ApiModelProperty("鍗曚綋缂栧彿")
+ private Integer monId;
+
+ @TableField("batt_type")
+ @ApiModelProperty("鍗曚綋绫诲瀷")
+ private String battType;
+
+ @TableField("mon_vol")
+ @ApiModelProperty("鏍囩О鐢靛帇")
+ private Float monVol;
+
+ @TableField("mon_model")
+ @ApiModelProperty("鍗曚綋鍝佺墝")
+ private String monModel;
+
+ @TableField("mon_inuse_year")
+ @ApiModelProperty("浣跨敤骞撮檺")
+ private Integer monInuseYear;
+
+ @TableField("mon_cap")
+ @ApiModelProperty("鏍囩О瀹归噺")
+ private Float monCap;
+
+ @TableField("product_time")
+ @JsonFormat(pattern = "yyyy-MM-dd")
+ @ApiModelProperty("鍑哄満鏃ユ湡")
+ private Date productTime;
+
+ @TableField("mon_type")
+ @ApiModelProperty("搴撲綅绫诲瀷")
+ private String monType;
+
+ @TableField("local_row")
+ @ApiModelProperty("灞�")
+ private String localRow;
+
+ @TableField("local_col")
+ @ApiModelProperty("鍒�")
+ private String localCol;
+
+ @TableField("addres_num")
+ @ApiModelProperty("搴撲綅缂栧彿")
+ private String addresNum;
+
+ @TableField("laid_up_time")
+ @JsonFormat(pattern = "yyyy-MM-dd")
+ @ApiModelProperty("鍏ュ簱鏃堕棿")
+ private Date laidUpTime;
+
+}
\ No newline at end of file
diff --git a/src/main/java/com/whyc/service/MonInfService.java b/src/main/java/com/whyc/service/MonInfService.java
new file mode 100644
index 0000000..0a023d3
--- /dev/null
+++ b/src/main/java/com/whyc/service/MonInfService.java
@@ -0,0 +1,79 @@
+package com.whyc.service;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
+import com.github.pagehelper.PageHelper;
+import com.github.pagehelper.PageInfo;
+import com.whyc.dto.Response;
+import com.whyc.mapper.MonInfMapper;
+import com.whyc.pojo.MonInf;
+import com.whyc.util.ActionUtil;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import java.util.Date;
+import java.util.List;
+
+@Service
+public class MonInfService {
+ @Autowired(required = false)
+ private MonInfMapper mapper;
+ //鍏ュ簱
+ public Response addLaidUp(MonInf monInf) {
+ //鐢熸垚鍏ュ簱鍗曚綋缂栧彿
+ Integer monId=getMaxMonId();
+ monInf.setMonId(monId);
+ monInf.setLaidUpTime(new Date());
+ int flag=mapper.insert(monInf);
+ return new Response().set(1,flag>0,flag>0?"鍏ュ簱鎴愬姛":"鍏ュ簱澶辫触");
+ }
+ //鐢熸垚鍏ュ簱鍗曚綋缂栧彿
+ private Integer getMaxMonId() {
+ Integer monId=mapper.getMaxMonId();
+ if(monId==null){
+ monId=1000;
+ }
+ return monId+1;
+ }
+ //淇敼鍗曚綋淇℃伅
+ public Response updateMonInf(MonInf minf) {
+ UpdateWrapper wrapper=new UpdateWrapper();
+ wrapper.set("batt_type",minf.getBattType());
+ wrapper.set("mon_vol",minf.getMonVol());
+ wrapper.set("mon_model",minf.getMonModel());
+ wrapper.set("mon_cap",minf.getMonCap());
+ wrapper.set("mon_inuse_year",minf.getMonInuseYear());
+ wrapper.set("product_time",minf.getProductTime());
+ wrapper.eq("mon_id",minf.getMonId());
+ int flag=mapper.update((MonInf) ActionUtil.objeNull,wrapper);
+ return new Response().set(1,flag>0,flag>0?"淇敼鎴愬姛":"淇敼澶辫触");
+ }
+ //淇敼鍗曚綋鍒嗙被
+ public Response updateMonType(int monId, String monType) {
+ UpdateWrapper wrapper=new UpdateWrapper();
+ wrapper.set("mon_type",monType);
+ wrapper.eq("mon_id",monId);
+ int flag=mapper.update((MonInf) ActionUtil.objeNull,wrapper);
+ return new Response().set(1,flag>0,flag>0?"淇敼鎴愬姛":"淇敼澶辫触");
+ }
+ //鎶ュ簾鍗曚綋
+ public Response updateMonBad(int monId) {
+ UpdateWrapper wrapper=new UpdateWrapper();
+ wrapper.set("mon_type","-1");
+ wrapper.eq("mon_id",monId);
+ int flag=mapper.update((MonInf) ActionUtil.objeNull,wrapper);
+ return new Response().set(1,flag>0,flag>0?"鎶ュ簾鎴愬姛":"鎶ュ簾澶辫触");
+ }
+ //鏌ヨ鍗曚綋淇℃伅
+ public Response getAllMon(String monType,int pageNum,int pageSize) {
+ PageHelper.startPage(pageNum,pageSize);
+ QueryWrapper wrapper=new QueryWrapper();
+ if(monType!=null||monType.equals("")){
+ wrapper.eq("mon_type",monType);
+ }
+ wrapper.orderByAsc("mon_id");
+ List<MonInf> list=mapper.selectList(wrapper);
+ PageInfo pageInfo=new PageInfo(list);
+ return new Response().setII(1,list!=null,pageInfo,"鏌ヨ鍗曚綋淇℃伅");
+ }
+}
\ No newline at end of file
diff --git a/src/main/resources/config/application-dev.yml b/src/main/resources/config/application-dev.yml
index 9f70c49..03582f0 100644
--- a/src/main/resources/config/application-dev.yml
+++ b/src/main/resources/config/application-dev.yml
@@ -63,6 +63,8 @@
cache-enabled: false
#mybatis鏃ュ織杈撳嚭
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
+pagehelper:
+ helper-dialect: mysql
knife:
enable: true
configFile:
diff --git a/src/main/resources/config/application-prod.yml b/src/main/resources/config/application-prod.yml
index 818cd51..1acb1c0 100644
--- a/src/main/resources/config/application-prod.yml
+++ b/src/main/resources/config/application-prod.yml
@@ -52,6 +52,8 @@
cache-enabled: false
#mybatis鏃ュ織杈撳嚭
# log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
+pagehelper:
+ helper-dialect: mysql
knife:
enable: false
configFile:
diff --git a/src/main/resources/mapper/MonInfMapper.xml b/src/main/resources/mapper/MonInfMapper.xml
new file mode 100644
index 0000000..90fcfd3
--- /dev/null
+++ b/src/main/resources/mapper/MonInfMapper.xml
@@ -0,0 +1,8 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.whyc.mapper.MonInfMapper">
+
+ <select id="getMaxMonId" resultType="java.lang.Integer">
+ select max(mon_id) from db_batt.mon_inf
+ </select>
+</mapper>
\ No newline at end of file
--
Gitblit v1.9.1