From 03cdc1111aa07041d635840eb30433cbb980accf Mon Sep 17 00:00:00 2001
From: 沈斌 <bluelazysb@hotmail.com>
Date: Wed, 28 Feb 2018 16:44:48 +0800
Subject: [PATCH] test
---
src/main/java/com/moral/monitor/controller/ApiController.java | 36 ++++++++++++++++++++++++++++++++++--
1 files changed, 34 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/moral/monitor/controller/ApiController.java b/src/main/java/com/moral/monitor/controller/ApiController.java
index 8d813d8..de8f3dc 100644
--- a/src/main/java/com/moral/monitor/controller/ApiController.java
+++ b/src/main/java/com/moral/monitor/controller/ApiController.java
@@ -1,5 +1,9 @@
package com.moral.monitor.controller;
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.SQLException;
+import java.sql.Statement;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@@ -99,11 +103,39 @@
equipmentService.updateByMac(equipment);
apiData.setMessage("������������������");
apiData.setErrno(0);
+
+ /////////////////////////////////////////////////////////
+ // ������ - ������������������������
+ updateLocation(device_name, address, mac, longitude, latitude);
+ /////////////////////////////////////////////////////////
}
return apiData;
}
-
+ public void updateLocation(String device, String address, String mac, String lng, String lat) {
+ Connection conn = null;
+ String sql;
+ String url = "jdbc:mysql://172.16.206.7:3306/monitor_db?characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC&user=root&password=xOlx8z9L7Pt6y9YI";
+ try {
+ Class.forName("com.mysql.jdbc.Driver");
+ conn = DriverManager.getConnection(url);
+ Statement stmt = conn.createStatement();
+ sql = "UPDATE device SET `name`='" + device + "', address='" + address + "', longitude='" + lng + "', latitude='" + lat + "' WHERE mac='" + mac + "'";
+ System.out.println(sql);
+ int result = stmt.executeUpdate(sql);
+ System.out.println("Update the location of the equipment: " + result);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } catch (Exception e) {
+ e.printStackTrace();
+ } finally {
+ try {
+ conn.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
+ }
//1������
@RequestMapping(value = "accountlogin")
@@ -527,7 +559,7 @@
try {
if(!StringUtils.isEmpty(areaName)) {
MonitorPointExample example = new MonitorPointExample();
- example.or().andTbAreaNameEqualTo(areaName);
+// example.or().andTbAreaNameEqualTo(areaName);
List<MonitorPoint> list = monitorpointService.queryListByExample(example);
if(list!=null&&list.size()>0) {
apiData.setErrno(0);
--
Gitblit v1.8.0