spring3之JdbcTemplate AOP 事務(wù)

1、spring3之jdbctemplate aop 事務(wù)一、appliioncontt.xml配置：定義事務(wù)和aop !- 定義事務(wù)傳揚(yáng)屬性 - tx:advice ="txadvice" ansaction-manager="txmanager" tx:attributes tx:method name="get*" propagation="not_supported" read-only="true"/ tx:method name="*" / /tx:attribute

2、s /tx:advice tx:annotation-driven transaction-manager="txmanager"/ !-aop錯(cuò)誤引入spring.jar- aop:config !- 描述切入點(diǎn) - 1）exeion(* *(.) 表示匹配全部辦法 2）execution(public * com. savage.service.userservice.*(.) 表示匹配com.savage.server.userservice中全部的公有辦法 3）execution(* com.savage.server.*.*(.) 表示匹配com.savage.s

3、erver包及其子包下的全部辦法 aop:pointcut id="transactionpointcut" ession="execution(* .ssm.dao2.*.*(.)"/ aop:advisor pointcut-ref="transactionpointcut" advice-ref="txadvice"/ /aop:config 二、實(shí)現(xiàn)類userdaoimpl.java transactional public class userdaoimpl implements userdao tran

4、sactional(rollbackfor = exception.class) public void insertuser() throws exception jdbctemplate.up("insert into user (name) values ('01');"); jdbctemplate.update("update user name=a where id=0;"); 三、test.java 測試 public ic void main(string args) throws exception applicatio

5、ncontext context = new classpathxmlapplicationcontext("applicationcontext_1.xml"); userdao userdaoimpl = (userdao) context.getbean("userdaoimpl"); userdaoimpl.insertuser(); 測試結(jié)果： init： deps-mole-jar： deps-ear-jar： deps-jar： compile-single： run-main： 2011-11-26 1:22:38 org.springf

6、ramework.context.pport.abstractapplicationcontext preparerefresh 信息: refreshing org.springframework.context.support.classpathxmlapplicationcontext1608e05: startup date sat nov 26 01:22:38 cst 2011; root of context hierarchy 2011-11-26 1:22:38 org.springframework.beans.factory.xml.xmlbeandefinitionre

7、ader loadbeandefinitions 信息: loading xml bean definitions from class path resource applicationcontext_1.xml 2011-11-26 1:22:38 org.springframework.beans.factory.support.defaultlistablebeanfactory preinstantiatesingletons 信息: pre-instantiating singletons in org.springframework.beans.factory.support.d

8、efaultlistablebeanfactory107ebe1: defining beans datasource,txmanager,txadvice,ernalautoproxycreator,transactionpointcut,org.springframework.aop.support.defaultbeanfactorypointcutadvisor0,jdbctemplate,userdaoimpl; root of factory hierarchy 2011-11-26 1:22:39 org.spr

9、ingframework.beans.factory.xml.xmlbeandefinitionreader loadbeandefinitions 信息: loading xml bean definitions from class path resource org/springframework/jdbc/support/sql-error-codes.xml 2011-11-26 1:22:39 org.springframework.jdbc.support.sqlerrorcodesfactory init 信息: sqlerrorcodes load: db2, derby,

10、h2, hsql, infoix, ms-sql, mysql, oracle, postgresql, sybase exception in thread "main" org.springframework.jdbc.badsqlgrammarexception: statementcallback; bad sql grammar update user set name=a where id=0; nested exception is com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: unkno

11、wn umn 'a' in 'field list' at org.springframework.jdbc.support.sqlerrorcodesqlexceptiontranslator.dotranslate(sqlerrorcodesqlexceptiontranslator.java:233) at org.springframework.jdbc.support.abstractfallbacksqlexceptiontranslator.translate(abstractfallbacksqlexceptiontranslator.java:

12、72) at org.springframework.jdbc.core.jdbctemplate.execute(jdbctemplate.java:406) at org.springframework.jdbc.core.jdbctemplate.update(jdbctemplate.java:518) at .ssm.dao2.userdaoimpl.insertuser(userdaoimpl.java:67) at sun.reflect.nativemethodaccessorimpl.invoke0(native method) at sun.reflect.nativeme

13、thodaccessorimpl.invoke(nativemethodaccessorimpl.java:39) at sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) at java.lang.reflect.method.invoke(method.java:597) at org.springframework.aop.support.aoputi.invokejoinpointusingreflection(aoputils.java:309) at org.sp

14、ringframework.aop.framework.reflectivemethodinvocation.invokejoinpoint(reflectivemethodinvocation.java:183) at org.springframework.aop.framework.reflectivemethodiceed(reflectivemethodinvocation.java:150) at erceptor.transactioninterceptor.invoke(transa

15、ctioninterceptor.java:110) at org.springframework.aop.framework.reflectivemethodiceed(reflectivemethodinvocation.java:172) at erceptor.exposeinvocationinterceptor.invoke(exposeinvocationinterceptor.java:89) at org.springframework.aop.framework.reflectivemethod

16、iceed(reflectivemethodinvocation.java:172) at org.springframework.aop.framework.jdkdynamicaopproxy.invoke(jdkdynamicaopproxy.java:202) at $proxy0.insertuser(unknown source) at .ssm.bll.userbll.main(userbll.java:39) cau by: com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: unkno

17、wn column 'a' in 'field list' at sun.reflect.nativeconstructoraccessorimpl.newinstae0(native method) at sun.reflect.nativeconstructoraccessorimpl.newinstance(nativeconstructoraccessorimpl.java:39) at sun.reflect.delegatingconstructoraccessorimpl.newinstance(delegatingconstructoracces

18、sorimpl.java:27) at java.lang.reflect.constructor.newinstance(constructor.java:513) at com.mysql.jdbc.util.handlenewinstance(util.java:406) at com.mysql.jdbc.util.getinstance(util.java:381) at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:1030) at com.mysql.jdbc.sqlerror.createsqlexceptio

19、n(sqlerror.java:956) at com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3491) at com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3423) at com.mysql.jdbc.mysqlio.sendcommand(mysqlio.java:1936) at com.mysql.jdbc.mysqlio.sqlquerydirect(mysqlio.java:2060) at com.mysql.jdbc.connectionimpl.execs

20、ql(connectionimpl.java:2536) at com.mysql.jdbc.statementimpl.executeupdate(statementimpl.java:1564) at com.mysql.jdbc.statementimpl.executeupdate(statementimpl.java:1485) at sun.reflect.nativemethodaccessorimpl.invoke0(native method) at sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39) at sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingm