Форум программистов [Powered by Invision Power Board]

Код


package reservation.bean;

import javax.persistence.*;
import java.io.Serializable;
import java.util.Date;
import java.util.List;

@javax.persistence.Entity
@Table(name = "reservation")
@SecondaryTable(name="testmachine")
@NamedQueries({
@NamedQuery(
        name = "getActiveReservationByStatus",
        query = "select reservation from Reservation reservation where reservation.status=:status"),
@NamedQuery(
        name = "getMachineNameByActiveReservation",
        query = "select reservation.userId, machine.machineName " +
                "from Reservation reservation, Machine machine " +
                "where reservation.id = machine.id and reservation.status=:status"),  

       })

public class Reservation implements Serializable {
    @javax.persistence.Id
    @Column(name = "reservation_id")
    @javax.persistence.GeneratedValue(strategy = javax.persistence.GenerationType.AUTO)
    private int id;
    @Column(name = "reservation_status")
    private int status = 1;
    @Column(name = "user_id")
    private int userId;
    
    @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy="reservation")
    private List<Machine> machineResultList;   

    public Reservation() {
    }

    public void setId(int id) {
        this.id = id;
    }

    public int getId() {
        return id;
    }

    public void setStatus(int status) {
        this.status = status;
    }

    public int getStatus() {
        return status;
    }

     public void setUserId(int userId) {
        this.userId = userId;
    }

    public int getUserId() {
        return userId;
    }
}

Код


public ArrayList<Reservation> getActiveReservationByStatus(int statusId) {     
        Query query = entityManager.createNamedQuery("getActiveReservationByStatus");
        query.setParameter("status", statusId);
        return (ArrayList<Reservation>) query.getResultList();
    }

Код


public ArrayList<Reservation> getMachineNameByActiveReservation(int stateId) {     
        Query query = entityManager.createNamedQuery("getMachineNameByActiveReservation");
        query.setParameter("status", stateId);
        return (ArrayList<Reservation>) query.getResultList();
    }