From 369454bcdbdd0c6fb0fa7ac6ec19112b9b6a179e Mon Sep 17 00:00:00 2001
From: fengxiang <110431245@qq.com>
Date: Mon, 26 Mar 2018 14:03:12 +0800
Subject: [PATCH] 数据查询 sql查询优化,一次带出 多项数据
---
src/main/java/com/moral/controller/MonitorPointController.java | 22 ++++++++++++++++++++++
1 files changed, 22 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/moral/controller/MonitorPointController.java b/src/main/java/com/moral/controller/MonitorPointController.java
index 5769ac9..8076b91 100644
--- a/src/main/java/com/moral/controller/MonitorPointController.java
+++ b/src/main/java/com/moral/controller/MonitorPointController.java
@@ -6,6 +6,8 @@
import com.moral.service.MonitorPointService;
import org.springframework.web.bind.annotation.*;
+import java.util.List;
+
import javax.annotation.Resource;
@@ -25,10 +27,30 @@
ResultBean resultBean = new ResultBean(ResultBean.SUCCESS);
return resultBean;
}
+
+ /**
+ * ������ ���������id ������ ���������
+ * @param id
+ * @return
+ */
+ @GetMapping("get-by-id")
+ public ResultBean getById(Integer id){
+ MonitorPoint monitorPoint = monitorPointService.queryWithRelationById(id);
+ ResultBean resultBean = new ResultBean(ResultBean.SUCCESS);
+ resultBean.setData(monitorPoint);
+ return resultBean;
+ }
@PostMapping("add-or-modify")
public ResultBean addOrModify(@RequestBody MonitorPoint monitorPoint){
monitorPointService.addOrModify(monitorPoint);
ResultBean resultBean = new ResultBean(ResultBean.SUCCESS);
return resultBean;
}
+
+ @GetMapping("list/{name}")
+ public ResultBean<List<MonitorPoint>> getMonitorPointsByName(@PathVariable("name") String name) {
+ List<MonitorPoint> monitorPoints = monitorPointService.getMonitorPointsByName(name);
+ return new ResultBean<List<MonitorPoint>>(monitorPoints);
+ }
+
}
--
Gitblit v1.8.0