package net.wj.proc.test;


import java.util.List;

import org.hibernate.*;
import org.hibernate.cfg.*;
import net.wj.proc.vo.*;
import org.apache.log4j.*;


public class ProcTest {

    /**
     * @param args
     */
    Logger log=Logger.getLogger(this.getClass());
    public ProcTest()
    {}
    public static void main(String[] args) {
        System.out.print("aaaaaaaaa");
        ProcTest tt=new ProcTest();
       // tt.LoadAll();
       // tt.ExampleSelect();
       tt.ExampleProc();
        
    }
    
    //得到Session,
    public Session  getSession()
    {
        try
        {
            Configuration cfg = new Configuration().configure();
            SessionFactory sf=cfg.buildSessionFactory();
            Session ss= sf.openSession();
            return ss;

        }
        catch(Exception ee)
        {
            System.out.print("失敗"+ee.getMessage());
            return null;
        }
      
    }
    //這里調我們在UserVO.hbm.xml
    //sql-query 寫上的name屬性getUser
    public void ExampleProc()
    {
        Session ss=this.getSession();
        List li=ss.getNamedQuery("getUser").list();
        for(int i=0;i<li.size();i++)
        {
            UserVO vo=(UserVO)li.get(i);
            log.info("name:"+vo.getName());
            log.info("age"+vo.getAge());
            log.info("address"+vo.getAddress());
        }
        ss.close();
    }
    //配置文件的sql查詢
    public void ExampleSelect()
    {
           Session ss=this.getSession();
           List li= ss.getNamedQuery("select").list();
        
           for(int i=0;i<li.size();i++)
           {
            UserVO vo=(UserVO)li.get(i);
            log.info("name:"+vo.getName());
            log.info("age"+vo.getAge());
            log.info("address"+vo.getAddress());
           }
           ss.close();  
    }
    
    //測試加載所有
    public void LoadAll()
    {
        Session ss=this.getSession();
        List li=ss.createQuery("from UserVO").list();
        for(int i=0;i<li.size();i++)
        {
            UserVO vo=(UserVO)li.get(i);
            log.info("name:"+vo.getName());
            log.info("age"+vo.getAge());
            log.info("address"+vo.getAddress());
        }
        ss.close();

    }
    

}