public ArrayList<Attribute> getAttribute(int businessruleID){
        ArrayList<Attribute> attributes = new ArrayList<Attribute>();
        try {
            String sql = "select ATTRIBUTE.ATTRIBUTENAAM as ATTRIBUTENAAM,\n" +
                    " ATTRIBUTE.DBSCHEMA as DBSCHEMA,\n" +
                    " ATTRIBUTE.TABEL as TABEL,\n" +
                    " ATTRIBUTE.KOLOM as KOLOM,\n" +
                    " ATTRIBUTE.ATTRIBUTEID as ATTRIBUTEID \n" +
                    " from BUSINESSRULE_ATTRIBUTE BUSINESSRULE_ATTRIBUTE,\n" +
                    " ATTRIBUTE ATTRIBUTE \n" +
                    " where   BUSINESSRULE_ATTRIBUTE.BUSINESSRULE="+ businessruleID + "\n" +
                    " and BUSINESSRULE_ATTRIBUTE.ATTRIBUTE=ATTRIBUTE.ATTRIBUTEID";
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            while (rs.next()) {
                int attributeid = rs.getInt("ATTRIBUTEID");
                String attributenaam = rs.getString("ATTRIBUTENAAM");
                String dbschema = rs.getString("DBSCHEMA");
                String tabel = rs.getString("TABEL");
                String kolom = rs.getString("KOLOM");
                Attribute a = new Attribute(attributenaam,dbschema,tabel,kolom,attributeid);
                attributes.add(a);
            }
            stmt.close();
        } catch (Exception ex) {
            System.out.println("Kan geen attributes halen uit de database" + ex);
        }
        return attributes;
    }