Review

finding-1

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

addFFAParticipipant(Connection, int, String, String)

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;
	}
}

class SocialNetworkDatabasePosts {
	public static int addFFAParticipipant(Connection conn, int post, String username, String priv) {
		int status = 0;
		String query = "INSERT INTO freeforall.postprivileges (pid, username, privilege) " +
				"VALUES (?, ?, ?)";
		PreparedStatement pstmt = null;
		try {
			pstmt = conn.prepareStatement(query);
			pstmt.setInt(1, post);
			pstmt.setString(2, username);
			pstmt.setString(3, priv);
			status = pstmt.executeUpdate();
		} catch (SQLException e) {
			status = 0;
		}
		return status;
	}
}