package com.cao.dao;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

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

import com.cao.model.Switchinfo;


public class SwitchinfoDao 
{
    private	SessionFactory sessionFactory;
    private Session session;
    private    Transaction tx;
	public void opensessionfactory()
	{
		sessionFactory = new Configuration().configure().buildSessionFactory();
		session = sessionFactory.openSession(); 
        tx= session.beginTransaction(); 
    }
	public void closesessionfactory()
	{
		tx.commit(); 
        session.close(); 
        sessionFactory.close();
	}
	public List getSwitchinfolist()
	{
		List list=new ArrayList();
		opensessionfactory();
		list=session.createQuery
	        ("from Switchinfo").list();
		closesessionfactory();
		System.out.println("this"+list);
	    return list;
	}
	public void add(Switchinfo e)
	{
		opensessionfactory();
		session.save(e);
		closesessionfactory();
		
	}
	public void delete(int id)
	{
		opensessionfactory();
		Switchinfo s1=new Switchinfo();
		s1.setSid(id);
		session.delete(s1);
		closesessionfactory();
	}
	public void update(Switchinfo e)
	{
		opensessionfactory();
		session.saveOrUpdate(e);
		closesessionfactory();
	}
	public Switchinfo getSwitchinfo(int id)
	{
		opensessionfactory();
		Switchinfo e=(Switchinfo) session.get(Switchinfo.class, id);
		closesessionfactory();
		return e;
	}


}