⊕注册本站 　⊕ 论坛 　⊕ 繁體中文

电脑技巧
手机 | MP3 | MP4 | 显卡 | 主板 | 显示器 | 光存储 | 笔记本 | 网络设备 | 移动存储 | 数码相机
键鼠 | CPU | 音箱 | GPS | 电视 | 服务器 | 投影机 | 机箱电源 | 品牌电脑 | 办公打印 |
| 网站首页 | Cisco | Windows | Linux | Java | Dotnet | Oracle | 网页设计 | 平面设计 | 安全 | 软件应用 | 电脑维修 | 办公维修 |
您现在的位置： 电脑技巧 >> Java >> 开源技术 >> Spring >> Java正文

Spring+Ibatis+事务处理
文章来源：中国IT实验室收集整理 作者：佚名 更新时间：2008-6-28 20:35:47 【大 小】 【加入收藏】

applicationContext.xml

    view plaincopy to clipboardprint?
    <?xml version="1.0" encoding="UTF-8"?>

    <beans xmlns="http://www.springframework.org/schema/beans"

        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">

        <bean id="dataSource"

            class="org.springframework.jdbc.datasource.DriverManagerDataSource">

            <property name="driverClassName">

                <value>oracle.jdbc.driver.OracleDriver</value>

            </property>

            <property name="url">

                <value>jdbc:oracle:thin:@172.17.7.191:1521:STRUTS</value>

            </property>

            <property name="username">

                <value>STRUTS</value>

            </property>

            <property name="password">

                <value>STRUTS</value>

            </property>

        </bean>

        <bean id="insertDao" class="flex.samples.spring.dao.InsertCl">

            <property name="sqlMapClient">

                <ref local="sqlMapClient" />

            </property>

        </bean>

        <bean name="insertAction"

            class="flex.samples.spring.action.InsertAction">

            <property name="insertService">

                <ref bean="insertService"/>

            </property>

        </bean>

        <bean id="insertService"

            class="flex.samples.spring.dao.InsertService">

            <property name="insertDao">

                <ref local="insertDao" />

            </property>

        </bean>

        <bean id="sqlMapClient"

            class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">

            <property name="configLocation">

                <value>

                    WEB-INF/SqlMapConfig.xml

                </value>

            </property>

            <property name="dataSource">

                <ref bean="dataSource" />

            </property>

        </bean>

        <bean name="logger"

            class="flex.samples.spring.interceptor.LoggingInterceptor">

        </bean>

        <bean name="beanNameAutoProxy"

            class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator" />

        <bean id="transactionProxy" parent="beanNameAutoProxy">

            <property name="beanNames">

                <list>

                    <value>insertService</value>

                </list>

            </property>

            <property name="interceptorNames">

                <value>transactionInterceptor</value>

            </property>

        </bean>

        <bean id="logginProxy" parent="beanNameAutoProxy">

            <property name="beanNames">

                <list>

                    <value>insertDao</value>

                </list>

            </property>

            <property name="interceptorNames">

                <value>logger</value>

            </property>

        </bean>

        <bean id="transactionManager"

            class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

            <property name="dataSource">

                <ref bean="dataSource" />

            </property>

        </bean>

        <bean id="transactionInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor">

           <property name="transactionManager">

               <ref local="transactionManager" />

           </property>

           <property name="transactionAttributes">

               <props>

                  <prop key="*">PROPAGATION_REQUIRED,-Exception</prop>

               </props>

           </property>

        </bean>

    </beans>

    <?xml version="1.0" encoding="UTF-8"?>

    <beans xmlns="http://www.springframework.org/schema/beans"

     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">

     <bean id="dataSource"

      class="org.springframework.jdbc.datasource.DriverManagerDataSource">

      <property name="driverClassName">

       <value>oracle.jdbc.driver.OracleDriver</value>

      </property>

      <property name="url">

       <value>jdbc:oracle:thin:@172.17.7.191:1521:STRUTS</value>

      </property>

      <property name="username">

       <value>STRUTS</value>

      </property>

      <property name="password">

       <value>STRUTS</value>

      </property>

     </bean>

 

    <bean id="insertDao" class="flex.samples.spring.dao.InsertCl">

      <property name="sqlMapClient">

       <ref local="sqlMapClient" />

      </property>

     </bean>

     <bean name="insertAction"

      class="flex.samples.spring.action.InsertAction">

      <property name="insertService">

             <ref bean="insertService"/>

          </property>

     </bean>

     <bean id="insertService"

      class="flex.samples.spring.dao.InsertService">

      <property name="insertDao">

       <ref local="insertDao" />

      </property>

     </bean>

     <bean id="sqlMapClient"

      class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">

      <property name="configLocation">

       <value>

        WEB-INF/SqlMapConfig.xml

       </value>

      </property>

      <property name="dataSource">

       <ref bean="dataSource" />

      </property>

     </bean>

     <bean name="logger"

         class="flex.samples.spring.interceptor.LoggingInterceptor">

       </bean>

     <bean name="beanNameAutoProxy"

      class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator" />

     <bean id="transactionProxy" parent="beanNameAutoProxy">

      <property name="beanNames">

       <list>

        <value>insertService</value>

       </list>

      </property>

      <property name="interceptorNames">

       <value>transactionInterceptor</value>

      </property>

     </bean>

     <bean id="logginProxy" parent="beanNameAutoProxy">

      <property name="beanNames">

       <list>

        <value>insertDao</value>

       </list>

      </property>

      <property name="interceptorNames">

       <value>logger</value>

      </property>

     </bean>

     <bean id="transactionManager"

      class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

      <property name="dataSource">

       <ref bean="dataSource" />

      </property>

     </bean>

        <bean id="transactionInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor">

           <property name="transactionManager">

               <ref local="transactionManager" />

           </property>

           <property name="transactionAttributes">

               <props>

                  <prop key="*">PROPAGATION_REQUIRED,-Exception</prop>

               </props>

           </property>

        </bean>

    </beans>InsertAction.java

    view plaincopy to clipboardprint?
    package flex.samples.spring.action;

    //import java.sql.Timestamp;

    //import java.text.SimpleDateFormat;

    import java.util.List;

    import flex.samples.spring.dao.InsertService;

    import flex.samples.spring.bean.UserBean;

    import flex.samples.spring.interceptor.LoggingInterceptor;

    import org.apache.commons.logging.*;

    public class InsertAction {

        //##############################################

        private Log log =LogFactory.getLog(LoggingInterceptor.class);

        private InsertService insertService;

        public InsertService getInsertService() {

            return this.insertService;

        }

        public void setInsertService(InsertService insertService) {

            this.insertService = insertService;

        }

        public void insertData(UserBean user,List edu,List pro_list) throws Exception{

            try{

                insertService.insertUserInfo(user, edu, pro_list);

            }catch (Exception e){

                log.info(e.toString());

                throw e;

            }

        }

    }

    package flex.samples.spring.action;

    //import java.sql.Timestamp;

    //import java.text.SimpleDateFormat;

    import java.util.List;

    import flex.samples.spring.dao.InsertService;

    import flex.samples.spring.bean.UserBean;

    import flex.samples.spring.interceptor.LoggingInterceptor;

    import org.apache.commons.logging.*;

    public class InsertAction {

     //##############################################

     private Log log =LogFactory.getLog(LoggingInterceptor.class);

     private InsertService insertService;

     public InsertService getInsertService() {

      return this.insertService;

     }

     public void setInsertService(InsertService insertService) {

      this.insertService = insertService;

     }

     public void insertData(UserBean user,List edu,List pro_list) throws Exception{

      try{

       insertService.insertUserInfo(user, edu, pro_list);

      }catch (Exception e){

       log.info(e.toString());

       throw e;

      }

     }

    }

    InsertCl.java

    view plaincopy to clipboardprint?
    package flex.samples.spring.dao;

    import java.util.List;

    import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

    import flex.samples.spring.bean.UserBean;

    public class InsertCl extends SqlMapClientDaoSupport implements InsertIn{

        public void deleteUserInfo(UserBean user){

            this.getSqlMapClientTemplate().update("del_data",user);

        }

        public void insertBaseInfo(UserBean user){

            this.getSqlMapClientTemplate().update("insUser",user);

        }

        public void insertDBInfo(UserBean user){

             this.getSqlMapClientTemplate().insert("insDB_Access",user);

             this.getSqlMapClientTemplate().insert("insDB_SQLserver",user);

             this.getSqlMapClientTemplate().insert("insDB_ORACLE",user);

             this.getSqlMapClientTemplate().insert("insDB_Informix",user);

             this.getSqlMapClientTemplate().insert("insDB_DB2",user);

             this.getSqlMapClientTemplate().insert("insDB_MySQL",user);

             this.getSqlMapClientTemplate().insert("insDB_otherdb",user);

        }

 

       public void insertOSInfo(UserBean user){

             this.getSqlMapClientTemplate().insert("insOS_Unix",user);

             this.getSqlMapClientTemplate().insert("insOS_Linux",user);

             this.getSqlMapClientTemplate().insert("insOS_MVS",user);

             this.getSqlMapClientTemplate().insert("insOS_WinXP",user);

             this.getSqlMapClientTemplate().insert("insOS_WinNT/2000",user);

             this.getSqlMapClientTemplate().insert("insOS_AS/400",user);

             this.getSqlMapClientTemplate().insert("insOS_otheros",user);

        }

        public void insertLangInfo(UserBean user){

             this.getSqlMapClientTemplate().insert("insLANG_C/C++/VC",user);

             this.getSqlMapClientTemplate().insert("insLANG_.NET",user);

             this.getSqlMapClientTemplate().insert("insLANG_COBOL",user);

             this.getSqlMapClientTemplate().insert("insLANG_VB",user);

             this.getSqlMapClientTemplate().insert("insLANG_JAVA/JSP",user);

             this.getSqlMapClientTemplate().insert("insLANG_Apache",user);

             this.getSqlMapClientTemplate().insert("insLANG_Weblogic",user);

             this.getSqlMapClientTemplate().insert("insLANG_Framework",user);

             this.getSqlMapClientTemplate().insert("insLANG_UML",user);

        }

        public void insertEduInfo(List edu){

             for(int i=0;i<edu.size();i++){

                 this.getSqlMapClientTemplate().insert("insEdu",edu.get(i));

             }

        }

        public void insertProInfo(List pro_list){

             for(int i=0;i<pro_list.size();i++){

                 this.getSqlMapClientTemplate().insert("insPro",pro_list.get(i));

             }

        }

    }

    package flex.samples.spring.dao;

    import java.util.List;

    import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

    import flex.samples.spring.bean.UserBean;

    public class InsertCl extends SqlMapClientDaoSupport implements InsertIn{

     public void deleteUserInfo(UserBean user){

      this.getSqlMapClientTemplate().update("del_data",user);

     }

     public void insertBaseInfo(UserBean user){

      this.getSqlMapClientTemplate().update("insUser",user);

     }

     public void insertDBInfo(UserBean user){

       this.getSqlMapClientTemplate().insert("insDB_Access",user);

       this.getSqlMapClientTemplate().insert("insDB_SQLserver",user);

       this.getSqlMapClientTemplate().insert("insDB_ORACLE",user);

       this.getSqlMapClientTemplate().insert("insDB_Informix",user);

       this.getSqlMapClientTemplate().insert("insDB_DB2",user);

       this.getSqlMapClientTemplate().insert("insDB_MySQL",user);

       this.getSqlMapClientTemplate().insert("insDB_otherdb",user);

     }

     public void insertOSInfo(UserBean user){

       this.getSqlMapClientTemplate().insert("insOS_Unix",user);

       this.getSqlMapClientTemplate().insert("insOS_Linux",user);

       this.getSqlMapClientTemplate().insert("insOS_MVS",user);

       this.getSqlMapClientTemplate().insert("insOS_WinXP",user);

       this.getSqlMapClientTemplate().insert("insOS_WinNT/2000",user);

       this.getSqlMapClientTemplate().insert("insOS_AS/400",user);

       this.getSqlMapClientTemplate().insert("insOS_otheros",user);

     }

     public void insertLangInfo(UserBean user){

       this.getSqlMapClientTemplate().insert("insLANG_C/C++/VC",user);

       this.getSqlMapClientTemplate().insert("insLANG_.NET",user);

       this.getSqlMapClientTemplate().insert("insLANG_COBOL",user);

       this.getSqlMapClientTemplate().insert("insLANG_VB",user);

       this.getSqlMapClientTemplate().insert("insLANG_JAVA/JSP",user);

       this.getSqlMapClientTemplate().insert("insLANG_Apache",user);

       this.getSqlMapClientTemplate().insert("insLANG_Weblogic",user);

       this.getSqlMapClientTemplate().insert("insLANG_Framework",user);

       this.getSqlMapClientTemplate().insert("insLANG_UML",user);

     }

     public void insertEduInfo(List edu){

       for(int i=0;i<edu.size();i++){

        this.getSqlMapClientTemplate().insert("insEdu",edu.get(i));

       }

     }

     public void insertProInfo(List pro_list){

       for(int i=0;i<pro_list.size();i++){

        this.getSqlMapClientTemplate().insert("insPro",pro_list.get(i));

       }

     }

    }

    SqlMapConfig.xml

    view plaincopy to clipboardprint?
    <?xml version="1.0" encoding="UTF-8"?>

    <!DOCTYPE sqlMapConfig

        PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"

        "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

    <sqlMapConfig>

           <sqlMap resource="flex/samples/spring/xml/test.xml"/>

    </sqlMapConfig>

  • 上一篇Java：

  • 下一篇Java：
    • 最 新 热 门
     手机开发平台指南、教程和资料介绍
     关于什么叫面向接口编程
     编写高级JavaScript应用代码
     不要验证，直接转化科学计数法
     Eclipse插件开发中实现刷新和重编译介绍
     Java开源技术：Eclipse的使用技巧详解
     配置eclipse 3.2 使用JDK1.5中文JavaAPI
     集成Windows本地应用到Eclipse RCP 程序中
     hibernate.cfg.xml配置文件的说明
     eclipse开发jface时,main.class解决方法
    最 新 推 荐
     ibatis+spring 集成
     结合Spring2.0和ActiveMQ进行异步消息调用
     servlet中如何访问spring容器
     Spring MVC与struts比较
     Spring security 命名空间的使用
     spring AOP面向切面编程
     关于String对象解析
     关于Spring切点函数@args()
     Spring中事务的传播属性详解
     Spring+Ibatis+事务处理
    相 关 文 章

    编写高级JavaScript应用代码
    ibatis+spring 集成
    结合Spring2.0和ActiveMQ进行异步消息调用
    servlet中如何访问spring容器
    Spring MVC与struts比较
    Spring security 命名空间的使用
    spring AOP面向切面编程
    关于String对象解析
    关于Spring切点函数@args()
    Spring中事务的传播属性详解

    | 设为首页 | 加入收藏 | 联系站长 | 友情链接 | 版权申明 | 网站公告
    　

    Copyright 2006-2008 pcjx.com All Rights Reserved
    电脑技巧　版权所有 粤ICP备06059145号 地图
    本网站所有内容未经许可不得转载或做其他使用