hibernate使用LIKE进行模糊查找

public List findByMapNameUseLikeAndPage(String name,int pageSize,int pageNumber) {

        log.debug("finding Maps instance with property: " + MAP_NAME

                + ", value: " + name);

        try {

            //不能写成'%"+ clientname+"%'

            String queryString = "from Maps as model where model." + MAP_NAME

                    + " LIKE ? " + "order by mapType";

            Query queryObject = getSession().createQuery(queryString);

            //正确写法

            queryObject.setParameter(0, "%" + name + "%");

            queryObject.setFirstResult(pageSize*(pageNumber-1));

            queryObject.setMaxResults(pageSize);

            return queryObject.list();

        } catch (RuntimeException re) {

            log.error("find by property name failed", re);

            throw re;

        }

    }