SQL语句在DAO中实现动态模糊查找

方法一：

public List queryByMul(String  no, String name) 

{

String hql="from Stuent as n where n.no like ? or n.name like ?";


//String[] s={"%"+你要放的值+"%","%"+你要放的值+"%"};
String[] s={"%"+no+"%","%"+name+"%"};

getHibernateTemplate().find(hql, s);

}

方法二：

public List queryByMul(String no, String name) 

{

// 创建Session
Session session = HibernateUtil.getSession();

// 使用HQL查询
String hql="from Stuent as n where n.no like ? or n.name like ?";

// 通过Query方法查询
Query q = session.createQuery(hql);

//查询结果保存到list中
List list = q.list();

q.setString(0,"%"+no+"%");

q.serString(1,"%"+"name+%")

//关闭session
HibernateUtil.closeSession(session);

return list;

}