学步园

1.测试查询
package com.example.test;
import java.util.List;


import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Transaction;
import org.hibernate.Session;

import com.example.bean.People;
import com.example.util.DbUtil;
public class TestQuery {
	@SuppressWarnings("unchecked")
	public static void main(String[] args) {
	
		@SuppressWarnings("unused")
		People people=null;
		Session session=DbUtil.currentSession();
		Transaction tx=null;
		
		try{
		tx=session.beginTransaction();
		
		Query query=session.createQuery("from People");//Query 作用的对象是类People
		List list=query.list();
		for(int i=0;i<list.size();i++){
			People p=(People)list.get(i);
			System.out.println("id:"+p.getId()+" name:"+p.getName());
		}
		tx.commit();
		}catch(HibernateException e){
			if(tx!=null)
				tx.rollback();
			throw e;
		}
		session.close();
		

	}

}

2.测试更新
package com.example.test;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.example.bean.People;
import com.example.util.DbUtil;
public class TestUpdate {
	@SuppressWarnings("unchecked")
	public static void main(String[] args) {
		People p=null;
		Session session=DbUtil.currentSession();
		Transaction tx=null;
		try{
			tx=session.beginTransaction();
			Query query=session.createQuery("from People where id=:id");
			query.setParameter("id", new Integer(1));
			List list=query.list();
			if(list.size()>0){
			p=((People)list.get(0));
			//System.out.println("id: "+p.getId()+"name: "+ p.getName());
			}
			p.setName("h");
			session.update(p);
			query=session.createQuery("from People where id=:id");
			query.setParameter("id",1);
			 list=query.list();
			if(list.size()>0){
				p=(People)list.get(0);
				System.out.println("id: "+p.getId()+"name: "+ p.getName()+" status: "+p.getStatus());
			}
			tx.commit();
		}
			
			catch(HibernateException e){
				if(tx!=null)
					tx.rollback();
				throw e;
			}
			session.close();
			
		

	}

}

3.测试插入
package com.example.test;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.example.bean.People;
import com.example.util.DbUtil;
public class TestInsert {

	@SuppressWarnings("unchecked")
	public static void main(String[] args) {
		People people=null;
		Session session=DbUtil.currentSession();
		Transaction tx=null;
		try{
			tx=session.beginTransaction();
			people=new People();
			people.setId(6);
			people.setName("xiao cui");
			people.setStatus("3");
			session.save(people);
			Query query=session.createQuery("from People order by id");
			List list=query.list();
			if(list.size()>0){
				people=(People)list.get(list.size()-1);
				System.out.println("新增人员："+people.getId()+"  name："+people.getName()+"  status: "+people.getStatus());
				
			}
			tx.commit();
		}catch(HibernateException e){
			if(tx!=null){
				tx.rollback();
				throw e;
			}
		}
	    session.close();

	}

}