articledaoimpl.java

前期开发时开发的新闻发布系统

package com.xh369.daoimpl;

import com.xh369.dao.*;
import com.xh369.dto.Article;
import org.hibernate.Session;
import com.xh369.actions.HibernateSessionFactory;
import java.util.*;
import org.hibernate.Query;
import com.xh369.dto.BigClass;

public class ArticleDAOimpl implements ArticleDAO 
{

    //文章添加
    public boolean articleAdd(Article article) 
    {
        try 
        {
            Session session = HibernateSessionFactory.getSession();
            HibernateSessionFactory.beginTransaction();
            session.save(article);
            return true;
        } 
        catch(Exception ex) 
        {
            ex.printStackTrace();
            return false;
        }
    }

    //文章浏览(按id查询)
    public Article searchByID(Integer id)
    {
        Article article = null;
        Session session = HibernateSessionFactory.getSession();
        try 
        {
            article = (Article) session.load(Article.class, id);
            return article;
        } 
        catch(Exception ex) 
        {
            ex.printStackTrace();
            return article;
        }
    }

    //查看文章详细内容
    public Article searchDesc(Integer id) 
    {
        return searchByID(id);
    }

    //修改发布的文章的信息(首先显示出原数据)
    public Article updateArticle(Integer id)
    {
        return searchByID(id);
    }

    //删除发布的文章的信息
    public boolean deleteArticle(Integer id) 
    {
        try 
        {
            Session session = HibernateSessionFactory.getSession();
            HibernateSessionFactory.beginTransaction();
            Article article = (Article) session.load(Article.class, id);
            session.delete(article);
            return true;
        } 
        catch(Exception ex) 
        {
            ex.printStackTrace();
            return false;
        }
    }

    //在栏目管理模块中显示一级分类,从而导航到二级分类
    public List searchBigClass()
    {
        List aList = new ArrayList();
        Session session = HibernateSessionFactory.getSession();
        try 
        {
            String hql = "from BigClass bigclass";
            Query query = session.createQuery(hql);
            List list = query.list();
            for(Iterator it = list.iterator(); it.hasNext();)
            {
                BigClass bigClass = (BigClass) it.next();
                aList.add(bigClass);
            }
            return aList;
        } 
        catch(Exception ex) 
        {
            ex.printStackTrace();
            return aList;
        }
    }

    //修改发布的文章的信息
    public boolean updateOnlyArticle(Article article)
    {
        try 
        {
            Session session = HibernateSessionFactory.getSession();
            HibernateSessionFactory.beginTransaction();
            session.update(article);
            return true;
        } 
        catch(Exception ex) 
        {
            ex.printStackTrace();
            return false;
        }
    }
    
    //列表文章标题(按标题查询)
	public List searchArticleTitle(String title) 
	{		
		try 
		{
			Session session = HibernateSessionFactory.getSession();
			String hql = "select distinct(article.title) from Article as article where article.title like '%" + title + "%' ";
			return session.createQuery(hql)
				          .list();
		} 
		catch(Exception e) 
		{
			e.printStackTrace();
			return null;
		}
	}
}