唐诗搜索网站（SSH）

package com.jkxy.dao.impl; import java.util.List; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import com.jkxy.dao.IQueryDao; public class queryDao implements IQueryDao { private SessionFactory sessionFactory; public SessionFactory getSessionFactory() { return sessionFactory; } public void setSessionFactory(SessionFactory sessionFactory) { this.sessionFactory = sessionFactory; } @Override public List queryDao(String qString, String type) { Session session = sessionFactory.openSession(); Transaction ts = session.beginTransaction(); StringBuffer hql = new StringBuffer("select a.title,b.name,a.content"); hql.append(" from Poetries a,Poets b");// 联合查询 if (type.equals("one")) {// 如果查询条件为诗人名 hql.append(" where b.name like '%" + qString + "%' and a.poet_id=b.id"); } else if (type.equals("two")) {// 如果查询条件为标题 hql.append(" WHERE a.title like '%" + qString + "%' and a.poet_id=b.id"); } else if (type.equals("three")) {// 如果查询条件为名句 hql.append(" WHERE a.content like '%" + qString + "%' and a.poet_id=b.id"); } Query query = session.createQuery(hql.toString()); List list = query.list(); return list; } }