From 714a267ae35354e86512288e0ac91990937f95ab Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Sat, 16 Jan 2016 18:23:21 +0300
Subject: almost working api project

---
 src/main/java/com/juick/server/TagQueries.java | 31 ++++++++------------------
 1 file changed, 9 insertions(+), 22 deletions(-)

(limited to 'src/main/java/com/juick/server/TagQueries.java')

diff --git a/src/main/java/com/juick/server/TagQueries.java b/src/main/java/com/juick/server/TagQueries.java
index 5bc87e28..22839ad0 100644
--- a/src/main/java/com/juick/server/TagQueries.java
+++ b/src/main/java/com/juick/server/TagQueries.java
@@ -40,28 +40,15 @@ public class TagQueries {
 
     private static final Logger LOGGER = Logger.getLogger(TagQueries.class.getName());
 
-    public static com.juick.Tag getTag(Connection sql, int tid) {
-        com.juick.Tag ret = null;
-
-        PreparedStatement stmt = null;
-        ResultSet rs = null;
-        try {
-            stmt = sql.prepareStatement("SELECT synonym_id,name FROM tags WHERE tag_id=?");
-            stmt.setInt(1, tid);
-            rs = stmt.executeQuery();
-            if (rs.first()) {
-                ret = new com.juick.Tag();
-                ret.TID = tid;
-                ret.SynonymID = rs.getInt(1);
-                ret.Name = rs.getString(2);
-            }
-        } catch (SQLException e) {
-            LOGGER.log(Level.SEVERE, "sql exception", e);
-        } finally {
-            Utils.finishSQL(rs, stmt);
-        }
-
-        return ret;
+    public static com.juick.Tag getTag(JdbcTemplate sql, int tid) {
+        return sql.queryForObject("SELECT synonym_id,name FROM tags WHERE tag_id=?",
+                new Object[]{tid}, (rs, num) -> {
+                    Tag ret = new Tag();
+                    ret.TID = tid;
+                    ret.SynonymID = rs.getInt(1);
+                    ret.Name = rs.getString(2);
+                    return ret;
+                });
     }
 
     public static com.juick.Tag getTag(JdbcTemplate sql, String tag, boolean autoCreate) {
-- 
cgit v1.2.3