Review

finding-1

database/SocialNetworkDatabaseRegions.java

regionExists(Connection, String, String)

class SocialNetworkDatabaseRegions {
	/**
	 * Determine whether the region exists in this board.
	 * ASSUMES THE BOARD EXISTS.
	 */
	public static Boolean regionExists(Connection conn, String boardName, String regionName) {
		String getRegion = "SELECT * FROM " + boardName + ".regions WHERE rname = ?";
		PreparedStatement pstmt = null;
		ResultSet regionResult = null;
		Boolean regionExists = null;
		try {
			pstmt = conn.prepareStatement(getRegion);
			pstmt.setString(1, regionName);
			regionResult = pstmt.executeQuery();
			regionExists = new Boolean(regionResult.next());
		}
		catch (SQLException e) {
			e.printStackTrace();
		}
		finally {
			DBManager.closePreparedStatement(pstmt);
			DBManager.closeResultSet(regionResult);
		}
		return regionExists;
	}

}