Review

finding-8

database/SocialNetworkDatabasePosts.java

isFFAPostCreator(Connection, String, int)

class SocialNetworkDatabasePosts {
	public static Boolean isFFAPostCreator(Connection conn, String username, int post) {
		Boolean isCreator = null;
		String query = "SELECT postedby FROM freeforall.posts " +
				"WHERE pid = ?";
		PreparedStatement pstmt = null;
		ResultSet result = null;
		try {
			pstmt = conn.prepareStatement(query);
			pstmt.setInt(1, post);
			result = pstmt.executeQuery();
			if (result.next()) {
				isCreator = new Boolean(username.equals(result.getString("postedby")));
			}
		} catch (SQLException e) {
			isCreator = null;
		} finally {
			DBManager.closeResultSet(result);
			DBManager.closePreparedStatement(pstmt);
		}
		return isCreator;
	}

}