rename "*-???.*" "*////.*"

SELECT units.model, works.task, works.opened 
FROM works inner join units on works.unit_id = units.id_unit
where opened = 1;

CriteriaQuery<Work> cq = builder.createQuery(Work.class);
Root<Work> rootW = cq.from(Work.class);
rootW.join("unit");
cq.where(builder.equal(rootW.get("opened"), true));
Query<Work> query1 = session.createQuery(cq);
List<Work> resultList1 = query1.getResultList();

resultList1.forEach((w)->{ System.out.println("\t"+ w.getTask()); });

// Unit.java
@Entity
@Table(name = "units")
public class Unit {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id_unit")
    private int idUnit;
    
    @Column(name = "model")
    private String model;
    
    @OneToMany(mappedBy = "unit", cascade = CascadeType.ALL)
    private List<Work> works = new ArrayList<Work>();

       // далі ідуть Getters i Setters}

// Work.java
@Entity
@Table(name = "works")
public class Work {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id_work")
    private int idWork;
    
    @Column(name = "task")
    private String task;
    
    @Column(name = "opened")
    private boolean opened;
    
    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "unit_id")
    private Unit unit;
}

try {
    String dbfPath = "2309201.dbf";
    InputStream inputStream = new FileInputStream(dbfPath);
    InputStreamReader isr = new InputStreamReader(inputStream);
    DBFReader reader = new DBFReader(inputStream);
    Object[] rowObjects; BigDecimal price = new BigDecimal(0); String description = "", ansiString = "";
    while ((rowObjects = reader.nextRecord()) != null) {
        price = (BigDecimal) rowObjects[12];
        description = (String) rowObjects[4];
        ansiString = new String(description.getBytes("UTF8"), "Windows-1251");
        System.out.println("сума: "+price+ "| desc: "+description+" | "+ ansiString);
    }
    inputStream.close();
    JFrame f = new JFrame();
    f.setBounds(100, 100, 700, 500);
    JTextArea textArea = new JTextArea();
    textArea.setText("сума: "+ price +"\nопис: "+ description+"\n"+ansiString);
    f.add(textArea);
    f.setVisible(true);
    f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
} catch (Exception e) {
    e.printStackTrace();
}