ssh参数直接查询+参数的模糊查询

来源:互联网 发布:php初学者的开发工具 编辑:程序博客网 时间:2024/05/17 09:08

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