webwork+spring+ibatis简单实例

webwork.properties

 

# extension for actions
webwork.action.extension=action

# spring integration
webwork.objectFactory=spring
webwork.objectFactory.spring.autoWire=type

 

web.xml

 

 <context-param>
  <param-name>contextConfigLocation</param-name>
  <param-value>/WEB-INF/applicationContext.xml</param-value>
 </context-param>

 <listener>
  <listener-class>
   org.springframework.web.context.ContextLoaderListener
  </listener-class>
 </listener>
 
 <servlet>
  <servlet-name>webwork</servlet-name>
  <servlet-class>
   com.opensymphony.webwork.dispatcher.ServletDispatcher
  </servlet-class>
 </servlet>

 <servlet-mapping>
  <servlet-name>webwork</servlet-name>
  <url-pattern>*.action</url-pattern>
 </servlet-mapping>

 

applicationContext.xml

 

 

 <bean id="myDataSource"
  class="org.springframework.jndi.JndiObjectFactoryBean">
  <property name="jndiName">
   <value>java:comp/env/webglDS</value>
  </property>
 </bean>

 <bean id="sqlMapClient"
  class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
  <property name="configLocation"
   value="/WEB-INF/SqlMapConfig.xml" />
  <property name="dataSource" ref="myDataSource" />
 </bean>
 
 <bean id="baseDao" class="com.ufgov.adpm.dao.impl.OracleDao">
  <property name="sqlMapClient" ref="sqlMapClient" />
 </bean>
 <bean id="accountInfoService" class="com.ufgov.adpm.service.impl.AccountInfoServiceImpl">
  <property name="baseDao" ref="baseDao"></property>
 </bean>
 
 <bean id="accountInfoAction" class="com.ufgov.adpm.action.AccountInfoAction">
  <property name="accountInfoService" ref="accountInfoService"></property>
 </bean>

 

 

SqlMapConfig.xml

 

<sqlMapConfig>
 <settings cacheModelsEnabled="false" enhancementEnabled="true"
  lazyLoadingEnabled="false" errorTracingEnabled="true"
  useStatementNamespaces="true" />
  
 <typeHandler jdbcType="CLOB" javaType="java.lang.String"
  callback="org.springframework.orm.ibatis.support.ClobStringTypeHandler" />
  
 <sqlMap resource="sqlmap/adpm-listPage.xml" />

 
</sqlMapConfig>

 

 

adpm-listPage.xml

 

<sqlMap namespace="adpm-listPage">
 <select id="getAccountInfoFromADPM_CPA_INFO" resultClass="com.ufgov.adpm.model.AccountInfo" parameterClass="map">
  SELECT * FROM ADPM_CPA_INFO T
  <dynamic prepend="WHERE">
   <isNotNull prepend="AND" property="ID_NUM">
    T.ID_NUM=#ID_NUM#
   </isNotNull>
   <isNotNull prepend="AND" property="NAME">
    T.NAME=#NAME#
   </isNotNull>
  </dynamic>
 </select>
</sqlMap>