articledaoimpl.java

Spring+Struts+Hibernate newManager新闻管理系统

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;
		}
	}
}