more spring-jdbc

1 files changed, 4 insertions, 19 deletions

diff --git a/src/main/java/com/juick/server/TagQueries.java b/src/main/java/com/juick/server/TagQueries.java
index d2159b5a..0094fc22 100644
--- a/src/main/java/com/juick/server/TagQueries.java
+++ b/src/main/java/com/juick/server/TagQueries.java
@@ -123,25 +123,10 @@ public class TagQueries {
                 }, uid);
     }
 
-    public static List<String> getUserBLTags(Connection sql, int uid) {
-        List<String> tags = new ArrayList<>();
-
-        PreparedStatement stmt = null;
-        ResultSet rs = null;
-        try {
-            stmt = sql.prepareStatement("SELECT tags.name FROM tags INNER JOIN bl_tags ON (bl_tags.user_id=? AND bl_tags.tag_id=tags.tag_id) ORDER BY tags.name");
-            stmt.setInt(1, uid);
-            rs = stmt.executeQuery();
-            rs.beforeFirst();
-            while (rs.next()) {
-                tags.add(rs.getString(1));
-            }
-        } catch (SQLException e) {
-            LOGGER.log(Level.SEVERE, "sql exception", e);
-        } finally {
-            Utils.finishSQL(rs, stmt);
-        }
-        return tags;
+    public static List<String> getUserBLTags(JdbcTemplate sql, int uid) {
+        return sql.queryForList("SELECT tags.name FROM tags INNER JOIN bl_tags " +
+                        "ON (bl_tags.user_id=? AND bl_tags.tag_id=tags.tag_id) ORDER BY tags.name",
+                String.class, uid);
     }
 
     public static List<String> getPopularTags(JdbcTemplate sql) {