lunzi

package hb;

import net.sf.hibernate.*;
import java.util.*;

public final class UserDAO {
   	
     public static int chkUserName(String name) throws HibernateException 
     {
     	 Session hsession=HibernateUtil.currentSession();
	 Transaction tx = hsession.beginTransaction();
         int n=-1;
         int id=-2;
         String q = "from User as user where user.name='"+name+"'";

         Query query2 = hsession.createQuery (q);

		 try{
		 	 List list=query2.list();
		     n=list.size();
			 for(int i=0;i<list.size();i++)
		       {
		            User g2=(User)list.get(i);
					 id=g2.getId();
				
			   }
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}finally{
	
          tx.commit();
          HibernateUtil.closeSession();
        }return n;
          
     }
         
      public void saveName(String name) throws HibernateException 
     {
     	 Session hsession=HibernateUtil.currentSession();
		 Transaction tx = hsession.beginTransaction();
         User user=new User();
         
		 try{
		 	user.setName(name);
		 	hsession.save(user);
	        hsession.flush();
	        
		 }catch (Exception e) {
			System.out.println(e.getMessage());
		 }finally{
	
          tx.commit();
          HibernateUtil.closeSession();
        }
          
     }
     

	    public List getGbooks() throws HibernateException{
	  	 Session session=HibernateUtil.currentSession();
	     Transaction tx = null;
	     List list=null;
	     try {
	       tx = session.beginTransaction();
	        Query query = session.createQuery ("select user from User as user ");
	        list = query.list();
	        tx.commit();
	     }catch (HibernateException e) {
	       if (tx != null) {
	         tx.rollback();
	       }
	       System.err.println("getGbook:"+e.getMessage());
	     } finally {
	       //session.close();
	     }
	      return list;
	   }
          	
 }