@SuppressWarnings("unused")
	public static Course constructCourseObject(String cID) {
		// Method variables
		Course course = null;
		ResultSet rs = null;
		// Course variables
		String courseName = null, courseID = null, instructorName = null;
		int instructorID;
		Date startDate = null, endDate = null;
		Instructor ins = null;
		// TeachingAssistant variables
		ArrayList<TATM> markers = new ArrayList<TATM>();
		int taEID;
		String taEName = null;
		// Students variables
		ArrayList<Student> students = new ArrayList<Student>();
		int sID;
		String sName = null;
		// Activities variables
		ArrayList<Activity> activities = new ArrayList<Activity>();
		String aName = null, aDesc = null, sSolnPath = null, solnPath = null;
		String aLang;
		boolean groupAct, aType;
		// Course table
		rs = accessCourse(cID);
		try {
			rs.next();
			// Listed loosely in Course constructor's order
			courseName = rs.getNString("CourseName");
			courseID = cID; // rs.getNString("CourseID");
			instructorName = rs.getNString("InstructorName");
			instructorID = rs.getInt("InstructorID");
			startDate = rs.getDate("StartDate");
			endDate = rs.getDate("EndDate");
			String[] names = instructorName.split("\\s+");
			String fname = names[0];
			String lname = "";
			if (names.length > 1)
				lname = names[1];
			ins = new Instructor(fname, lname, instructorID, null, null);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		// Now to put it all together
		course = new Course(courseName, cID, ins, startDate.toString(),
				endDate.toString());
		// TeachingAssistant table
		rs = accessTAs(cID);
		if (rs != null) {
			try {
				while (rs.next()) {
					taEID = rs.getInt("EmployeeID");
					taEName = rs.getNString("EmployeeName");
					System.out.println(taEName);
					String[] names = taEName.split("\\s+");
					String fname = names[0];
					String lname = names[1];
					TATM temp = new TATM(fname, lname, taEID, null, null);
					course.addMarker(temp);
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}

		// Students table
		// rs = accessStudentList(cID);
		// if (rs != null) {
		// try {
		// while (rs.next()) {
		// sID = rs.getInt("StudentID");
		// sName = rs.getNString("StudentName");
		// String[] names = sName.split("\\s+");
		// String fname = names[0];
		// String lname = names[1];
		// Student temp = new Student();
		// course.addStudent(temp);
		// }
		// } catch (SQLException e) {
		// // TODO Auto-generated catch block
		// e.printStackTrace();
		// }
		// }
		// Activities table
		rs = accessCourseActivities(cID);
		if (rs != null) {
			try {
				while (rs.next()) {
					aName = rs.getNString("ActivityName");
					aDesc = rs.getNString("ActivityDesc");
					sSolnPath = rs.getNString("StudentSolnPath");
					solnPath = rs.getNString("SolnPath");
					aLang = rs.getNString("ActivityLang");
					aType = rs.getBoolean("ActivityType");
					groupAct = rs.getBoolean("GroupAct");
					int numTests = rs.getInt("NumTests");
					Date dueDate = rs.getDate("DueDate");
					Activity temp = new Activity(aName, aDesc, sSolnPath,
							solnPath, aLang, dueDate.toString(), aType,
							groupAct, numTests);
					course.addActivity(temp);
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		// c is a complete
		return course;
	}