c12intentdao.java

使用spring ,hibernate 框架的稽查管理系统

package com.je.ims.dao;

import java.util.List;

import org.hibernate.Hibernate;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.je.ims.hibernate.Atree;
import com.je.ims.hibernate.Intent;

public class C12IntentDAO extends HibernateDaoSupport{

	public C12IntentDAO() {
		super();
	}
	
//	删除所有记录，做实验用
	public void Delete(){
		getHibernateTemplate().deleteAll(getHibernateTemplate().loadAll(Intent.class));
	}
	
	public List query(String intent,Long year,String tree) {

		List list=this.getHibernateTemplate().find
		("from Intent where mgrIntent like ?  and year = ? and ab = ?",new Object[] {"%"+intent+"%",year,tree});
		return list;
		
	}
	
	public void insert(Intent intent,String mgrIntent, String mgrPoint, String data, String appdoc) 
	{
		intent.setMgrIntent(Hibernate.createClob(mgrIntent));//这里构造了该clob，并设置到object中去
		intent.setMgrPoint(Hibernate.createClob(mgrPoint));
		intent.setData(Hibernate.createClob(data));
		intent.setAppdoc(Hibernate.createClob(appdoc));
		getHibernateTemplate().save(intent);
		getHibernateTemplate().flush();
	}
    public Long getId(Long year,String tree,String nodeId){
    	List L1=this.getHibernateTemplate().find
		("from Intent where year =? and ab = ? and nodeId = ?",new Object[] {year,tree,nodeId});
		if(L1.size()>0)
			return ((Intent)L1.get(0)).getIntentId();
		return null;
    }
	
	public Intent getObj(Long year, String tree, String parentId) {
		List L1=this.getHibernateTemplate().find
		("from Intent where year =? and ab = ? and nodeId = ?",new Object[] {year,tree,parentId});
		if(L1.size()>0)
			return (Intent)L1.get(0);
		return null;
	}
	public String getmgrIntent(Intent intent)
	{	
		String s="";
			try
			{
				 java.sql.Clob clob = intent.getMgrIntent();
				 s= clob.getSubString(1, (int)clob.length());
			}
			catch(Exception e)
			{
				
			}
			
		return s;
	}
	public String getmgrPoint(Intent intent)
	{	
		String s="";
			try
			{
				 java.sql.Clob clob = intent.getMgrPoint();
				 s= clob.getSubString(1, (int)clob.length());
			}
			catch(Exception e)
			{
				
			}
			
		return s;
	}
	public String getData(Intent intent)
	{	
		String s="";
			try
			{
				 java.sql.Clob clob = intent.getData();
				 s= clob.getSubString(1, (int)clob.length());
			}
			catch(Exception e)
			{
				
			}
			
		return s;
	}
	public String getAppDoc(Intent intent)
	{	
		String s="";
			try
			{
				 java.sql.Clob clob = intent.getAppdoc();
				 s= clob.getSubString(1, (int)clob.length());
			}
			catch(Exception e)
			{
				
			}
			
		return s;
	}

	public void update(Long currentYear, String tree, String nodeId, String purpose, String sum1, String point, String data, String sum2) {
		Intent intent=getObj(currentYear,tree,nodeId);
		intent.setMgrCycle(sum1);
		intent.setMgrIntent(Hibernate.createClob(purpose));
		intent.setMgrPoint(Hibernate.createClob(point));
		intent.setData(Hibernate.createClob(data));
		intent.setAppdoc(Hibernate.createClob(sum2));
		getHibernateTemplate().update(intent);
		getHibernateTemplate().flush();
	}

	public void delete(Long year, String tree, String parentId) {
		Intent intent = getObj(year,tree,parentId);
		getHibernateTemplate().delete(intent);
	}
}