public String roomType(String name) {
		try{
        	openDatabase();
		}catch(Exception e){}
		
		String query = "SELECT type FROM t8005t2 .modules WHERE name= '" + name + "'";
		String type = null;
		try {
			stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(query);
			while (rs.next()) {
				type = rs.getString("type");
			}
		} catch (Exception e) {
			System.err.println("Problem executing roomType query");
			System.err.println(e.getMessage());
		}
		
		try{
        	closeDatabase();
		}catch(Exception e){}
		return type;
	}