spring mybatis集成添加数据事务回滚了是我的配置出错了吗求解啊

0 0

spring mybatis集成添加数据事务回滚了是我的配置出错了吗求解啊10

spring和mybatis集成添加一条数据数据回滚了看日志打印了sql语句数据库但没有数据这是怎么回事了
我的配置：

	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<property name="driverClassName" value="${jdbc.driverClassName}"/>
		<property name="url" value="${jdbc.url}"/>
		<property name="username" value="${jdbc.username}"/>
		<property name="password" value="${jdbc.password}"/>
	</bean>
	
	<bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="configLocation" value="classpath:SqlMapConfig.xml"/>
	</bean>
    
    <bean id="myTransaction" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
				<property name="dataSource" ref="dataSource"/>
	</bean>
	<tx:advice id="myadvice" transaction-manager="myTransaction">
        <tx:attributes>
            <tx:method name="get*" read-only="true"/>
            <tx:method name="list*" read-only="true"/>
        	<tx:method name="add*" propagation="REQUIRED"/>
			<tx:method name="del*" propagation="REQUIRED"/>
			<tx:method name="edit*" propagation="REQUIRED"/>
            <tx:method name="*"/>
        </tx:attributes>
	</tx:advice>
	<aop:config>
		<aop:pointcut id="bizmethod" expression="execution(* com.bfly.ec.service.impl.*.*(..))"/>
		<aop:advisor pointcut-ref="bizmethod" advice-ref="myadvice"/>
	</aop:config>

	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.bfly.ec.mapper"/>
	</bean>
		
	<import resource="applicationContext-*.xml"/>
</beans>

代码：

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.annotation.Resource;

import com.bfly.common.page.Pager;
import com.bfly.ec.entity.GoodsMsg;
import com.bfly.ec.mapper.GoodsMsgMapper;
import com.bfly.ec.service.IGoodsMsgService;

public class GoodsMsgServiceImpl implements IGoodsMsgService {

	@Resource
	private GoodsMsgMapper goodsMsgMapper;
	
	public int addGoodsMsg(GoodsMsg goodsMsg) {
		return goodsMsgMapper.saveGoodsMsg(goodsMsg);
	}
	public Map<String, Integer> getGoodsPercent(int goodsId){
		Map<String, Integer> map=goodsMsgMapper.getGoodsPercent(goodsId);
		int count=map.get("countnum");
		int value=0;
		for (String key:map.keySet()) {
			if(key.equalsIgnoreCase("countnum"))
			{
				continue;
			}
			value=Math.round(map.get(key)/(float)count*100);
			map.put(key, value);
		}
		return map;
	}
	
	public int getCountMsg(int propId) {
		Map<String,Object> map=new HashMap<String, Object>();
		map.put("goodsId",propId);
		return goodsMsgMapper.getCountMsg(map);
	}
}

打印的日志：

18:26:16,546 DEBUG saveGoodsMsg:47 - ooo Using Connection [jdbc:sqlserver://127.0.0.1:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=bfly_ec;applicationName=Microsoft SQL Server JDBC Driver;, UserName=hulibo, Microsoft SQL Server JDBC Driver 3.0]
18:26:16,546 DEBUG saveGoodsMsg:47 - ==> Preparing: insert into goods_msg(user_id,username,email,msg_title,msg_content,goods_start,msg_date,goods_id,status,type_id) values(?,?,?,?,?,?,?,?,?,?);
18:26:16,546 DEBUG saveGoodsMsg:47 - ==> Parameters: 1(Integer), hulibo(String), fsdfsd(String), 对 '高清液晶电视LCD-32L100AS购买即返1000积分'的评价(String), sdfsdfsd(String), 3(Integer), 2012-05-17 18:26:16.546(Timestamp), 5(Integer), 0(Integer), 67(Integer)

iBATIS