newsdao.java

用ajax在ssh框架下发挥

package com.news.dao.impl;

import java.sql.SQLException;
import java.util.Date;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.classic.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.news.bean.News;
import com.news.dao.INewsDao;
import com.news.page.Page;
import com.news.struts.form.AddNewsForm;
import com.news.utils.GetDate;
import com.news.utils.GetId;


public class NewsDao extends HibernateDaoSupport implements INewsDao{

	public void insertNews(AddNewsForm addNewsForm) {
		Date d = new Date();
		News news = new News();
		news.setId(GetId.getId());
		news.setNewauthor(addNewsForm.getNewauthor());
		news.setNewcontent(addNewsForm.getNewcontent());
		news.setNewfrom(addNewsForm.getNewfrom());
		news.setNewtitle(addNewsForm.getNewtitle());
		news.setCount("0");
		news.setNewdate(GetDate.getDate1(d));
		news.setDate2(GetDate.getDate2(d));
		news.setTypeid(addNewsForm.getTypeid());
		getHibernateTemplate().save(news);
		
	}

	public void findNews(AddNewsForm addNewsForm) {
		String hql ="from News order by date2 desc";
		Session s=getHibernateTemplate().getSessionFactory().openSession();
		Query q = s.createQuery(hql);
		List list = q.list();
		addNewsForm.setList(list);
		s.close();
	}
	
	public void findNews2(AddNewsForm addNewsForm) {
		String hql = "from News where typeid = ? order by date2 desc";
		Session s = getHibernateTemplate().getSessionFactory().openSession();
		Query q = s.createQuery(hql);
		q.setParameter(0,addNewsForm.getTypeid());
		List list = q.list();
		addNewsForm.setList(list);
		s.close();
	}

	public void deleteNews(AddNewsForm addNewsForm) {
		News news = (News) getHibernateTemplate().load(News.class,addNewsForm.getId());
		getHibernateTemplate().delete(news);
		
	}

	public void changeNews(AddNewsForm addNewsForm) {
		News news = (News) getHibernateTemplate().load(News.class,addNewsForm.getId());
		addNewsForm.setId(news.getId());
		addNewsForm.setNewauthor(news.getNewauthor());
		addNewsForm.setNewcontent(news.getNewcontent());
		addNewsForm.setNewfrom(news.getNewfrom());
		addNewsForm.setNewtitle(news.getNewtitle());
		
	}

	public void change2News(AddNewsForm addNewsForm) {
		News news = (News) getHibernateTemplate().load(News.class,addNewsForm.getId());
		news.setId(addNewsForm.getId());
		//news.setNewauthor(addNewsForm.getNewauthor());
		news.setNewcontent(addNewsForm.getNewcontent());
		news.setNewfrom(addNewsForm.getNewfrom());
		news.setNewtitle(addNewsForm.getNewtitle());
		getHibernateTemplate().save(news);
	}

	/**
	 * 分页查询
	 */
	public List getList(Page page,AddNewsForm addNewsForm){
		final Page p = page;
		final AddNewsForm form = addNewsForm;
		return getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(org.hibernate.Session s) throws org.hibernate.HibernateException, SQLException {
				Query query = s.createQuery(p.getHql());
				query.setParameter(0,form.getTypeid());
				query.setFirstResult(p.getStartRs());
				query.setMaxResults(p.getPerPage());
				List list = query.list();				
				return list;
			}
		});
	}
	public int getTotal(String hql,AddNewsForm addNewsForm){
		//System.out.println("sss");
		Session s = getHibernateTemplate().getSessionFactory().openSession();
		Query q = s.createQuery(hql);
		q.setParameter(0,addNewsForm.getTypeid());
		List result = q.list();
		getHibernateTemplate().getSessionFactory().close();
		if (null != result && !result.isEmpty()) {
			return (result.size());
		} else {
			return 0;
		}
	}

}