Review

finding-20

/mubench/checkouts/chensun/cf23b99/build/CS5430/src/database/SocialNetworkDatabasePosts.java

postExists(Connection, String, String, int)

class SocialNetworkDatabasePosts {
	/**
	 * Verifies whether a post exists in the given board (and region).
	 */
	public static Boolean postExists(Connection conn, String boardName, String regionName, int postNum) {
		PreparedStatement pstmt = null;
		ResultSet postResult = null;
		String getPost = "";
		if (boardName.equals("freeforall")) {
			getPost = "SELECT * FROM freeforall.posts " +
			"WHERE pid = ?";
		}
		else {
			getPost = "SELECT * FROM " + boardName + ".posts " +
					"WHERE pid = ? AND rname = ?";
		}
		
		Boolean postExists = null;
		try {
			pstmt = conn.prepareStatement(getPost);
			pstmt.setInt(1, postNum);
			if (!boardName.equals("freeforall")) {
				pstmt.setString(2, regionName);
			}
			postResult = pstmt.executeQuery();
			postExists = new Boolean(postResult.next());
		}
		catch (SQLException e) {
			e.printStackTrace();
			System.out.println(e.getSQLState());
		}
		finally {
			DBManager.closePreparedStatement(pstmt);
		}
		return postExists;
	}
}