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.Portst;



public class ProtstDao 
{
	    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 getlist(int id)
		{
			List list=new ArrayList();
			opensessionfactory();
			list=session.createQuery
	        ("from Portst").list();
			closesessionfactory();
			List<ProtstBean> list2=new ArrayList<ProtstBean>();
			Iterator it=list.iterator();
			while(it.hasNext())
			{
				
				Portst s1=(Portst)it.next();
				if(s1.getSwitchinfo().getSid()==id)
				{
					ProtstBean p1=new ProtstBean();
					p1.setPid(s1.getPid());
					p1.setPlink(s1.getPlink());
					p1.setPportNo(s1.getPportNo());
					p1.setPstate(s1.getPstate());
					p1.setSid(s1.getSwitchinfo().getSid());
					list2.add(p1);
			
				}
			}
			
			
			return list2;
		}
		public void update(int id,int flag)
		{
			opensessionfactory();
			Portst e=(Portst)session.get(Portst.class, id);
			e.setPstate(flag);
			session.saveOrUpdate(e);
			closesessionfactory();
		}
}