public ArrayList<BeanRecursos> getRecursos(int tipusRecurs) {
        ArrayList<BeanRecursos> list = new ArrayList<BeanRecursos>();

        if (tipusRecurs == BeanReserves.AULES) {
            String SQL1 = "SELECT * FROM sig_espais where reservable='1'";


            try {
                Statement st = client.getMysql().createStatement();
                ResultSet rs1 = client.getMysql().getResultSet(SQL1, st);
                while (rs1 != null && rs1.next()) {

                    list.add(new BeanRecursos(rs1.getString("descripcio"), rs1.getString("aula")));
                }
                if (rs1 != null) {
                    rs1.close();
                    st.close();
                }
            } catch (SQLException ex) {
                Logger.getLogger(ReservesCollection.class.getName()).log(Level.SEVERE, null, ex);
            }
        } else {
            String SQL1 = "SELECT id,CONCAT(material,' ',ubicacio) as item FROM sig_reserves_material";

            try {
                Statement st = client.getMysql().createStatement();
                ResultSet rs1 = client.getMysql().getResultSet(SQL1, st);
                while (rs1 != null && rs1.next()) {

                    list.add(new BeanRecursos(rs1.getString("item"),
                            rs1.getString("id")));
                }
                if (rs1 != null) {
                    rs1.close();
                    st.close();
                }
            } catch (SQLException ex) {
                Logger.getLogger(ReservesCollection.class.getName()).log(Level.SEVERE, null, ex);
            }
        }

        return list;
    }