package com.gd.dao.impl;
import java.util.ArrayList;
import java.util.List;
import org.apache.log4j.Logger;
import org.hibernate.SessionFactory;
import com.gd.dao.NewsDAO;
import com.gd.dao.UserDAO;
import com.gd.po.News;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
//實現NewsDao接口，實現依賴注入
public class NewsDAOimpl extends HibernateDaoSupport implements NewsDAO{
	private Logger logger=Logger.getLogger(this.getClass().getName());
	//定義SessionFactory，負責對數據庫的連接
	private SessionFactory sessionFactory;
	//定義Hibernate的hql語句，用來根據新聞的id查詢新聞
	private String hql="from New n where n.newstype=?";
	////定義Hibernate的hql語句，用來根據新聞類別的id查詢新聞
	private String hqlByNewsType="from New n where n.newtype=?";
	//創建新聞
	public void createNews(News news){
		this.getHibernateTemplate().save(news);
	}
	//修改新聞
	public void updateNews(News news){
		this.getHibernateTemplate().update(news);
	}
	//刪除新聞
	public void deleteNews(News news){
		this.getHibernateTemplate().delete(news);
	}
	//根據新聞id獲取新聞
	public News queryNews(Integer id){
		List newsList;
		if(this.getHibernateTemplate().find(hql,id)==null)
			newsList=new ArrayList();
			else
			newsList=this.getHibernateTemplate().find(hql,id);
		return (News)newsList.get(0);
	}
	//根據新聞類別id獲取同一類型的新聞
	public List getNewsByType(Integer id){
		List newsList;
		if(this.getHibernateTemplate().find(hqlByNewsType,id)==null)
			newsList=new ArrayList();
		else
			newsList=this.getHibernateTemplate().find(hqlByNewsType,id);
		return newsList;
	}
	@Override
	public List getNewsByType(long l) {
		// TODO Auto-generated method stub
		return null;
	}
		

}