Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package com.laborun.dao; import com.laborun.entity.*; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import java.util.Set; import org.hibernate.Criteria; import org.hibernate.Query; import org.hibernate.SQLQuery; import org.hibernate.Session; import org.hibernate.criterion.Restrictions; /** * * @author dina */ public class QueueDaoImp implements QueueDaoInt { public List<Integer> getTraineeInQueue(QueueD queue) { Session session = Connection.getConnection(); List<Trainee> Trainees = null; String sql = "select trainee_id from trainee_in_queue where queue_id = " + queue.getId(); SQLQuery query = session.createSQLQuery(sql); List results = query.list(); return results; } @Override public void setTraineeInQueue(QueueD queue, Set<TraineeInQueue> traineesInQueue) { Session session = Connection.getConnection(); session.beginTransaction(); for (TraineeInQueue traineeInQueue : traineesInQueue) { TraineeInQueue traineeCopy = new TraineeInQueue(); traineeCopy.setId(new TraineeInQueueId(traineeInQueue.getTrainee().getId(), queue.getId())); traineeCopy.setTrainee(traineeInQueue.getTrainee()); traineeCopy.setQueueD(queue); traineeCopy.setOrderNum(traineeInQueue.getOrderNum()); session.persist(traineeCopy); } session.getTransaction().commit(); } public void addNewRequest(QueueD queue) { Session session = Connection.getConnection(); session.beginTransaction(); session.persist(queue); session.getTransaction().commit(); System.out.println("data inserted"); } public void removeFromQueue(Trainee trainee, QueueD queue) { Session session = Connection.getConnection(); session.beginTransaction(); String sql = "DELETE FROM TraineeInQueue WHERE trainee_id = " + trainee.getId() + "and queue_id = " + queue.getId(); Query query = session.createQuery(sql); int row = query.executeUpdate(); session.getTransaction().commit(); System.out.println("data removed"); } }