通過valuelist的queryMap傳遞過來的參數(shù)默認(rèn)都為string類型，在valuelist配置文件的hql中，如果直接將該值賦給整型的字段會(huì)報(bào)錯(cuò)。一般我們會(huì)在hql中利用轉(zhuǎn)型函數(shù)來進(jìn)行處理，如下：

復(fù)制代碼代碼如下:

<entry key="areasInfoAdapter">
       <bean  parent="abstractHibernate30Adapter">
                   <property name="defaultNumberPerPage"><value>19</value></property>
                     <property name="statementBuilder"><ref bean="statementBuilderHql"/></property> 
                      <property name="defaultSortColumn"><value>id</value></property>
                      <property name="defaultSortDirection"><value>desc</value></property>
                      <property name="hql">
                          <value>
                              from com.berheley.hcms.persistence.model.TBaseAreas as tb
                              where tb.status='1' 
                               /~hId  : and tb.hId  = to_number{hId}  ~/
                               /~oId  : and tb.oId  = to_number{oId}  ~/
                               order by tb.code asc
                          </value>
                      </property>
                      <property name="defaultFocusPropertyObjectAlias"><value>vo</value></property>
                      <property name="maxRowsForFocus"><value>160000</value></property>            
                      <property name="removeEmptyStrings"><value>true</value></property>
                  </bean>
                </entry>

該方法比較麻煩，在所有的整型字段地方都需要添加函數(shù)處理，并且進(jìn)行數(shù)據(jù)庫遷移時(shí)會(huì)出現(xiàn)函數(shù)不兼容的問題?？梢岳肰alueList配置來對整型的字段進(jìn)行統(tǒng)一設(shè)置，valuelist在拼裝sql前會(huì)對配置好的參數(shù)進(jìn)行轉(zhuǎn)型。如下：

復(fù)制代碼代碼如下:

<bean id="integerSetterHql" class="net.mlw.vlh.adapter.hibernate3.util.setter.IntegerSetter"></bean>
 <bean id="statementBuilderHql" class="net.mlw.vlh.adapter.hibernate3.util.StatementBuilder">
    <property name="setters">
     <map>
      <entry key="uId"><ref bean="integerSetterHql"/></entry>
                                     <entry key="oId"><ref bean="integerSetterHql"/></entry>
     </map>
    </property>
   </bean>