Spring+ibatis+c3p0+aop事务管理整合配置样例
?各框架版本? spring 2.5
?????????????????? ibatis-2.3.4.726
?????????????????? c3p0? 0.9
?
?
事务管理由spring的aop配置完成，事务封装在service层。? Dao层操作数据库由ibatis的模板封装类SqlMapClientTemplate完成。
?
package com.surfilter.collector.dao.impl;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.orm.ibatis.SqlMapClientTemplate;import org.springframework.stereotype.Repository;import com.surfilter.collector.bean.ForumTopic;import com.surfilter.collector.dao.base.ForumTopicDao;@Repositorypublic class ForumTopicDaoImpl implements ForumTopicDao {@Autowiredprivate SqlMapClientTemplate sqlMapClientTemplate;@Overridepublic void addForumTopic(ForumTopic forumTopic) {Object obj= sqlMapClientTemplate.insert("addForumTopic", forumTopic); if(obj!=null){ forumTopic.setId((Integer)obj); } }@Overridepublic int findForumTopicCount(String keyID) {return (Integer) sqlMapClientTemplate.queryForObject("findForumTopicCount", keyID);}@Overridepublic ForumTopic findForumTopicByID(int id) {return (ForumTopic)sqlMapClientTemplate.queryForObject("findForumTopicByID", id);}@Overridepublic void updateForumTopic(ForumTopic forumTopic) {sqlMapClientTemplate.update("updateForumTopic", forumTopic);}@SuppressWarnings("unchecked") @Override public List<ForumTopic> findForumTopics(ForumTopic forumTopic) { return sqlMapClientTemplate.queryForList("findForumTopics", forumTopic); }@SuppressWarnings("unchecked")@Overridepublic List<ForumTopic> findForumTopicsByForumTopic(ForumTopic forumTopic) {return sqlMapClientTemplate.queryForList("findForumTopicsByForumTopic",forumTopic);}@Overridepublic Integer findForumTopicsByForumTopicCount(ForumTopic forumTopic) {return (Integer) sqlMapClientTemplate.queryForObject("findForumTopicsByForumTopicCount",forumTopic);}}?
