public static void deletePost(Long post_ID) throws SQLException { Post post = null; String deletePostStr = String.format("DELETE from %s where postid = ?", Post.dquote(POST), post_ID); Connection conn = null; PreparedStatement deleteP = null; if (post_ID != null) { try { conn = DB.getConnection(); deleteP = conn.prepareStatement(deletePostStr); ResultSet rs = deleteP.executeQuery(); if (rs.next()) { Logger.debug("Failed to delete the Post."); } deleteP.close(); conn.close(); } catch (SQLException e) { Logger.debug("Failed while trying to delete the post."); } } else { Logger.debug("Post id is null."); } }
/** * FindById Searches the database for a Group object by the object id. * * @param connection The jdbc connection * @param id The id to select by */ public static Post FindByID(Long post_ID) throws SQLException { Post post = null; PreparedStatement findPostId = null; Connection conn = null; String sql = String.format("SELECT * from %s where postid = ?", Post.dquote(POST), post_ID); if (post_ID != null) { try { conn = DB.getConnection(); findPostId = conn.prepareStatement(sql); findPostId.setLong(1, post_ID); ResultSet rs = findPostId.executeQuery(); if (rs.next()) { post = new Post( rs.getString(Post.CONTENT), rs.getString(Post.TYPE), rs.getTimestamp(Post.TIMESTAMP), rs.getLong(Post.USER_ID), rs.getLong(Post.WALL_ID), rs.getLong(Post.POST_ID)); } findPostId.close(); conn.close(); return post; } catch (SQLException e) { Logger.debug("Error retrieving post.", e); } } return post; }