SSI全套配置（Struts2.1+Spring3+Ibatis2.3）

1.web.xml *****************************************************************************************

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
 xmlns="http://java.sun.com/xml/ns/javaee"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
 http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  <filter>
   <filter-name>struts2</filter-name>
   <filter-class>
    org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
   </filter-class>
  </filter>
  <filter-mapping>
   <filter-name>struts2</filter-name>
   <url-pattern>*.action</url-pattern>
  </filter-mapping>
 
  <!-- 加载applicationContext.xml文件 -->
 <context-param>
  <param-name>contextConfigLocation</param-name>
  <param-value>/WEB-INF/applicationContext-main.xml</param-value>
 </context-param>

 <!-- 配置spring监听 -->
 <listener>
  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
 </listener>

 <!-- Spring 刷新Introspector防止内存泄露 -->
 <listener>
  <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
 </listener>
 
 <!-- 字符编码过滤器 -->
 <filter>
  <filter-name>Set Character Encoding</filter-name>
  <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  <init-param>
   <param-name>encoding</param-name>
   <param-value>UTF-8</param-value>
  </init-param>
 </filter>
 <filter-mapping>
  <filter-name>Set Character Encoding</filter-name>
  <url-pattern>/*</url-pattern>
 </filter-mapping>
 
  </web-app>

2.applicationContext-main.xml **********************************************************************************************

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
 xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"  
    xmlns:jaxws="http://cxf.apache.org/jaxws" 
 xsi:schemaLocation="http://www.springframework.org/schema/beans
 http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
 http://www.springframework.org/schema/aop
 http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
 http://www.springframework.org/schema/tx
 http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
 http://cxf.apache.org/jaxwshttp://cxf.apache.org/schemas/jaxws.xsd
 " default-autowire="byName">
 <!-- 数据源 --> 
 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">  
  <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
  <property name="url" value="jdbc:mysql://localhost:3306/testdb"></property>
  <property name="username" value="root"></property>
  <property name="password" value="123"></property>
  <property name="minIdle" value="2"></property>
  <property name="maxIdle" value="50"></property>
  <property name="maxActive" value="90"></property>
 </bean>
 <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
  <property name="configLocation" value="WEB-INF/sql-map-config.xml" />
  <property name="dataSource" ref="dataSource" />
 </bean>
 
 <bean id="transactionManager"
  class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  <property name="dataSource" ref="dataSource" />
 </bean>
 
 <!-- 事物管理 -->
 <bean id="myTransaction"
  class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  <property name="dataSource" ref="dataSource"></property>
 </bean>

 <tx:advice id="myAdvice" transaction-manager="myTransaction">
  <tx:attributes>
   <tx:method name="*" propagation="REQUIRED"/>
  </tx:attributes>
 </tx:advice> 
  
 <!-- <tx:advice id="myAdvice" transaction-manager="myTransaction">
  <tx:attributes>
   <tx:method name="insert*" propagation="REQUIRED" rollback-for="Exception"/>
      <tx:method name="update*" propagation="REQUIRED" rollback-for="Exception"/>
      <tx:method name="delete*" propagation="REQUIRED"/>
      <tx:method name="valid*" propagation="REQUIRED"/>
      <tx:method name="remove*" propagation="REQUIRED" rollback-for="Exception"/>
      <tx:method name="query*" read-only="true"/>
      <tx:method name="count*" read-only="true"/>
  </tx:attributes>
 </tx:advice> -->

 <aop:config>
  <aop:pointcut id="myPointcut"
   expression="execution(* com.test.service.impl.*.*(..))" />
  <aop:advisor pointcut-ref="myPointcut" advice-ref="myAdvice" />
 </aop:config>
   
 <!-- DAO -->  
 <bean id="userDao" class="com.test.dao.impl.UserDaoImpl">
  <property name="sqlMapClient" ref="sqlMapClient"/>
 </bean>
 
 <!-- Struts -->
 <bean id="userAction" class="com.test.struts.UserAction">
  <property name="userDao" ref="userDao" />
 </bean>
 
</beans>

3.sql-map-config.xml **********************************************************************************

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
    "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
 <settings cacheModelsEnabled="true" enhancementEnabled="true"
  lazyLoadingEnabled="true" maxRequests="512" maxSessions="128"
  maxTransactions="32" useStatementNamespaces="true" /> 
 <sqlMap resource="com/test/dao/sqlMap/Test.xml" />
</sqlMapConfig>

4.Test.xml ****************************************************************************************************

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
 "http://ibatis.apache.org/dtd/sql-map-2.dtd" >

<!-- Always ensure to use the correct XML header as above! -->
<sqlMap namespace="TestSql">
<typeAlias alias="userBase" type="com.test.vo.UserBase"/>
<resultMap id="userid" class="userBase">
    <result property="username" column="username"/>
    <result property="password" column="password"/>
    <result property="email" column="email"/>
</resultMap>
<select id="getUserById" resultClass="userBase">
 select * from user_base u where u.userid = #userId#
</select>

</sqlMap>

 

5.struts.properties **************************************************************************

struts.objectFactory =spring
struts.enable.DynamicMethodInvocation=true
#指定Struts 2处于开发状态
struts.devMode=true
struts.serve.static.browserCache=false
#该属性指定Http的请求后缀
struts.action.extension=action
struts.multipart.saveDir=/tmp
struts.custom.i18n.resources=globalMessages
#指定当Struts 2配置文件改变后，Web框架是否重新加载Struts 2配置文件
struts.configuration.xml.reload=true
#设置字符集
struts.i18n.encoding=UTF-8

6.struts.xml **************************************************************************************

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.1//EN" "http://struts.apache.org/dtds/struts-2.1.dtd">
<struts>
 <!-- <constant name="struts.objectFactory" value="spring"/> -->
 <include file="struts-default.xml" />

 <package name="struts" namespace="/users" extends="struts-default">
  <action name="user_*" class="userAction" method="{1}">
   <result name="success">/index.jsp</result>
   <result name="error">/login.jsp</result>
  </action>   
 </package>
 </struts> 

7.com.test.dao.impl.UserDaoImpl.java *********************************************************************************************

public class UserDaoImpl extends SqlMapClientDaoSupport implements UserDAO
{

 /* (non-Javadoc)
  * @see com.test.dao.UserDAO#getUserById(int)
  */
 public UserBase getUserById(int userId)
 {
  UserBase user = (UserBase)getSqlMapClientTemplate().queryForObject("TestSql.getUserById", userId);
  return user;
 }

}

8. log4j.properties *******************************************把Ibatis SQL通过Log4j显示到控制台*************************

log4j.rootLogger=INFO, stdout
#log4j.rootLogger=INFO, stdout, logfile
log4j.logger.com.ibatis=DEBUG
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=[%d] [%-5p] %c %m %n

 

麻雀虽小，五脏俱全了。