hibernate打印sql却没有插入数据库

Michael54324 2016-09-13 06:31:00

刚学ssh遇到的问题，hibernate打印sql却没有插入数据库，一开始网上查了一下，大部分人说事务没有配置事务自动提交，但是设置<prop key="connection.autocommit">true</prop>并没有解决问题，请论坛的各位大神不吝赐教，谢谢各位了~
以下是代码

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

<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">


<context:property-placeholder location="classpath:jdbc.properties" />


<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}" />
<property name="jdbcUrl" value="${jdbc.url}" />
<property name="user" value="${jdbc.user}" />
<property name="password" value="${jdbc.password}" />

</bean>


<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

<property name="dataSource" ref="dataSource" />
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="connection.autocommit">false</prop>
<prop key="connection.provider_class">
org.hibernate.connection.C3P0ConnectionProvider
</prop>
<prop key="c3p0.min_size">5</prop>
<prop key="c3p0.max_size">20</prop>
<prop key="c3p0.timeout">120</prop>
<prop key="c3p0.idle_test_period">3000</prop>
</props>
</property>


<property name="mappingResources">
<list>
<value>cn/itcast/user/User.hbm.xml</value>
</list>
</property>
</bean>


<bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean>


<bean id="indexAction" class="cn.itcast.index.IndexAction" scope="prototype"></bean>
<bean id="userAction" class="cn.itcast.user.UserAction" scope="prototype">
<property name="userService" ref="userService" />
</bean>

<bean id="userService" class="cn.itcast.user.UserService">
<property name="userDao" ref="userDao" />
</bean>

<bean id="userDao" class="cn.itcast.user.UserDao">
<property name="sessionFactory" ref="sessionFactory" />
</bean>

<tx:annotation-driven transaction-manager="transactionManager" />
</beans>
--------------------------------------------------------------------------------------------------------------
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class UserDao extends HibernateDaoSupport{

public void save(User user) {
// TODO Auto-generated method stub
this.getHibernateTemplate().save(user);

}

}

--------------------------------------------------------------------------------------------------------------
import org.springframework.transaction.annotation.Transactional;

import utils.UUIDUtils;

@Transactional
public class UserService {

private UserDao userDao;

public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}

public void regist(User user) {
// TODO Auto-generated method stub
user.setState(0);
user.setCode(UUIDUtils.getUUID());
userDao.save(user);
}

}

-----------------------------------------------------------------------------------------------------

控制台打印的结果：
Hibernate:
insert
into
user
(username, password, name, email, phone, addr, sex, state, code)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)

...全文