hibernate 查讯

package test;
/*
* autho huangjin green eat 
*Oct 16, 2008
*/
import java.sql.Date;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;
import org.apache.log4j.Logger;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Example;
import org.hibernate.criterion.Expression;
import org.hibernate.criterion.Order;

import com.jxsme.hibernate.*;
public class hibernateTest {

/**
* @param args
*/
private static final Logger log= Logger.getLogger(hibernateTest.class);
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub

Session session=HibernateUtil.currentSession();
//查讯  query  list Iterator
   String sql="from Userinfo";
   Query query =session.createQuery("from Userinfo c where c.username like :username");
   query.setString("username", "%h%");
   List list= query.list();
   for(int i=0;i<list.size();i++){
   Userinfo user=(Userinfo)list.get(i);
   log.info("查到的用户名为:"+user.getUsername());
  
   }
  
// Userinfo user = new Userinfo();
// user.setUsername("huangjin");
// Criteria criteria=session.createCriteria(Userinfo.class);
// criteria.add(Example.create(user));
// List list=criteria.list();
// for(int i=0;i<list.size();i++){
// log.info("说明有值"+list.get(i));
// }

// List list =session.createCriteria(Userinfo.class).add(Expression.like("username","%h%")).list();
// List list = session.createCriteria(Userinfo.class).add(Expression.between("id",1, 5)).addOrder(Order.desc("id")).list();
// for(int i=0;i<list.size();i++){
// log.info("查讯有结果:"+list.get(i));
// Userinfo user= (Userinfo)list.get(i);
// log.info("id:"+user.getId()+"username:"+user.getUsername());
// }


// List list =session.createQuery(sql).list();
// log.info("开始");
// Iterator iterator =list.iterator();
// while(iterator.hasNext()){
// Userinfo user= (Userinfo)iterator.next();
// log.info(user.getUsername());
// }
// for(int i=0;i<list.size();i++){
// Userinfo user= (Userinfo)list.get(i);
// log.info(user.getId()+":"+user.getUsername());
//// Object[] obj= (Object[])list.get(i);
////             for(int b=0;b<obj.length;b++){
////            log.info("这里:"+obj[b]);
//             }
  


// String sql="from Userinfo";
// Iterator iterator =session.createQuery(sql).iterate();
// while(iterator.hasNext()){
// Userinfo user=(Userinfo)iterator.next();
// log.info(user.getId()+":"+user.getUsername());
//
// }
// String sql="from Userinfo";
//
// Iterator iterator = session.createQuery(sql).iterate();
// log.info("这个值:"+iterator);




// Iterator iterator = session.iterator(sql);

// Query query=session.createSQLQuery(" from userinfo");
// List list= query.list();
//        for(int i=0;i<list.size();i++){
//        Userinfo user=(Userinfo)list.get(i);
//        log.info(user.getUsername());
//        }
// Transaction tx= session.beginTransaction();
// //查讯
// Userinfo user=(Userinfo)session.get(Userinfo.class, new Integer(7));
// log.info("用户名是"+user.getUsername());
// tx.commit();
// session.close();

//添加
// Transaction tx= session.beginTransaction();
//         Userinfo user= new Userinfo();
//         user.setUsername("huangjinnow");
//         user.setInTime(new java.util.Date());
//         session.save(user);
//         tx.commit();
//         session.close();
//         log.info("添加成功");

// Transaction tx= session.beginTransaction();
// session.createSQLQuery("update Userinfo inTime=now()");
////        Userinfo user= new Userinfo();
////        user.setInTime(new java.util.Date());
////        session.update(user);
////        tx.commit();
////        session.close();
//        log.info("添加成功");
//        java.sql.Connection conn= session.connection();
//        String date=new java.util.Date().toString();
////        String   sql="update userinfo set   inTime="+date;  
////        java.sql.PreparedStatement   ps=conn.prepareStatement(sql);  
////        ps.executeUpdate();  
//        log.info("更新成功"+date);
//        conn.close();

//批量添加
// Transaction tx = session.beginTransaction();
// String sql="update Userinfo set inTime=:date";
// Userinfo user= new Userinfo();
// user.setInTime(new java.util.Date());
// session.createQuery(sql).setDate("date", user.getInTime()).executeUpdate();
// tx.commit();
// session.close();
// log.info("添加时间成功:"+user.getInTime());

}

}