Review

finding-9

server/SocialNetworkAdmin.java

deleteUser(Connection, String)

class SocialNetworkAdmin {
	public static String deleteUser(Connection conn, String username) {
		String success = "print " + username + " has been deleted from the system.;";
		String error = "print Database Error while deleting " + username + ". Please try again or contact the System Admin.;";
		try {
			conn.setAutoCommit(false);
		} catch (SQLException e) {
			return error;
		}
		int deleteStatus = DatabaseAdmin.deleteUser(conn, username);
		int sideEffectStatus1 = DatabaseAdmin.replaceBoardManager(conn, username);
		int sideEffectStatus2 = DatabaseAdmin.deletionBoardDBEffects(conn, username);
		if (DEBUG) System.err.printf("Deleting user:\ndeleteStatus = %d, sideES1 = %d, sideES2 = %d\n", 
				deleteStatus, sideEffectStatus1, sideEffectStatus2);
		try {
			if (deleteStatus == 1 && sideEffectStatus1 >= 0 && sideEffectStatus2 >= 0) {
				conn.commit();
				conn.setAutoCommit(true);
				return success;
			} else {
				conn.rollback();
				conn.setAutoCommit(true);
				return error;
			}
		} catch (SQLException e) {
			return error;
		}
	}

}