diff options
Diffstat (limited to 'src/com/juick/server/TagQueries.java')
| -rw-r--r-- | src/com/juick/server/TagQueries.java | 32 |
1 files changed, 28 insertions, 4 deletions
diff --git a/src/com/juick/server/TagQueries.java b/src/com/juick/server/TagQueries.java index 54ec862d..493e8675 100644 --- a/src/com/juick/server/TagQueries.java +++ b/src/com/juick/server/TagQueries.java @@ -30,20 +30,44 @@ import java.util.ArrayList; */ public class TagQueries { + 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) { + System.err.println(e); + } finally { + Utils.finishSQL(rs, stmt); + } + + return ret; + } + public static com.juick.Tag getTag(Connection sql, String tag, boolean autoCreate) { com.juick.Tag ret = null; PreparedStatement stmt = null; ResultSet rs = null; try { - stmt = sql.prepareStatement("SELECT tag_id,name FROM tags WHERE name=?"); + stmt = sql.prepareStatement("SELECT tag_id,synonym_id,name FROM tags WHERE name=?"); stmt.setString(1, tag); rs = stmt.executeQuery(); - rs.beforeFirst(); - while (rs.next()) { + if (rs.first()) { ret = new com.juick.Tag(); ret.TID = rs.getInt(1); - ret.Name = rs.getString(2); + ret.SynonymID = rs.getInt(2); + ret.Name = rs.getString(3); } } catch (SQLException e) { System.err.println(e); |