articledao.java

来自「一个很好的jbpm应用实例」· Java 代码 · 共 158 行

package c20.dao;

import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import c20.entity.Article;
import c20.helper.PageBean;
import c20.helper.PageResult;

public class ArticleDao extends PageSupport {
	/**
	 * 日志操作对象
	 */
    private static final Log log = LogFactory.getLog(ArticleDao.class);
    
    public List getArticles(){
        log.debug("finding Article instance all");
        try {
            String queryString = "from Article as model order by model.articleNo desc";
   			return getHibernateTemplate().find(queryString);
        } catch (RuntimeException re) {
            log.error("find all failed", re);
            throw re;
        }
    }
    
    public PageResult getArticles(PageBean pageBean){
        log.debug("finding getArticles instance all");
        try {
            String queryString = "from Article as model order by model.articleNo desc";
   			return this.getPageTemplate().find(queryString, pageBean);
        } catch (RuntimeException re) {
            log.error("find all failed", re);
            throw re;
        }
    }
    
    public void addArticle(Article article){
    	getHibernateTemplate().save(article);
    }
    
    public void modArticle(Article article){
    	getHibernateTemplate().update(article);
    }
    
    public void delArticle(Article article){
    	getHibernateTemplate().delete(article);
    }
    
    public Article getArticle(int articleNo){
        log.debug("get Article instance by articleNo:" + articleNo);
        try {
   			return (Article)getHibernateTemplate().get(Article.class, new Integer(articleNo));
        } catch (RuntimeException re) {
            log.error("get by articleNo failed", re);
            throw re;
        }
    }
    
    public List findByArticleName(String name){
        log.debug("findByArticleName name:" + name);
        try {
            String queryString = "from Article as model where model.name=? order by model.articleNo desc";
   			return getHibernateTemplate().find(queryString, name);
        } catch (RuntimeException re) {
            log.error("findByArticleName failed", re);
            throw re;
        }
    	
    }

    public List findByArticleUser(int userNo){
        log.debug("findByArticleUser userNo:" + userNo);
        try {
            String queryString = "from Article as model where model.userNo=? order by model.articleNo desc";
   			return getHibernateTemplate().find(queryString, new Integer(userNo));
        } catch (RuntimeException re) {
            log.error("findByArticleUser failed", re);
            throw re;
        }
    	
    }

    public PageResult findArticleByUser(int userNo, PageBean pageBean){
        log.debug("findByArticleUser userNo:" + userNo);
        try {
            String queryString = "from Article as model where model.userNo=? order by model.articleNo desc";
   			return getPageTemplate().find(queryString, new Integer(userNo), pageBean);
        } catch (RuntimeException re) {
            log.error("findByArticleUser failed", re);
            throw re;
        }
    	
    }

    public PageResult findArticleByUserAndState(int userNo, int state, PageBean pageBean){
        log.debug("findByArticleUser userNo:" + userNo);
        try {
            String queryString = "from Article as model where model.userNo=? and model.state=? order by model.articleNo desc";
   			return getPageTemplate().find(queryString, new Object[]{new Integer(userNo), new Integer(state)}, pageBean);
        } catch (RuntimeException re) {
            log.error("findByArticleUser failed", re);
            throw re;
        }
    	
    }
    
    public PageResult findArticleByState(int state, PageBean pageBean){
        log.debug("findArticleByState state:" + state);
        try {
            String queryString = "from Article as model where model.state=? order by model.articleNo desc";
   			return getPageTemplate().find(queryString, new Integer(state), pageBean);
        } catch (RuntimeException re) {
            log.error("findArticleByState failed", re);
            throw re;
        }
    	
    }

    public PageResult findArticleByAuditState(String auditState, PageBean pageBean){
        log.debug("findArticleByAuditState auditState:" + auditState);
        try {
            String queryString = "from Article as model where model.state=? and model.auditState=? order by model.articleNo desc";
   			return getPageTemplate().find(queryString, new Object[]{new Integer(Article.PUBLISH), auditState}, pageBean);
        } catch (RuntimeException re) {
            log.error("findArticleByAuditState failed", re);
            throw re;
        }
    	
    }
    
    public PageResult findArticleByType(int articleTypeNo, PageBean pageBean){
        log.debug("findArticleByType articleTypeNo:" + articleTypeNo);
        try {
            String queryString = "from Article as model where model.articleTypeNo=? order by model.articleNo desc";
   			return getPageTemplate().find(queryString, new Integer(articleTypeNo), pageBean);
        } catch (RuntimeException re) {
            log.error("findArticleByType failed", re);
            throw re;
        }
    	
    }

    public List findArticleByPdInstance(Long piId){
        log.debug("findArticleByPdInstance piId:" + piId);
        try {
            String queryString = "from Article as model where model.piId=? order by model.articleNo desc";
   			return getHibernateTemplate().find(queryString, new Long(piId));
        } catch (RuntimeException re) {
            log.error("findArticleByPdInstance failed", re);
            throw re;
        }
    	
    }
}