コード例 #1
0
  public MessageThread loadMessageThread(int threadId) throws SQLException {

    if (connection == null) {
      this.initConnection();
    }

    String query = "select * from MessageThread where id = ?";
    PreparedStatement statement = connection.prepareStatement(query);
    statement.setInt(1, threadId);

    MessageThread thread = null;

    ResultSet set = statement.executeQuery();
    if (set.next()) {
      thread = new MessageThread();

      thread.setId(set.getInt("id"));
      thread.setName(set.getString("name"));
      thread.setUrl(set.getString("url"));
    }

    set.close();
    statement.close();

    return thread;
  }
コード例 #2
0
  public MessageThread loadMessageThreadByName(String name) {

    if (name == null) return null;

    if (connection == null) {
      this.initConnection();
    }

    try {
      String query = "select * from MessageThread where name like ?";
      PreparedStatement statement = connection.prepareStatement(query);
      statement.setString(1, name);

      MessageThread thread = null;

      ResultSet set = statement.executeQuery();
      if (set.next()) {
        thread = new MessageThread();

        thread.setId(set.getInt("id"));
        thread.setName(set.getString("name"));
        thread.setUrl(set.getString("url"));
      }

      set.close();
      statement.close();

      return thread;

    } catch (SQLException e) {
      e.printStackTrace();
    }

    return null;
  }
コード例 #3
0
  public MessageThread getMessageThread(int messageId) throws IllegalArgumentException {

    try {
      Statement s0 = connection.createStatement();
      ResultSet set0 =
          s0.executeQuery(
              "select t.* from MessageThread t, Message m where m.id = "
                  + messageId
                  + " and m.threadID = t.id");
      if (!set0.next()) throw new IllegalArgumentException("Invalid message id : " + messageId);

      MessageThread thread = new MessageThread();
      thread.setId(set0.getInt("id"));
      thread.setMessageBoard(null);
      thread.setMessages(null);
      thread.setName(set0.getString("name"));
      thread.setUrl(set0.getString("url"));

      set0.close();
      s0.close();

      return thread;

    } catch (SQLException e) {
      e.printStackTrace();
    }

    return null;
  }