newsdaoimp.java

Java项目 新闻管理系统 jsp+struts+hibernate 开发:eclipse+oracle9i+tomcat 高质量代码 导入数据即可用

package com.xdf.news.dao.hibernate;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.criterion.Restrictions;

import com.xdf.news.bean.News;
import com.xdf.news.dao.INewsDAO;

public class NewsDAOImp extends BaseDAO implements INewsDAO{

	public List findAll() {
		return getSession().createQuery("from News order by id desc").list();
	}

	public int findcount() {
		List list = getSession().createQuery("select count(*) from News").list();
		Integer num = (Integer)list.get(0);
		return num.intValue();
	}

	public List findNews(String title, String keyword, Long typeid) {
		Criteria c = getSession().createCriteria(News.class);
		if(title!=null&&!title.equals("")) {
			c.add(Restrictions.like("title","%"+title+"%"));
		}
		if(keyword!=null&&!keyword.equals("")) {
			c.add(Restrictions.eq("keyword",keyword));
		}
		if(typeid!=null&&!typeid.equals(new Long(0))) {
			c.add(Restrictions.eq("ntype.typeid",typeid));
		}
		return c.list();
	}

}