From 596536b7a9efd22e8843f6cc5aeab91d39472441 Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton.tananaev@gmail.com>
Date: Thu, 12 Feb 2015 14:32:37 +1300
Subject: Add login back-end

---
 src/org/traccar/database/DataManager.java | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

(limited to 'src/org/traccar/database')

diff --git a/src/org/traccar/database/DataManager.java b/src/org/traccar/database/DataManager.java
index 602345df9..2c78a53c4 100644
--- a/src/org/traccar/database/DataManager.java
+++ b/src/org/traccar/database/DataManager.java
@@ -267,4 +267,25 @@ public class DataManager {
         }
     }
 
+    public long login(String name, String password) throws SQLException {
+
+        Connection connection = dataSource.getConnection();
+        try {
+            PreparedStatement statement = connection.prepareStatement(
+                    "SELECT id FROM users WHERE name = ? AND password = ?;");
+            try {
+                statement.setString(1, name);
+                statement.setString(2, password);
+
+                ResultSet result = statement.executeQuery();
+                result.next();
+                return result.getLong("id");
+            } finally {
+                statement.close();
+            }
+        } finally {
+            connection.close();
+        }
+    }
+
 }
-- 
cgit v1.2.3