searchdao.java

来自「用ajax在ssh框架下发挥」· Java 代码 · 共 31 行

package com.news.dao.impl;

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

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

import com.news.dao.IsearchDao;
import com.news.struts.form.SearchForm;

public class SearchDao extends HibernateDaoSupport implements IsearchDao {
	
	public void search(SearchForm searchForm){
		//System.out.println(searchForm.getNewtitle());
		final SearchForm search = searchForm;
		List searchlist = getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(org.hibernate.Session s) throws org.hibernate.HibernateException, SQLException {
				//String hql = "from News where newtitle = ? order by date2 desc";
				String hql = "from News where newtitle like ? order by date2 desc";
				Query q = s.createQuery(hql);
				
				q.setParameter(0,"%"+search.getNewtitle()+"%");
				return q.list();
			}
		});
		searchForm.setSearchList(searchlist);
	}
}