private Stat getExpediceData(Vykladka vykladka, Date datum)
queryString = "select datum, ks from vykaz v join expedice e on v.idexpedice=e.idexpedice where e.datum = ? and v.idvykladka=?";
Query q = em.createNativeQuery(queryString, Stat.class);
q.setParameter(1, datum, TemporalType.DATE);
q.setParameter(2, vykladka.getIdvykladka());
Stat stat = (Stat) q.getSingleResult();
return stat;
@Entity
public class Stat implements Serializable {
@Id
@Temporal(TemporalType.DATE)
@Column(name = "datum")
private Date datum;
@Column(name = "ks")
private Integer ks;
@Column(name = "remitenda")
private Integer remitenda;
@Column(name = "cas_zavozu")
private String casZavozu;
getters and setters
}