1.如果ajax没有反映,没有运行,有可能是参数有错误,记得检查参数的问题
2.ssh中写的hql语句
带有参数:正常查询
@Override
public List<Usert> checkPassword(String username) {
// TODO Auto-generated method stub
String hql = "select password from Usert where username ='"+username+"'";
List<Usert> password = sessionfactory.getCurrentSession()
.createSQLQuery(hql).list();
return password;
}
3.传入参数模糊查询
@Override
public List<Jzgl> findId(String qxmc) {
// TODO Auto-generated method stub
//String hql = "select jzbm,jzzl from jzgl where jzgl.jzid=(select jz_id from sjqk where sjqk.sjid =:sjid)";
String hql = "select jzbm, jzzl from jzgl where jzgl.jzid in (select jz_id from sjqk where sjqk.qxmc like :qxmc)";
Session session = sessionfactory.getCurrentSession();
List<Jzgl> jzqk = session.createSQLQuery(hql).setString("qxmc","%"+qxmc+"%").list();
return jzqk;
}