From 710bdd092b193704fabdf6136bd5bffe0d8e01e7 Mon Sep 17 00:00:00 2001 From: Anton Tananaev Date: Wed, 16 Nov 2011 11:37:11 +0000 Subject: --- src/org/traccar/Server.java | 38 ++++++++++------------ .../protocol/xexun2/Xexun2ProtocolDecoder.java | 3 -- 2 files changed, 18 insertions(+), 23 deletions(-) (limited to 'src/org') diff --git a/src/org/traccar/Server.java b/src/org/traccar/Server.java index 305edecde..c7d52337e 100644 --- a/src/org/traccar/Server.java +++ b/src/org/traccar/Server.java @@ -28,6 +28,7 @@ import java.sql.ResultSet; import java.sql.SQLException; import java.text.DateFormat; import java.text.SimpleDateFormat; +import java.util.Calendar; import java.util.Date; import java.util.logging.Logger; import java.util.logging.FileHandler; @@ -102,10 +103,10 @@ public class Server implements DataManager { * Database connection */ private Connection connection; - - private NamedParameterStatement selectDevice; - - private NamedParameterStatement insertPosition; + + private String selectDeviceQuery; + + private String insertPositionQuery; /** * Init database @@ -130,27 +131,23 @@ public class Server implements DataManager { connection = DriverManager.getConnection(url); } - // Init statements - String selectDeviceQuery = properties.getProperty("database.selectDevice"); - if (selectDeviceQuery != null) { - selectDevice = new NamedParameterStatement(connection, selectDeviceQuery); - } - - String insertPositionQuery = properties.getProperty("database.insertPosition"); - if (insertPositionQuery != null) { - insertPosition = new NamedParameterStatement(connection, insertPositionQuery); - } + selectDeviceQuery = properties.getProperty("database.selectDevice"); + insertPositionQuery = properties.getProperty("database.insertPosition"); } /** * Devices */ private Map devices; + private Calendar devicesLastUpdate; + private Long devicesListRefreshDelay = new Long(5 * 60 * 1000); public synchronized List getDevices() throws SQLException { List deviceList = new LinkedList(); + NamedParameterStatement selectDevice = + new NamedParameterStatement(connection, selectDeviceQuery); ResultSet result = selectDevice.executeQuery(); while (result.next()) { Device device = new Device(); @@ -161,18 +158,16 @@ public class Server implements DataManager { return deviceList; } - + public Device getDeviceByImei(String imei) throws SQLException { - - // Init device list - if (devices == null) { + + if ((devices == null) || (Calendar.getInstance().getTimeInMillis() - devicesLastUpdate.getTimeInMillis() > devicesListRefreshDelay)) { devices = new HashMap(); - List deviceList = getDevices(); - for (Object device: deviceList) { devices.put(((Device) device).getImei(), device); } + devicesLastUpdate = Calendar.getInstance(); } return (Device) devices.get(imei); @@ -180,6 +175,9 @@ public class Server implements DataManager { public synchronized void setPosition(Position position) throws SQLException { + NamedParameterStatement insertPosition = + new NamedParameterStatement(connection, insertPositionQuery); + insertPosition.setLong("device_id", position.getDeviceId()); insertPosition.setTimestamp("time", position.getTime()); insertPosition.setBoolean("valid", position.getValid()); diff --git a/src/org/traccar/protocol/xexun2/Xexun2ProtocolDecoder.java b/src/org/traccar/protocol/xexun2/Xexun2ProtocolDecoder.java index f7ff9f528..8f1b53328 100644 --- a/src/org/traccar/protocol/xexun2/Xexun2ProtocolDecoder.java +++ b/src/org/traccar/protocol/xexun2/Xexun2ProtocolDecoder.java @@ -78,9 +78,6 @@ public class Xexun2ProtocolDecoder extends OneToOneDecoder { "F:(\\d+.\\d+)V," + // Power ".*"); - //"111111120009,+436763737552,GPRMC,120009.590,A,4639.6774,N,01418.5737,E,0.00,0.00,111111" - //",,,A*68,F,, imei:012207000694569,04,481.2,F:4.15V,0,139,2689,232,03,2725,0576" - /** * Decode message */ -- cgit v1.2.3