userdaosupport.java

struts hibernate spring 整合源码,用于ssh框架的初学者,很实用

package sun;

import java.sql.SQLException;
import java.util.*;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class userDaoSupport extends HibernateDaoSupport {
	//以下以Hibernate中session形式进行操作
	//插入数据
	public void insert(Demojdbc demojdbc)
	{
		this.getSession().save(demojdbc);
	}
	//查询数据
	public List selectQuery()
	{
		List list = null;
		Query q = this.getSession().createQuery("from Demojdbc where id='7'");
		list = q.list();
		this.getSession().close();
		return list;
	}
	//数据修改
	public void updatea(Demojdbc demojdbc)
	{
		//Session session = null; 
		//session = this.getSession(); 
		//session.getTransaction().begin(); 
		//session.update(demojdbc); 
		String hql = "update Demojdbc set name='FFFF'where id=7";
		Query q = this.getSession().createQuery(hql);
		q.executeUpdate();
		//session.getTransaction().commit(); 
	}
	public void update(Demojdbc dj)
	{
		Session session = this.getSession();
		session.beginTransaction();
		session.update(dj);
		session.beginTransaction().commit();
	}
	//数据删除
	public void delete(int id)
	{
		String hql = "delete from Demojdbc where id='"+id+"'";
		Query q = this.getSession().createQuery(hql);
		q.executeUpdate();
	}
	public void deltea(int id)
	{
		Session  session = this.getSession();
		session.beginTransaction();
		Demojdbc dj = (Demojdbc)this.getSession().get(Demojdbc.class, id);
		session.delete(dj);
		session.beginTransaction().commit();
	}
	
	//以下是以this.getHibernateTemplate();Hibernate模板形式进行操作
	//内部类回调的形式查询数据
	public List select()
	{
		final String hql = "from Demojdbc";
	
		List lsit = this.getHibernateTemplate().executeFind(new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Query q = session.createQuery(hql);
				List list = q.list();
				return list;
			}
		});
		return lsit;	
	}
	public List hselect()
	{
		String hql = "from Demojdbc";
		List list = null;
		list = this.getHibernateTemplate().find(hql);
		return list;
	}
	//插入数据
	public void hinsert(Demojdbc dj)
	{
		this.getHibernateTemplate().save(dj);
	}
	//修改数据
	public void hupdate(Demojdbc dj)
	{
		this.getHibernateTemplate().update(dj);
	}
	//删除数据
	public void hdelete(int id)
	{
		Demojdbc d = (Demojdbc)this.getHibernateTemplate().get(Demojdbc.class, id);
		this.getHibernateTemplate().delete(d);
	}
}