spring+ibatis事务处理配置

╰半夏微凉° 2022-09-28 01:42 180阅读 0赞

（1）applicationContext-resources.xml 配数据源：

<beans>

（2）applicationContext-ibatis.xml  符合Ibatis的DAO配置：

<beans>  
      
    <bean id="transactionManager"  
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
        <property name="dataSource" ref="dataSource"/>  
    </bean>  
     
      
    <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">  
        <property name="configLocation">  
            <value>classpath:/com/aigomusic/dao/ibatis/sql-map-config.xml</value>  
        </property>  
        <property name="dataSource" ref="dataSource"/>  
    </bean>

<bean id="dao" class="com.aigomusic.dao.ibatis.BaseDaoIbatis">  
        <property name="dataSource" ref="dataSource"/>  
        <property name="sqlMapClient" ref="sqlMapClient"/>  
    </bean>  
     
      
    <bean id="ammRingtoneDao" class="com.aigomusic.dao.ibatis.AmmRingtoneDaoIbatis">  
        <property name="dataSource" ref="dataSource"/>  
        <property name="sqlMapClient" ref="sqlMapClient"/>  
    </bean>  
     
      
    <bean id="ammImageDao" class="com.aigomusic.dao.ibatis.AmmImageDaoIbatis">  
        <property name="dataSource" ref="dataSource"/>  
        <property name="sqlMapClient" ref="sqlMapClient"/>  
    </bean>  
</beans>

（3）AmmImageDaoIbatis.java  符合Ibatis的DAO实现代码：

public class AmmImageDaoIbatis extends BaseDaoIbatis implements AmmImageDao \{  
 /\*\*  
  \* 测试成功  
  \*/  
 public AmmImage getAmmImage(String fringmodelid) \{  
  return (AmmImage) getSqlMapClientTemplate().queryForObject(  
    "getAmmImage", fringmodelid);  
 \}

/\*\*  
  \* 测试成功  
  \*/  
 public AmmImagePage getAmmImages(AmmImagePage ammImagePage) \{  
  ammImagePage.handlePage(Integer  
    .parseInt((String) getSqlMapClientTemplate().queryForObject(  
      "getAmmImagesCount", ammImagePage)),  
    ammImagePage.getPageNo(), ammImagePage.getPageSize());  
  ammImagePage.setItemList(getSqlMapClientTemplate().queryForList(  
    "getAmmImages", ammImagePage));  
  return ammImagePage;  
 \}

/\*\*  
  \* 测试成功  
  \*/  
 public AmmImagePage getDownloadRate(AmmImagePage ammImagePage) \{  
  if(ammImagePage==null)\{ammImagePage=new AmmImagePage();\}  
  ammImagePage.handlePage(ammImagePage.getItemCount(),ammImagePage.getPageNo(), ammImagePage.getPageSize());  
  ammImagePage.setItemList(getSqlMapClientTemplate().queryForList(  
    "getAmmImages\_ByDownloadRate", ammImagePage));  
  return ammImagePage;  
 \}

public AmmImagePage getComsumeRate() \{  
  AmmImagePage ammImagePage = new AmmImagePage();  
  ammImagePage.setItemList(getSqlMapClientTemplate().queryForList(  
    "getMobileNumbers\_ByComsumeRate", null));  
  return ammImagePage;  
 \}

（4）applicationContext-service.xml  业务接口配置文件

<beans>

<bean id="manager" class="com.aigomusic.service.impl.BaseManager">  
  <property name="dao" ref="dao" />  
 </bean>

</beans>

（5）AmmImageManagerImpl.java  MANAGER实现代码：

public class AmmImageManagerImpl extends BaseManager implements  
  AmmImageManager \{  
 private AmmImageDao ammImageDao;

public void setAmmImageDao(AmmImageDao ammImageDao) \{  
  this.ammImageDao = ammImageDao;  
 \}

public AmmImage getAmmImage(String fringmodelid) \{  
  return (AmmImage)ammImageDao.getAmmImage(fringmodelid);  
 \}

public AmmImagePage getAmmImages(AmmImagePage ammImagePage) \{  
  return (AmmImagePage)ammImageDao.getAmmImages(ammImagePage);  
 \}

public AmmImagePage getDownloadRate(AmmImagePage ammImagePage) \{  
  return (AmmImagePage)ammImageDao.getDownloadRate(ammImagePage);  
 \}

public AmmImagePage getComsumeRate() \{  
  return (AmmImagePage)ammImageDao.getComsumeRate();  
 \}