SpringMVC+JdbcTemplate實作事務管理（插入操作需要傳回自增字段）

将Service層交給事務去管理，beans.xml配置如下：

<!-- 配置Jdbc模闆 -->

 <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">

  <property name="dataSource" ref="dataSource"></property>

 </bean>

 <bean id="transactionManager"

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

  <property name="dataSource" ref="dataSource"></property>

 </bean>

 <tx:advice id="txAdvice" transaction-manager="transactionManager">

  <tx:attributes>

   <tx:method name="*" />

  </tx:attributes>

 </tx:advice>

 <aop:config>

  <aop:pointcut id="serviceMethod" expression="execution(* dmmap.service.*.*(..))" />

  <aop:advisor advice-ref="txAdvice" pointcut-ref="serviceMethod" />

 </aop:config>

如果需要傳回自增字段，插入過程如下：

public int createHousedoor(Housedoor housedoor) {

  int newId = 0;

  final Housedoor TmpDoor = housedoor;

  String issueDateStr = housedoor.getF_IssueDateStr();

  Date issueDate = null;

  if (issueDateStr != null) {

   try {

    issueDate = sdf.parse(issueDateStr);

   } catch (ParseException e) {

    e.printStackTrace();

   }

  }

  final Date _date = issueDate;

  KeyHolder keyholder = new GeneratedKeyHolder();

  final String insertsql = "insert into t_housedoor(F_TownId,F_Community,F_PropertyName,F_HouseEstate,F_BuildingNum,F_CellNum,F_RoomNum,F_DoorNum,F_MarkSizeId,F_SourceTypeId,F_Contact,F_Telephone,F_OldAddress,F_Remark,F_UserId,F_OptDate,F_bImport,F_CardId,F_IssueDate,F_Address) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

  int countt = 0;

  countt = jdbcTemplate.update(new PreparedStatementCreator() {

   @Override

   public PreparedStatement createPreparedStatement(Connection con)

     throws SQLException {

    // TODO Auto-generated method stub

    PreparedStatement preState = con.prepareStatement(insertsql,

      PreparedStatement.RETURN_GENERATED_KEYS);

    preState.setString(1, TmpDoor.getF_TownId());

    preState.setString(2, TmpDoor.getF_Community());

    preState.setString(3, TmpDoor.getF_PropertyName());

    preState.setString(4, TmpDoor.getF_HouseEstate());

    preState.setString(5, TmpDoor.getF_BuildingNum());

    preState.setString(6, TmpDoor.getF_CellNum());

    preState.setString(7, TmpDoor.getF_RoomNum());

    preState.setString(8, TmpDoor.getF_DoorNum());

    preState.setInt(9, TmpDoor.getF_MarkSizeId());

    preState.setInt(10, TmpDoor.getF_SourceTypeId());

    preState.setString(11, TmpDoor.getF_Contact());

    preState.setString(12, TmpDoor.getF_Telephone());

    preState.setString(13, TmpDoor.getF_OldAddress());

    preState.setString(14, TmpDoor.getF_Remark());

    preState.setString(15, TmpDoor.getF_UserId());

    preState.setDate(16, new java.sql.Date(new Date().getTime()));

    preState.setInt(17, TmpDoor.getF_bImport());

    preState.setString(18, TmpDoor.getF_CardId());

    if (_date == null)

     preState.setDate(19, null);

    else

     preState.setDate(19, new java.sql.Date(_date.getTime()));

    preState.setString(20, TmpDoor.getF_Address());

    return preState;

   }

  }, keyholder);

  if (countt == 1) {

   newId = (int) keyholder.getKey().longValue();

  }

  return newId;

}

上述代碼中标紅的地方一定不能讓jdbcTemplate自己去擷取，否則事務不起作用。

另外需要注意的是，在service的方法中調用dao層的方法，dao層方法中不能捕獲異常，否則service端檢測不到異常事務無法復原