package com.cao.test;

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 ProTset 
{
	public static void main(String args[])
	{
		SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
		
		Session session = sessionFactory.openSession(); 
        Transaction tx= session.beginTransaction(); 
        List list=new ArrayList();
        list=session.createQuery
        ("from Portst").list();
        Iterator it=list.iterator();
        
        
        
        List<Prot> list2=new ArrayList<Prot>();
        
        while(it.hasNext())
        {
        	Portst s1=(Portst)it.next();
            System.out.println(s1.getSwitchinfo().getSid());
            Prot p1=new Prot();
            p1.setPid(s1.getPid());
            p1.setPlink(s1.getPlink());
            p1.setPportNo(s1.getPportNo());
            p1.setPstate(s1.getPstate());
            p1.setSid(s1.getSwitchinfo().getSid());
            list2.add(p1);
            
        }
        tx.commit(); 
        session.close(); 
        sessionFactory.close();
        
        Iterator it2=list2.iterator();
        while(it2.hasNext())
        {
        	Prot p1=(Prot)it2.next();
        	System.out.println(p1.getSid());
        	
        }
        ToJson a=new ToJson();
    	String str=a.list2json(list2);
    	System.out.println(str);
        
	}

}