aboutsummaryrefslogtreecommitdiff
path: root/src/com/juick/server/TagQueries.java
diff options
context:
space:
mode:
Diffstat (limited to 'src/com/juick/server/TagQueries.java')
-rw-r--r--src/com/juick/server/TagQueries.java19
1 files changed, 3 insertions, 16 deletions
diff --git a/src/com/juick/server/TagQueries.java b/src/com/juick/server/TagQueries.java
index 7d78e345..e811caf4 100644
--- a/src/com/juick/server/TagQueries.java
+++ b/src/com/juick/server/TagQueries.java
@@ -31,24 +31,11 @@ import java.util.ArrayList;
public class TagQueries {
public static int getTagID(Connection sql, String tag, boolean autoCreate) {
- int tid = 0;
-
- PreparedStatement stmt = null;
- ResultSet rs = null;
- try {
- stmt = sql.prepareStatement("SELECT tag_id FROM tags WHERE name=?");
- stmt.setString(1, tag);
- rs = stmt.executeQuery();
- if (rs.first()) {
- tid = rs.getInt(1);
- }
- } catch (SQLException e) {
- System.err.println(e);
- } finally {
- Utils.finishSQL(rs, stmt);
- }
+ int tid = SQLHelpers.getInt(sql, "SELECT tag_id FROM tags WHERE name=?", tag, 0);
if (tid == 0 && autoCreate) {
+ PreparedStatement stmt = null;
+ ResultSet rs = null;
try {
stmt = sql.prepareStatement("INSERT INTO tags(name) VALUES (?)", Statement.RETURN_GENERATED_KEYS);
stmt.setString(1, tag);