newsdaoimpl.java

jsp学习交流网

package cfq.business.impl;

import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import java.util.Set;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import cfq.business.dao.NewsDao;
import cfq.hibernate.vo.News;
import cfq.hibernate.vo.Newscomment;
public class NewsDaoImpl extends HibernateDaoSupport implements NewsDao {

	//新闻列表
	public List listAll() {
		List list=null;
		list=this.getHibernateTemplate().find("From News");
		return list;
	}

	//按新闻标题查询
	public List queryByTitle(String title) {
		List list=null;
		list=this.getSession().createQuery("From News n where n.newstitle like '%'+?+'%'").setString(0, title)
																			 .list();
		return list;
	}

	 //显示给浏览者看的新闻
	public List showNews() {
		
		return null;
	}
	 
	//根据新闻Id查处此新闻的详细信息
	public News queryById(int newsid) {
		News news=null;
		news=(News)this.getSession().load(News.class, newsid);
		return news;
	}

	//使点击次数加一
	public void addCount(int newsid) {
		News news=null;
		news=(News)this.getSession().load(News.class, newsid);
		news.setNewscount(news.getNewscount()+1);
	}

	 //根据新闻id列出本新闻的所有评论
	public Set listAllComment(int newsid) {
		
		News ns=(News)this.getSession().load(News.class, newsid);
		Set set=ns.getNewscomments();
		Iterator iter=set.iterator();
		while(iter.hasNext()){
			Newscomment nscomnt=(Newscomment)iter.next();
System.out.println("&&&&&&&&&&&"+nscomnt.getCommtitle());
		}
		return set;
	}
	
	 //根据评论标题查所有相关的评论
	public List queryBynewstitle(String commtitle) {
		List list=null;
		list=this.getSession().createQuery("From Newscomment n where n.commtitle like '%'+?+'%'").setString(0, commtitle)
																						  .list();
		return list;
	}

}