www.pudn.com > j2EEnews_struts_hibernate_spring.rar > ViewDao.java

package com.news.dao.impl; 
 
import java.sql.SQLException; 
import java.util.ArrayList; 
import java.util.Date; 
import java.util.List; 
 
import org.hibernate.Query; 
import org.springframework.orm.hibernate3.HibernateCallback; 
import org.springframework.orm.hibernate3.support.HibernateDaoSupport; 
 
import com.news.bean.News; 
import com.news.dao.IviewDao; 
import com.news.struts.form.ViewForm; 
import com.news.utils.GetDate; 
 
public class ViewDao extends HibernateDaoSupport implements IviewDao { 
	 
	public void query(ViewForm viewForm){ 
		String hql = "from Newtype order by date2 desc"; 
		List typelist = getHibernateTemplate().find(hql); 
		viewForm.setViewList(typelist); 
	} 
	 
	public void queryNews(ViewForm viewForm){ 
		final ViewForm view = viewForm; 
		List newslist = getHibernateTemplate().executeFind(new HibernateCallback() { 
			public Object doInHibernate(org.hibernate.Session s) throws org.hibernate.HibernateException, SQLException { 
				String hql = "from News where typeid = ? order by date2 desc"; 
				Query q = s.createQuery(hql); 
				q.setParameter(0,view.getTypeid()); 
				q.setFirstResult(0); 
				q.setMaxResults(8); 
				return q.list(); 
			} 
		}); 
		List list = new ArrayList(); 
		long time1 = new Long(GetDate.getDate2(new Date())).longValue(); 
		for(int i=0;i