jboss-ql中的like、order by的实现

在ejb-jar.xml下加入如下代码：

   <entity>

.......

      <query>
        <query-method>
          <method-name>findByNameLike</method-name>
          <method-params>
            <method-param>java.lang.String</method-param>
          </method-params>
        </query-method>
        <ejb-ql />
      </query>
    </entity>

在jbosscmp-jdbc.xml下加入如下代码：

<entity>

......

      <query>
        <query-method>
          <method-name>findByNameLike</method-name>
          <method-params>
            <method-param>java.lang.String</method-param>
          </method-params>
        </query-method>
        <jboss-ql>select object(c) from County as c where c.name like concat('%',concat(?1,'%')) order by c.id desc</jboss-ql>
      </query>
    </entity>