viewdao.java

新闻系统 此系统是用struts+spring+hibernate开发的 开发环境:eclipse3.1+MyEclipse4.1+tomcat 5.0+oracle 8.1 整个系统实现

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<newslist.size();i++){
			ViewForm viewform = new ViewForm();
			News news = (News) newslist.get(i);
			viewform.setNewsid(news.getId());
			viewform.setNewtitle(news.getNewtitle());
			viewform.setTypeid(news.getTypeid());
			long time2 =new Long(news.getDate2()).longValue();
			long time = time1-time2;
			//System.out.println(time);
			if(time<=1000000){
				String img = "<img src='image/firstnew.gif' align='absbottom' border='0'>";
				viewform.setFirstNews(img);
			}else{
				String img = "";
				viewform.setFirstNews(img);
			}
			list.add(viewform);
		}
		viewForm.setNewsList(list);
	}
}