c13misprogramdao.java

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

package com.je.ims.dao;


import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.springframework.orm.hibernate3.*;
import java.util.*;
import org.hibernate.*;

import com.je.ims.hibernate.*;

public class C13MisProgramDAO  extends CommonDAO
{
	public void saveMisProgram(MisProgram misProgram,String item,String mothod,String howdo) 
	{
		misProgram.setItem(Hibernate.createClob(item));//这里构造了该clob，并设置到object中去
		misProgram.setHowdo(Hibernate.createClob(howdo));
		misProgram.setMothod(Hibernate.createClob(mothod));
		getHibernateTemplate().saveOrUpdate(misProgram);
		getHibernateTemplate().flush();
		  
	}
	public List getAll() {
		String hql="from MisProgram order by misProgramId desc ";
		List list=this.getHibernateTemplate().find(hql);
		return list;
	}
	public int getSize() {
    	
    	List list=getAll();
    	return list.size();
	}
	public Object[] getCount(int start, int size){

    	List list=getAll();
    	
    	MisProgram[] app = new MisProgram[size];
		
		for (int i=0;i<size;i++)
		{
			app[i]=new MisProgram();
			app[i]=(MisProgram)list.get(i+start);
		}
		return app;
    }
	public Object[] getCount(int start, int size,List l){

    	List list=l;
    	
    	MisProgram[] app = new MisProgram[size];
		
		for (int i=0;i<size;i++)
		{
			app[i]=new MisProgram();
			app[i]=(MisProgram)list.get(i+start);
		}
		return app;
    }
	
	public void delete(String sid){
		try{
			
			MisProgram misProgram=this.getMisProgramByID(sid);
			getHibernateTemplate().delete(misProgram);
		}
		catch(Exception e){
			
		}
    }
	
	public MisProgram getMisProgramByID(String sid)
    {
		try{
			int i=Integer.parseInt(sid);
			Long l=new Long(i);
			MisProgram misProgram = (MisProgram) getHibernateTemplate().get(MisProgram.class, l);
			return misProgram;
		}
		catch(Exception e)
		{
			return null;
		}
    }
	public MisProgram getMisProgramByID(Long l)
    {
		try{
			
			MisProgram misProgram = (MisProgram) getHibernateTemplate().get(MisProgram.class, l);
			return misProgram;
		}
		catch(Exception e)
		{
			return null;
		}
    }
	
	public void updateMisProgram(String sid,String caption,String item,String mothod,String howdo) {
		int i=Integer.parseInt(sid);
		Long l=new Long(i);
		MisProgram misProgram=getMisProgramByID(l);
		misProgram.setCaption(caption);
		misProgram.setItem(Hibernate.createClob(item));
		misProgram.setHowdo(Hibernate.createClob(howdo));
		misProgram.setMothod(Hibernate.createClob(mothod));
		getHibernateTemplate().update(misProgram);
		getHibernateTemplate().flush();
		  
	}
	public List query(String caption,String item,String mothod,String howdo)
	{
		List l=this.getHibernateTemplate().find(" from MisProgram where caption like ? and item like ? and mothod like ? and howdo like ?",new Object[] {"%"+caption+"%","%"+item+"%","%"+mothod+"%","%"+howdo+"%"});
	
		return l;
	}
	
	public String getItemByIdAsString(Long id)//得到ITEM中的字符串
	{	String s="";
		MisProgram misProgram =this.getMisProgramByID(id);
		if(misProgram!=null)
		{
			try
			{
				 java.sql.Clob clob = misProgram.getItem();	
				 s= clob.getSubString(1, (int)clob.length());
			}
			catch(Exception e)
			{
				
			}
			
		  }
		return s;
	}
	public String getHowdoByIdAsString(Long id)//得到Howdo中的字符串
	{	String s="";
		MisProgram misProgram =this.getMisProgramByID(id);
		if(misProgram!=null)
		{
			try
			{
				 java.sql.Clob clob = misProgram.getHowdo();	
				 s= clob.getSubString(1, (int)clob.length());
			}
			catch(Exception e)
			{
				
			}
			
		  }
		return s;
	}
	public String getMethodByIdAsString(Long id)//得到Method中的字符串
	{	String s="";
		MisProgram misProgram =this.getMisProgramByID(id);
		if(misProgram!=null)
		{
			try
			{
				 java.sql.Clob clob = misProgram.getMothod();	
				 s= clob.getSubString(1, (int)clob.length());
			}
			catch(Exception e)
			{
				
			}
			
		  }
		return s;
	}
}