package roseindia.tutorial.hibernate;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class DeleteHQLExample {
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub	
		Session sess = null;
		try {
			SessionFactory fact = new Configuration().configure().buildSessionFactory();
			sess = fact.openSession();
			String hql = "delete from Insurance insurance where id = 2";
			Query query = sess.createQuery(hql);
			int row = query.executeUpdate();
			if (row == 0){
				System.out.println("Doesn't deleted any row!");
			}
			else{
				System.out.println("Deleted Row: " + row);
			}
			sess.close();
		}
		catch(Exception e){
			System.out.println(e.getMessage());
		}
	}
}