public List<String>  getAllComments(int pid){
    PreparedStatement stmt = null;
    Connection conn = null;
    ResultSet rs = null;
    List<String> comments = new ArrayList();
    try {
      conn = DbConnection.getConnection();
      stmt = conn.prepareStatement(GET_COMMENT_STMT);
      stmt.setInt(1, pid);
      rs = stmt.executeQuery();
      

      while(rs.next()) {
        comments.add(rs.getString(1));
      }
      
      try { stmt.close(); }
      catch (Exception e) { }
      
      return comments;
    } catch (SQLException e) {
      e.printStackTrace();
      throw new RuntimeException(e);
    } finally {
      if (rs != null) {
        try { rs.close(); }
        catch (SQLException e) { ; }
        rs = null;
      }
      
      if (stmt != null) {
        try { stmt.close(); }
        catch (SQLException e) { ; }
        stmt = null;
      }
      
      if (conn != null) {
        try { conn.close(); }
        catch (SQLException e) { ; }
        conn = null;
      }
    }



  }