glossdao.java

博克后台的开发,有很多使用的方法和例子可以提供给大家学习

package com.remark.manage.dao.impl;

import java.util.ArrayList;
import java.util.List;

import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.common.util.ListInfo;
import com.emk.manage.Constants;
import com.emk.manage.exception.DataProcessException;
import com.remark.manage.dao.IGlossDAO;
import com.remark.manage.hibernate.po.EmkEcommRemark;
import com.remark.manage.hibernate.po.EmkScreenGlossary;
import com.remark.manage.vo.impl.EmkEcommRemarkVO;
import com.remark.manage.vo.impl.EmkScreenGlossaryVO;
import com.res.core.service.ui.component.navbar.PageModel;

public class GlossDAO extends HibernateDaoSupport implements IGlossDAO{

	public GlossDAO()
	{
		System.out.println("GlossDAO START.....................");
	}
	
	public void addGloss(EmkScreenGlossary glossary) throws Exception {
		
		getHibernateTemplate().saveOrUpdate(glossary);
		
	}
	
	public EmkScreenGlossaryVO getContentById(String screenid){
		EmkScreenGlossary emkScreenGlossary = new EmkScreenGlossary();
		String sql="from EmkScreenGlossary where screenid='" + screenid + "'";
		List list=getHibernateTemplate().find(sql);
		if(list.size()!=0){
			emkScreenGlossary = (EmkScreenGlossary) list.get(0);
		}
		EmkScreenGlossaryVO emkScreenGlossaryVO = new EmkScreenGlossaryVO(emkScreenGlossary);
		return emkScreenGlossaryVO;
		
		
	}
	
	public List listGloss(PageModel pageModel) throws Exception {
    	List list = new ArrayList();
		List list2 = new ArrayList();
		ListInfo listInfo = new ListInfo();
    	try {
	        String sql = "from EmkScreenGlossary";
	       	        
            list = listInfo.getOfficeBySearchCriteria(this.getHibernateTemplate(), sql, pageModel,null);
	    	
	    	if(list.size()!=0){
	    		for(int i=0;i<list.size();i++)
	    		{
	    			list2.add(new EmkScreenGlossaryVO((EmkScreenGlossary)list.get(i)));
	    		}
	    	}
            //PO to VO END
        } catch (Exception e) {
            e.printStackTrace();
        }
    	return list2;
    }
	public boolean delGloss(List glossList) throws Exception {
	boolean isDel = false;
		try{
			System.out.println(glossList.size());
		for(int i=0;i<glossList.size();i++){
			EmkScreenGlossaryVO esgVO = (EmkScreenGlossaryVO) glossList.get(i);
			System.out.println(esgVO.getSelected());
			if(esgVO.getSelected() == true){
				getHibernateTemplate().delete(new EmkScreenGlossary(esgVO));
				
			}
			isDel = true;
		}
		}catch(Exception e){
			e.printStackTrace();
		}
		return isDel;
		

		
	}
	
}