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

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); 
	} 
}