public ArrayList<String> query1(int studentid) {
		try{
        	openDatabase();
		}catch(Exception e){}
		String query = "SELECT name FROM t8005t2 .modules WHERE ID IN (SELECT ID FROM t8005t2 .takes WHERE StudentID = "
				+ studentid + ")";
		ArrayList<String> modules = new ArrayList<String>();
		try {
			stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(query);
			// while there are still results, loop through and get the name, add
			// it to the module array.
			while (rs.next()) {
				String module = rs.getString("name");
				modules.add(module);
			}
		} catch (Exception e) {
			System.err.println("Problem executing query1");
			System.err.println(e.getMessage());
		}
		
		try{
        	closeDatabase();
		}catch(Exception e){}
		return modules;
	}