nord vpnnord vpn
Ad

ReservationDao

mail@pastecode.io avatar
unknown
plain_text
a month ago
1.8 kB
5
Indexable
Never
public List<Reservation> getReservationHistory(int staffid) {
        List<Reservation> list = new ArrayList<>();
        String sql = "select Reservation.ID, UserAccount.Name, Service.ServiceName, ChildrenInformation.Name, Service.Price, ReservationDate, Schedule.WorkDay, Schedule.Slot, Reservation.Status\n"
                + "from Reservation\n"
                + "INNER JOIN Schedule ON Schedule.Id = Reservation.ScheduleId\n"
                + "INNER JOIN EmployeeAccount ON Schedule.DoctorId = EmployeeAccount.ID\n"
                + "INNER JOIN UserAccount ON Reservation.CustomerID = UserAccount.ID\n"
                + "INNER JOIN Service ON Schedule.ServiceId = Service.ServiceID\n"
                + "INNER JOIN ChildrenInformation ON Reservation.ID = ChildrenInformation.ReservationID\n"
                + "where Schedule.DoctorId = ? and Reservation.Status = 'Completed'";
        try {
            PreparedStatement st = connection.prepareStatement(sql);
            st.setInt(1, staffid);
            ResultSet rs = st.executeQuery();
            while (rs.next()) {
                Reservation re = new Reservation();
                re.setReservationId(rs.getInt(1));
                re.setCustomerName(rs.getString(2));
                re.setServiceName(rs.getString(3));
                re.setPatientName(rs.getString(4));
                re.setCosts(rs.getInt(5));
                re.setReservedDate(rs.getDate(6));
                re.setWorkday(rs.getDate(7));
                re.setSlot(rs.getInt(8));
                re.setStatus(rs.getString(9));
                list.add(re);
            }
        } catch (Exception e) {
            System.out.println(e);
        }
        return list;
    }

nord vpnnord vpn
Ad