From 9e74359927be420258b454e8914d7cf4f6a11bf9 Mon Sep 17 00:00:00 2001
From: 沈斌 <bluelazysb@hotmail.com>
Date: Wed, 28 Feb 2018 16:26:10 +0800
Subject: [PATCH] test
---
src/main/java/com/moral/monitor/controller/ApiController.java | 33 ++++++++++++++++++++++++++++++++-
1 files changed, 32 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/moral/monitor/controller/ApiController.java b/src/main/java/com/moral/monitor/controller/ApiController.java
index be0e022..196d33e 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,38 @@
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://47.96.19.115: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 + "'";
+ 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")
--
Gitblit v1.8.0