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
麻雀虽小,五脏俱全了。
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
麻雀虽小,五脏俱全了。