Spring实战之使用XML方式管理声明式事务操作示例

2023-08-03 02:34:04 79

本文实例讲述了Spring实战之使用XML方式管理声明式事务操作。分享给大家供大家参考，具体如下：

一配置文件

二DAO

1接口

packageorg.crazyit.app.dao;
publicinterfaceNewsDao
{
publicvoidinsert(Stringtitle,Stringcontent);
}

2实现类

packageorg.crazyit.app.dao.impl;
importjavax.sql.DataSource;
importjava.sql.Connection;
importorg.springframework.jdbc.core.JdbcTemplate;
importorg.crazyit.app.dao.*;
publicclassNewsDaoImplimplementsNewsDao
{
privateDataSourceds;
publicvoidsetDs(DataSourceds)
{
this.ds=ds;
}
publicvoidinsert(Stringtitle,Stringcontent)
{
JdbcTemplatejt=newJdbcTemplate(ds);
jt.update("insertintonews_inf"
+"values(null,?,?)"
,title,content);
//两次插入的数据违反唯一键约束
jt.update("insertintonews_inf"
+"values(null,?,?)"
,title,content);
//如果没有事务控制，则第一条记录可以被插入
//如果增加事务控制，将发现第一条记录也插不进去。
}
}

三测试类

packagelee;
importorg.springframework.context.support.*;
importorg.springframework.context.*;
importorg.crazyit.app.dao.*;
publicclassSpringTest
{
publicstaticvoidmain(String[]args)
{
//创建Spring容器
ApplicationContextctx=new
ClassPathXmlApplicationContext("beans.xml");
//获取事务代理Bean
NewsDaodao=(NewsDao)ctx
.getBean("newsDao",NewsDao.class);
//执行插入操作
dao.insert("疯狂Java","轻量级JavaEE企业应用实战");
}
}

四测试结果

数据没插入到数据库，说明事务生效

Exceptioninthread"main" org.springframework.dao.DuplicateKeyException: PreparedStatementCallback;SQL[insertintonews_inf values(null,?,?)];Duplicateentry'疯狂Java'forkey 'news_title';nestedexceptionis com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:Duplicateentry'疯狂Java'forkey'news_title'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:909)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:970)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:980)
at org.crazyit.app.dao.impl.NewsDaoImpl.insert(NewsDaoImpl.java:33)
atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
atjava.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
atcom.sun.proxy.$Proxy5.insert(UnknownSource)
atlee.SpringTest.main(SpringTest.java:28)
Causedby: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:Duplicateentry'疯狂Java'forkey'news_title'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
atcom.mysql.jdbc.Util.handleNewInstance(Util.java:409)
atcom.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
atcom.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:147)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:916)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:909)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)

更多关于java相关内容感兴趣的读者可查看本站专题：《Spring框架入门与进阶教程》、《Java数据结构与算法教程》、《Java操作DOM节点技巧总结》、《Java文件与目录操作技巧汇总》和《Java缓存操作技巧汇总》

希望本文所述对大家java程序设计有所帮助。

声明：本文内容来源于网络，版权归原作者所有，内容由互联网用户自发贡献自行上传，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任。如果您发现有涉嫌版权的内容，欢迎发送邮件至：czq8825#qq.com（发邮件时，请将#更换为@）进行举报，并提供相关证据，一经查实，本站将立刻删除涉嫌侵权内容。

Spring实战之使用XML方式管理声明式事务操作示例

热门推荐

随机推荐