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

    //查看文章詳細(xì)內(nèi)容
    public Article searchDesc(Integer id) {

        return searchByID(id);
    }

    //修改發(fā)布的文章的信息(首先顯示出原數(shù)據(jù))
    public Article updateArticle(Integer id){

        return searchByID(id);
    }

    //刪除發(fā)布的文章的信息
    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;
        }
    }

    //在欄目管理模塊中顯示一級分類,從而導(dǎo)航到二級分類
    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;
        }
    }

    //修改發(fā)布的文章的信息
    public boolean updateOnlyArticle(Article article){

        try {
            Session session = HibernateSessionFactory.getSession();
            HibernateSessionFactory.beginTransaction();
            session.update(article);
            return true;
        } catch (Exception ex) {
            ex.printStackTrace();
            return false;
        }
    }
    
    //列表文章標(biāo)題(按標(biāo)題查詢)
	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;
		}
	}
}