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

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