{"id":233,"date":"2020-08-09T20:47:10","date_gmt":"2020-08-09T12:47:10","guid":{"rendered":"http:\/\/moyisuiying.com\/?p=233"},"modified":"2020-12-10T14:24:25","modified_gmt":"2020-12-10T06:24:25","slug":"%e4%bd%bf%e7%94%a8spring%e7%9a%84%e4%ba%8b%e5%8a%a1%e7%ae%a1%e7%90%86%e5%99%a8%e9%85%8d%e7%bd%ae%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e4%ba%8b%e5%8a%a1","status":"publish","type":"post","link":"http:\/\/moyisuiying.com\/index.php\/javastudy\/233.html","title":{"rendered":"\u4f7f\u7528Spring\u7684\u4e8b\u52a1\u7ba1\u7406\u5668\u914d\u7f6e\u6570\u636e\u5e93\u7684\u4e8b\u52a1"},"content":{"rendered":"\n

\u4e4b\u524d\u7684\u6587\u7ae0\u5206\u522b\u4f7f\u7528\u52a8\u6001\u4ee3\u7406\u8be6\u89e3\u81ea\u5b9a\u4e49Spring\u4e2dMySQL\u6570\u636e\u5e93\u7684\u4e8b\u52a1<\/a>\u4ee5\u53ca\u4f7f\u7528aop\u914d\u7f6e\u5b9e\u73b0\u81ea\u5b9a\u4e49\u7684MySQL\u4e8b\u52a1\u7ba1\u7406<\/a>\uff0c\u8fd9\u4e24\u4e2a\u90fd\u662f\u4f7f\u7528\u4e86\u81ea\u5df1\u7f16\u5199\u7684\u4e8b\u52a1\u7ba1\u7406\u5668\uff0c\u53ef\u8c13\u662f\u201c\u81ea\u5df1\u52a8\u624b\u4e30\u8863\u8db3\u98df\u201d\u3002\u5b9e\u9645\u4e0a\uff0cSpring\u6846\u67b6\u672c\u8eab\u5c31\u7ed9\u6211\u4eec\u63d0\u4f9b\u4e86\u5f3a\u5927\u7684\u4e8b\u52a1\u7ba1\u7406\u5668\uff0c\u53ef\u4ee5\u4e0d\u7528\u6211\u4eec\u81ea\u5df1\u624b\u52a8\u5199\u4e8b\u52a1\u7ba1\u7406\u5668\u5c31\u53ef\u4ee5\u5b9e\u73b0\u5bf9\u6570\u636e\u5e93\u64cd\u4f5c\u7684\u4e8b\u52a1\u7ba1\u7406\u3002\u4e0b\u9762\u8fb9\u5f00\u59cb\u5b9e\u73b0\u5bf9\u4e8b\u52a1\u7ba1\u7406\u7684\u914d\u7f6e\uff1a<\/p>\n\n\n\n

\u9996\u5148\u5efa\u7acb\u6570\u636e\u5e93\u4ee5\u53ca\u7528\u6237\u8868\uff1a<\/p>\n\n\n\n

create database if not exists springdemo;\nuse springdemo;\ncreate table if not exists Account(id int(4) auto_increment primary key,name varchar(16) not null,password varchar(16) not null,age int(3) ,createtime datetime default now(),money int(8));<\/code><\/pre>\n\n\n\n
1.\u6d4b\u8bd5\u9879\u76ee\u7684\u6574\u4f53\u76ee\u5f55<\/strong>
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
2.pom.xml\u7684\u4f9d\u8d56\u914d\u7f6e<\/p >\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\"\n         xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n         xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\n    <modelVersion>4.0.0<\/modelVersion>\n\n    <groupId>org.example<\/groupId>\n    <artifactId>springdemo11<\/artifactId>\n    <version>1.0-SNAPSHOT<\/version>\n <dependencies>\n<!--     \u5f15\u5165MySQL\u6570\u636e\u5e93\u4f9d\u8d56-->\n     <dependency>\n         <groupId>mysql<\/groupId>\n         <artifactId>mysql-connector-java<\/artifactId>\n         <version>8.0.21<\/version>\n     <\/dependency>\n     <!-- \u5f15\u5165Spring\u6838\u5fc3\u5305 -->\n     <dependency>\n         <groupId>org.springframework<\/groupId>\n         <artifactId>spring-context<\/artifactId>\n         <version>5.2.8.RELEASE<\/version>\n     <\/dependency>\n     <!-- \u5f15\u5165c3p0\u6570\u636e\u6e90\u4f9d\u8d56 -->\n     <dependency>\n         <groupId>com.mchange<\/groupId>\n         <artifactId>c3p0<\/artifactId>\n         <version>0.9.5.5<\/version>\n     <\/dependency>\n<!--     \u5f15\u5165\u6d4b\u8bd5\u4f9d\u8d56-->\n     <dependency>\n         <groupId>org.junit.jupiter<\/groupId>\n         <artifactId>junit-jupiter<\/artifactId>\n         <version>RELEASE<\/version>\n         <scope>test<\/scope>\n     <\/dependency>\n<!--     \u5f15\u5165\u5207aop\u4f9d\u8d56-->\n     <dependency>\n         <groupId>org.aspectj<\/groupId>\n         <artifactId>aspectjweaver<\/artifactId>\n         <version>1.9.6<\/version>\n     <\/dependency>\n     <!-- \u5f15\u5165spring-jdbc\u4f9d\u8d56 -->\n     <dependency>\n         <groupId>org.springframework<\/groupId>\n         <artifactId>spring-jdbc<\/artifactId>\n         <version>5.2.8.RELEASE<\/version>\n     <\/dependency>\n <\/dependencies>\n\n\n<\/project><\/code><\/pre>\n\n\n\n
3.\u6d4b\u8bd5\u9879\u76ee\u7684\u4ee3\u7801<\/p>\n\n\n\n
package dao;\n\nimport entity.Account;\n\nimport java.util.List;\n\n\/**\n * Classname:springdemo3\n *\n * @description:{description}\n * @author: \u964c\u610f\u968f\u5f71\n * @Date: 2020-08-01 17:32\n *\/\npublic interface AccountDao {\n    \/**\n     * @Description :\u4fdd\u5b58\u7528\u6237\n     * @Date 11:51 2020\/8\/9 0009\n     * @Param * @param account \uff1a\n     * @return boolean\n     **\/\n    public boolean saveAccount(Account account);\n    \/**\n     * @Description :\u66f4\u65b0\u7528\u6237\n     * @Date 11:51 2020\/8\/9 0009\n     * @Param * @param newAccount \uff1a\n     * @return boolean\n     **\/\n    public boolean updateAccount(Account newAccount);\n    \/**\n     * @Description :\u901a\u8fc7ID\u5220\u9664\u7528\u6237\n     * @Date 11:52 2020\/8\/9 0009\n     * @Param * @param id \uff1a\n     * @return boolean\n     **\/\n    public boolean deleteAccountById(int id);\n    \/**\n     * @Description :\u901a\u8fc7ID\u67e5\u8be2\u7528\u6237\n     * @Date 11:52 2020\/8\/9 0009\n     * @Param * @param id \uff1a\n     * @return entity.Account\n     **\/\n    public Account findAccountById(int id);\n    \/**\n     * @Description :\u67e5\u627e\u6240\u6709\u7528\u6237\n     * @Date 11:52 2020\/8\/9 0009\n     * @Param * @param  \uff1a\n     * @return java.util.List<entity.Account>\n     **\/\n    public List<Account> findAll();\n}<\/code><\/pre>\n\n\n\n
package dao;\n\nimport entity.Account;\nimport org.springframework.jdbc.core.BeanPropertyRowMapper;\nimport org.springframework.jdbc.core.JdbcTemplate;\nimport java.util.List;\n\n\/**\n * Classname:AccountDaoImpl\n *\n * @description:AccountDao\u7684\u5b9e\u73b0\u7c7b\n * @author: \u964c\u610f\u968f\u5f71\n * @Date: 2020-08-01 17:32\n * @Version: 1.0\n **\/\npublic class AccountDaoImpl implements AccountDao {\n    \/\/\u7528\u4e8e\u8fdb\u884cMySQL\u589e\u5220\u67e5\u6539\n    JdbcTemplate jdbcTemplate = null;\n    \/**\n     * @Description :\u65b9\u4fbf\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u6ce8\u5165JdbcTemplate\u5bf9\u8c61\n     * @Date 12:16 2020\/8\/9 0009\n     * @Param * @param queryRunner \uff1a\n     * @return void\n     **\/\n    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {\n        this.jdbcTemplate = jdbcTemplate;\n    }\n   \/**\n    * @Description :\u4fdd\u5b58\u7528\u6237\n    * @Date 12:17 2020\/8\/9 0009\n    * @Param * @param newAccount \uff1a\n    * @return boolean\n    **\/\n    public boolean saveAccount(Account newAccount) {\n            return jdbcTemplate.update(\"insert into account(name,password,age,createTIme,money) values(?,?,?,?,?)\",\n                    newAccount.getName(),newAccount.getPassword(),\n                    newAccount.getAge(),newAccount.getCreateTime(),newAccount.getMoney())== 1;\n    }\n  \/**\n   * @Description :\u66f4\u65b0\u7528\u6237\n   * @Date 12:18 2020\/8\/9 0009\n   * @Param * @param newAccount \uff1a\n   * @return boolean\n   **\/\n    public boolean updateAccount(Account newAccount) {\n            return jdbcTemplate.update(\"update account set name=?,password=?,age=?,createTime=?,money=? where id=?\",\n                    newAccount.getName(),newAccount.getPassword(),\n                    newAccount.getAge(),newAccount.getCreateTime(),newAccount.getMoney(),newAccount.getId())==1;\n    }\n  \/**\n   * @Description :\u901a\u8fc7ID\u5220\u9664\u7528\u6237\n   * @Date 12:18 2020\/8\/9 0009\n   * @Param * @param id \uff1a\n   * @return boolean\n   **\/\n    public boolean deleteAccountById(int id) {\n            return jdbcTemplate.update(\"delete from account where id=?\",id) == 1;\n    }\n\/**\n * @Description :\u901a\u8fc7ID\u67e5\u8be2\u7528\u6237\n * @Date 11:02 2020\/8\/9 0009\n * @Param * @param id \uff1a\n * @return entity.Account\n **\/\n    public Account findAccountById(int id) {\n            List<Account> list = jdbcTemplate.query(\"select* from account where id=?\", new BeanPropertyRowMapper<Account>(Account.class), id);\n            if (list.isEmpty()){\n                return  null;\n            }\n            if (list.size()==1){\n                return list.get(0);\n            }\n            return  null;\n\n    }\n\/**\n * @Description :\u67e5\u8be2\u6240\u6709\u54df\u7528\u6237\n * @Date 11:01 2020\/8\/9 0009\n * @Param * @param  \uff1a\n * @return java.util.List<entity.Account>\n **\/\n    public List<Account> findAll() {\n            return jdbcTemplate.query(\"select* from account\",new BeanPropertyRowMapper<Account>(Account.class));\n    }\n\n}<\/code><\/pre>\n\n\n\n
package entity;\n\nimport org.springframework.context.annotation.Scope;\nimport org.springframework.stereotype.Repository;\n\nimport java.util.Date;\n\n\/**\n * Classname:Account\n *\n * @description:\n * @author: \u964c\u610f\u968f\u5f71\n * @Date: 2020-08-01 17:33\n * @Version: 1.0\n **\/\npublic class Account {\n    \/\/\u7528\u6237\u4e3b\u952eID\n    private int id;\n    \/\/\u7528\u6237\u540d\n    private String name;\n    \/\/\u7528\u6237\u5bc6\u7801\n    private String password;\n    \/\/\u7528\u6237\u5e74\u9f84\n    private int age;\n    \/\/\u7528\u6237\u521b\u5efa\u65f6\u95f4\n    private Date createTime ;\n    \/\/\u7528\u6237\u7684\u4f59\u989d\n    private int money;\n\n    public int getMoney() {\n        return money;\n    }\n\n    public void setMoney(int money) {\n        this.money = money;\n    }\n\n    public int getId() {\n        return id;\n    }\n\n    public void setId(int id) {\n        this.id = id;\n    }\n\n    public String getName() {\n        return name;\n    }\n\n    public void setName(String name) {\n        this.name = name;\n    }\n\n    public String getPassword() {\n        return password;\n    }\n\n    public void setPassword(String password) {\n        this.password = password;\n    }\n\n    public int getAge() {\n        return age;\n    }\n\n    public void setAge(int age) {\n        this.age = age;\n    }\n\n    public Date getCreateTime() {\n        return createTime;\n    }\n\n    public void setCreateTime(Date createTime) {\n        this.createTime = createTime;\n    }\n\n    @Override\n    public String toString() {\n        return \"Account{\" +\n                \"id=\" + id +\n                \", name='\" + name + '\\'' +\n                \", password='\" + password + '\\'' +\n                \", age=\" + age +\n                \", createTime=\" + createTime +\n                \", monney=\" + money +\n                '}';\n    }\n}<\/code><\/pre>\n\n\n\n
package service;\n\nimport entity.Account;\n\nimport java.util.List;\n\n\/**\n * Classname:springdemo3\n *\n * @description:{description}\n * @author: \u964c\u610f\u968f\u5f71\n * @Date: 2020-08-01 17:35\n *\/\npublic interface AccountService {\n        \/**\n         * @Description :\u4fdd\u5b58\u7528\u6237\n         * @Date 11:51 2020\/8\/9 0009\n         * @Param * @param account \uff1a\n         * @return boolean\n         **\/\n        public boolean saveAccount(Account account);\n        \/**\n         * @Description :\u66f4\u65b0\u7528\u6237\n         * @Date 11:51 2020\/8\/9 0009\n         * @Param * @param newAccount \uff1a\n         * @return boolean\n         **\/\n        public boolean updateAccount(Account newAccount);\n        \/**\n         * @Description :\u901a\u8fc7ID\u5220\u9664\u7528\u6237\n         * @Date 11:52 2020\/8\/9 0009\n         * @Param * @param id \uff1a\n         * @return boolean\n         **\/\n        public boolean deleteAccountById(int id);\n        \/**\n         * @Description :\u901a\u8fc7ID\u67e5\u8be2\u7528\u6237\n         * @Date 11:52 2020\/8\/9 0009\n         * @Param * @param id \uff1a\n         * @return entity.Account\n         **\/\n        public Account findAccountById(int id);\n        \/**\n         * @Description :\u67e5\u627e\u6240\u6709\u7528\u6237\n         * @Date 11:52 2020\/8\/9 0009\n         * @Param * @param  \uff1a\n         * @return java.util.List<entity.Account>\n         **\/\n        public List<Account> findAll();\n   \/**\n    * @Description :\u4ece\u7528\u6237ID\u4e3asourceId\u7684\u7528\u6237\u5411\u7528\u6237ID\u4e3atargetId\u7684\u7528\u6237\u8f6c\u8d26money\n    * @Date 11:55 2020\/8\/9 0009\n    * @Param * @param sourceId\n    * @param targetId\n    * @param money \uff1a\n    * @return boolean\n    **\/\n    public boolean tranferMoney(int sourceId,int targetId,int money);\n}<\/code><\/pre>\n\n\n\n
package service;\nimport dao.AccountDao;\nimport entity.Account;\nimport java.util.List;\n\/**\n * Classname:AccountServiceImpl\n * @description:\n * @author: \u964c\u610f\u968f\u5f71\n * @Date: 2020-08-01 17:35\n * @Version: 1.0\n **\/\npublic class AccountServiceImpl implements AccountService {\n    \/\/\u7528\u6237\u6570\u636e\u53ef\u8bbf\u95ee\u7684Dao\u63a5\u53e3\n    private AccountDao accountDao;\n    \/**\n     * @Description :\u65b9\u4fbf\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u6ce8\u5165AccountDao\u7684\u5b9e\u73b0\u4e86AccountDaoImpl\n     * @Date 12:21 2020\/8\/9 0009\n     * @Param * @param accountDao \uff1a\n     * @return void\n     **\/\n    public void setAccountDao(AccountDao accountDao) {\n        this.accountDao = accountDao;\n    }\n    public boolean saveAccount(Account account) {\n        return accountDao.saveAccount(account);\n    }\n\n    public boolean updateAccount(Account newAccount) {\n        return accountDao.updateAccount(newAccount);\n    }\n\n    public boolean deleteAccountById(int id) {\n        return accountDao.deleteAccountById(id);\n    }\n\n    public Account findAccountById(int id) {\n        return accountDao.findAccountById(id);\n    }\n\n    public List<Account> findAll() {\n        return accountDao.findAll();\n    }\n    \/**\n     * @Description :\u4ece\u7528\u6237ID\u4e3asourceId\u7684\u7528\u6237\u5411\u7528\u6237ID\u4e3atargetId\u7684\u7528\u6237\u8f6c\u8d26money\n     * @Date 11:55 2020\/8\/9 0009\n     * @Param * @param sourceId\n     * @param targetId\n     * @param money \uff1a\n     * @return boolean\n     **\/\n    public boolean tranferMoney(int sourceId, int targetId, int money) {\n           \/\/\u83b7\u53d6sourceId\u5bf9\u5e94\u7684\u7528\u6237\n            Account sourceAccount = this.findAccountById(sourceId);\n        \/\/\u83b7\u53d6targetId\u5bf9\u5e94\u7684\u7528\u6237\n            Account targetAccount = this.findAccountById(targetId);\n            \/\/\u8f6c\u8d26\u5931\u8d25\n            if (sourceAccount == null || targetAccount == null) {\n                return  false;\n            }\n            \/\/\u8f6c\u8d26\u8005\u6263\u53bb\u8f6c\u8d26\u7684\u91d1\u989d\n            sourceAccount.setMoney(sourceAccount.getMoney() -money);\n            \/\/\u76ee\u6807\u5bf9\u8c61\u52a0\u4e0a\u83b7\u53d6\u7684\u8f6c\u8d26\u91d1\u989d\n            targetAccount.setMoney(targetAccount.getMoney()+money);\n            \/\/\u66f4\u65b0\u8f6c\u8d26\u8005\u7684\u8d26\u6237\n        boolean b = this.updateAccount(sourceAccount);\n        \/\/\u6a21\u62df\u5f02\u5e38\n\/\/        int i = 1\/0;\n        \/\/\u66f4\u65b0\u8f6c\u8d26\u76ee\u6807\u8005\u7684\u8d26\u6237\n        boolean b1 = this.updateAccount(targetAccount);\n            return  b == true && b1 == true;\n\n    }\n}<\/code><\/pre>\n\n\n\n
4.\u6d4b\u8bd5\u4ee3\u7801<\/strong><\/p>\n\n\n\n
package test;\n\nimport entity.Account;\nimport org.junit.jupiter.api.AfterEach;\nimport org.junit.jupiter.api.BeforeEach;\nimport org.junit.jupiter.api.Test;\nimport org.springframework.context.ApplicationContext;\nimport org.springframework.context.support.ClassPathXmlApplicationContext;\nimport service.AccountService;\n\nimport java.util.Date;\nimport java.util.List;\n\n\/**\n * Classname:AccountTest\n *\n * @description:\n * @author: \u964c\u610f\u968f\u5f71\n * @Date: 2020-08-01 17:39\n * @Version: 1.0\n **\/\npublic class AccountTest {\n    private ApplicationContext applicationContext;\n    private  AccountService accountService;\n    @BeforeEach\n    public void init(){\n\n        applicationContext = new ClassPathXmlApplicationContext(\"bean.xml\");\n        System.out.println(\"\u542f\u52a8\");\n    }\n    @AfterEach\n    public void destroy(){\n\n    }\n    @Test\n    public  void testSave(){\n        Account account = applicationContext.getBean(\"account\", Account.class);\n        account.setAge(434);\n        account.setName(\"\u674e\u56db\");\n        account.setPassword(\"\u6253\u4e2a\u5361\u7684\u6492\u8001\u987e\u5ba2\");\n        account.setCreateTime(new Date());\n        account.setMoney(1000);\n        AccountService accountService = applicationContext.getBean(\"accountService\", AccountService.class);\n        boolean fla = accountService.saveAccount(account);\n        System.out.println(\"\u63d2\u5165\u7528\u6237\uff1a\"+fla);\n    }\n    @Test\n    public  void testUpdate(){\n        Account account = applicationContext.getBean(\"account\", Account.class);\n        account.setAge(77);\n        account.setName(\"\u7ad9\u5e72\u5565\");\n        account.setPassword(\"54545\");\n        account.setCreateTime(new Date());\n        account.setId(3);\n        AccountService accountService = applicationContext.getBean(\"accountService\", AccountService.class);\n        boolean fla = accountService.updateAccount(account);\n        System.out.println(\"\u66f4\u65b0\u7528\u6237\uff1a\"+fla);\n    }\n    @Test\n    public  void testDelete(){\n        Account account = applicationContext.getBean(\"account\", Account.class);\n        account.setId(5);\n        AccountService accountService = applicationContext.getBean(\"accountService\", AccountService.class);\n        boolean fla = accountService.deleteAccountById(account.getId());\n        System.out.println(\"\u5220\u9664\u7528\u6237\uff1a\"+fla);\n    }\n    @Test\n    public  void  testFindOne(){\n        AccountService accountService = applicationContext.getBean(\"accountService\", AccountService.class);\n        Account account1 = accountService.findAccountById(6);\n        System.out.println(\"\u67e5\u627e\u5355\u4e2a\u7528\u6237\"+account1);\n    }\n    @Test\n    public void  testFindAll(){\n        AccountService accountService = applicationContext.getBean(\"accountService\", AccountService.class);\n        List<Account> accountList = accountService.findAll();\n        for (Account a :accountList) {\n            System.out.println(a);\n\n        }\n    }\n    @Test\n    public void testTran(){\n        \/\/\u83b7\u53d6\u6ca1\u6709\u7ecf\u8fc7\u4e8b\u52a1\u7ba1\u7406\u7684\u666e\u901aAccountServiceImpl\n        AccountService accountService = applicationContext.getBean(\"accountService\", AccountService.class);\n        accountService.tranferMoney(3,6,100);\n    }\n}<\/code><\/pre>\n\n\n\n
5.bean.xml\u7684\u914d\u7f6e<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<beans xmlns=\"http:\/\/www.springframework.org\/schema\/beans\"\n       xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n       xmlns:aop=\"http:\/\/www.springframework.org\/schema\/aop\"\n       xmlns:tx=\"http:\/\/www.springframework.org\/schema\/tx\"\n       xsi:schemaLocation=\"\n        http://www.springframework.org\/schema\/beans\n        http:\/\/www.springframework.org\/schema\/beans\/spring-beans.xsd\n        http:\/\/www.springframework.org\/schema\/tx\n        http:\/\/www.springframework.org\/schema\/tx\/spring-tx.xsd\n        http:\/\/www.springframework.org\/schema\/aop\n        http:\/\/www.springframework.org\/schema\/aop\/spring-aop.xsd\">\n    <!-- \u914d\u7f6e\u5b9e\u4f53\u7c7b -->\n    <bean id=\"account\" class=\"entity.Account\" scope=\"prototype\"><\/bean>\n<!--    \u914d\u7f6eAccountDaoImpl-->\n        <bean id=\"accountDao\" class=\"dao.AccountDaoImpl\">\n<!--            \u6ce8\u5165jdbcTemplate-->\n             <property name=\"jdbcTemplate\" ref=\"jdbcTemplate\"><\/property>\n        <\/bean>\n<!--    \u914d\u7f6ejdbcTemplate-->\n    <bean id=\"jdbcTemplate\" class=\"org.springframework.jdbc.core.JdbcTemplate\">\n<!--        \u6ce8\u5165\u6570\u636e\u6e90-->\n        <property name=\"dataSource\" ref=\"dataSource\"><\/property>\n    <\/bean>\n<!--    \u914d\u7f6ec3p0\u6570\u636e\u6e90-->\n    <bean id=\"dataSource\" class=\"com.mchange.v2.c3p0.ComboPooledDataSource\">\n<!--        \u7528\u6237\u540d-->\n        <property name=\"user\" value=\"root\"><\/property>\n<!--        \u6570\u636e\u5e93\u9a71\u52a8-->\n        <property name=\"driverClass\" value=\"com.mysql.cj.jdbc.Driver\"><\/property>\n<!--        \u5bc6\u7801-->\n        <property name=\"password\" value=\"root\"><\/property>\n<!--        URL-->\n        <property name=\"jdbcUrl\" value=\"jdbc:mysql:\/\/localhost:3306\/springdemo?serverTimezone=UTC\"><\/property>\n    <\/bean>\n<!--    \u914d\u7f6eAccountServiceImpl-->\n    <bean id=\"accountService\" class=\"service.AccountServiceImpl\">\n<!--        \u6ce8\u5165accountDao-->\n        <property name=\"accountDao\" ref=\"accountDao\"><\/property>\n    <\/bean>\n\n\n\n<!--    \u914d\u7f6e\u4e8b\u52a1\u7ba1\u7406\u5668-->\n   <bean id=\"transactionManager\" class=\"org.springframework.jdbc.datasource.DataSourceTransactionManager\">\n<!--    \u914d\u7f6e\u4e8b\u52a1\u901a\u77e5 -->\n    <tx:advice id=\"transactionInterceptor\" transaction-manager=\"transactionManager\">\n<!--     \u914d\u7f6e\u4e8b\u52a1\u7684\u5c5e\u6027   -->\n    <tx:attributes>\n<!--        \u914d\u7f6e\u65b9\u6cd5\u7684\u5c5e\u6027\uff0c\u5176\u4e2d\u201c*\u201d\u8868\u793a\u4efb\u610f\uff0c\u6bd4\u5982\u8bf4save*\u8868\u793a\u4ee5save\u5f00\u5934\u7684\u6240\u6709\u65b9\u6cd5\uff0c\u6bd4\u5982saveAccount,saveUser\u7b49\u3002\u3002-->\n        <tx:method name=\"tranferMoney\" isolation=\"DEFAULT\" read-only=\"false\"\/>\n        <tx:method name=\"save*\" isolation=\"DEFAULT\" read-only=\"false\"><\/tx:method>\n        <tx:method name=\"update*\" isolation=\"DEFAULT\" read-only=\"false\"><\/tx:method>\n        <tx:method name=\"delete*\"  isolation=\"DEFAULT\" read-only=\"false\"><\/tx:method>\n        <tx:method name=\"find*\" isolation=\"DEFAULT\"  read-only=\"true\" \/>\n\n    <\/tx:attributes>\n    <\/tx:advice>\n\n<!--       \u6ce8\u5165\u6570\u636e\u6e90-->\n       <property name=\"dataSource\" ref=\"dataSource\"> <\/property>\n   <\/bean>\n<!--    \u914d\u7f6eaop-->\n    <aop:config>\n<!--        \u914d\u7f6e\u5207\u5165\u70b9\u8868\u8fbe\u5f0f-->\n        <aop:pointcut id=\"pt\" expression=\"execution(*  *service.AccountServiceImpl.*(..))\"\/>\n<!--        \u5efa\u7acb\u5207\u5165\u70b9\u8868\u8fbe\u5f0f\u548c\u4e8b\u52a1\u901a\u77e5\u7684\u5bf9\u5e94\u5173\u7cfb-->\n        <aop:advisor advice-ref=\"transactionInterceptor\"  pointcut-ref=\"pt\"><\/aop:advisor>\n    <\/aop:config>\n<\/beans><\/code><\/pre>\n\n\n\n
tx:method \u7684\u5c5e\u6027\u8be6\u89e3\uff1a
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
readOnly\uff1a
\u4e8b\u52a1\u5c5e\u6027\u4e2d\u7684readOnly\u6807\u5fd7\u8868\u793a\u5bf9\u5e94\u7684\u4e8b\u52a1\u5e94\u8be5\u88ab\u6700\u4f18\u5316\u4e3a\u53ea\u8bfb\u4e8b\u52a1\u3002\u5982\u679c\u503c\u4e3atrue\u5c31\u4f1a\u544a\u8bc9Spring\u6211\u8fd9\u4e2a\u65b9\u6cd5\u91cc\u9762\u6ca1\u6709insert\u6216\u8005update\uff0c\u4f60\u53ea\u9700\u8981\u63d0\u4f9b\u53ea\u8bfb\u7684\u6570\u636e\u5e93Connection\u5c31\u884c\u4e86\uff0c\u8fd9\u79cd\u6267\u884c\u6548\u7387\u4f1a\u6bd4read-write\u7684Connection\u9ad8\uff0c\u6240\u4ee5\u8fd9\u662f\u4e00\u4e2a\u6700\u4f18\u5316\u63d0\u793a\u3002\u5728\u4e00\u4e9b\u60c5\u51b5\u4e0b\uff0c\u4e00\u4e9b\u4e8b\u52a1\u7b56\u7565\u80fd\u591f\u8d77\u5230\u663e\u8457\u7684\u6700\u4f18\u5316\u6548\u679c\uff0c\u4f8b\u5982\u5728\u4f7f\u7528Object\/Relational\u6620\u5c04\u5de5\u5177\uff08\u5982\uff1aHibernate\u6216TopLink\uff09\u65f6\u907f\u514ddirty checking\uff08\u8bd5\u56fe\u201c\u5237\u65b0\u201d\uff09\u3002<\/p >\n
timeout\uff1a
\u5728\u5c5e\u6027\u4e2d\u8fd8\u6709\u5b9a\u4e49\u201ctimeout\u201d\u503c\u7684\u9009\u9879\uff0c\u6307\u5b9a\u4e8b\u52a1\u8d85\u65f6\u4e3a\u51e0\u79d2\u3002\u4e00\u822c\u4e0d\u4f1a\u4f7f\u7528\u8fd9\u4e2a\u5c5e\u6027\u3002\u5728JTA\u4e2d\uff0c\u8fd9\u5c06\u88ab\u7b80\u5355\u5730\u4f20\u9012\u5230J2EE\u670d\u52a1\u5668\u7684\u4e8b\u52a1\u534f\u8c03\u7a0b\u5e8f\uff0c\u5e76\u636e\u6b64\u5f97\u5230\u76f8\u5e94\u7684\u89e3\u91ca\u3002<\/p>\n\n\n\n
Isolation Level(\u4e8b\u52a1\u9694\u79bb\u7b49\u7ea7)\u76845\u4e2a\u679a\u4e3e\u503c
\u4e3a\u4ec0\u4e48\u4e8b\u52a1\u8981\u6709Isolation Level\u8fd9\u4e2a\u5c5e\u6027\uff1f\u5148\u56de\u987e\u4e0b\u6570\u636e\u5e93\u4e8b\u52a1\u7684\u77e5\u8bc6\uff1a
\u7b2c\u4e00\u7c7b\u4e22\u5931\u66f4\u65b0(lost update)\uff1a\u5728\u5b8c\u5168\u672a\u9694\u79bb\u4e8b\u52a1\u7684\u60c5\u51b5\u4e0b\uff0c\u4e24\u4e2a\u4e8b\u7269\u66f4\u65b0\u540c\u4e00\u6761\u6570\u636e\u8d44\u6e90\uff0c\u67d0\u4e00\u4e8b\u7269\u5f02\u5e38\u7ec8\u6b62\uff0c\u56de\u6eda\u9020\u6210\u7b2c\u4e00\u4e2a\u5b8c\u6210\u7684\u66f4\u65b0\u4e5f\u540c\u65f6\u4e22\u5931\u3002
\u7b2c\u4e8c\u7c7b\u4e22\u5931\u66f4\u65b0(second lost updates)\uff1a\u662f\u4e0d\u53ef\u91cd\u590d\u8bfb\u7684\u7279\u6b8a\u60c5\u51b5\uff0c\u5982\u679c\u4e24\u4e2a\u4e8b\u52a1\u90fd\u8bfb\u53d6\u540c\u4e00\u884c\uff0c\u7136\u540e\u4e24\u4e2a\u90fd\u8fdb\u884c\u5199\u64cd\u4f5c\uff0c\u5e76\u63d0\u4ea4\uff0c\u7b2c\u4e00\u4e2a\u4e8b\u52a1\u6240\u505a\u7684\u6539\u53d8\u5c31\u4f1a\u4e22\u5931\u3002
\u810f\u8bfb(dirty read)\uff1a\u5982\u679c\u7b2c\u4e8c\u4e2a\u4e8b\u52a1\u67e5\u8be2\u5230\u7b2c\u4e00\u4e2a\u4e8b\u52a1\u8fd8\u672a\u63d0\u4ea4\u7684\u66f4\u65b0\u6570\u636e\uff0c\u5f62\u6210\u810f\u8bfb\u3002\u56e0\u4e3a\u7b2c\u4e00\u4e2a\u4e8b\u52a1\u4f60\u8fd8\u4e0d\u77e5\u9053\u662f\u5426\u63d0\u4ea4\uff0c\u6240\u4ee5\u6570\u636e\u4e0d\u4e00\u5b9a\u662f\u6b63\u786e\u7684\u3002
\u865a\u8bfb(phantom read)\uff1a\u4e00\u4e2a\u4e8b\u52a1\u6267\u884c\u4e24\u6b21\u67e5\u8be2\uff0c\u7b2c\u4e8c\u6b21\u7ed3\u679c\u96c6\u5305\u542b\u7b2c\u4e00\u6b21\u4e2d\u6ca1\u6709\u6216\u8005\u67d0\u4e9b\u884c\u5df2\u88ab\u5220\u9664\uff0c\u9020\u6210\u4e24\u6b21\u7ed3\u679c\u4e0d\u4e00\u81f4\uff0c\u53ea\u662f\u53e6\u4e00\u4e2a\u4e8b\u52a1\u5728\u8fd9\u4e24\u6b21\u67e5\u8be2\u4e2d\u95f4\u63d2\u5165\u6216\u8005\u5220\u9664\u4e86\u6570\u636e\u9020\u6210\u7684\u3002
\u4e0d\u53ef\u91cd\u590d\u8bfb(unrepeated read)\uff1a\u4e00\u4e2a\u4e8b\u52a1\u4e24\u6b21\u8bfb\u53d6\u540c\u4e00\u884c\u6570\u636e\uff0c\u7ed3\u679c\u5f97\u5230\u4e0d\u540c\u72b6\u6001\u7ed3\u679c\uff0c\u5982\u4e2d\u95f4\u6b63\u597d\u53e6\u4e00\u4e2a\u4e8b\u52a1\u66f4\u65b0\u4e86\u8be5\u6570\u636e\uff0c\u4e24\u6b21\u7ed3\u679c\u76f8\u5f02\uff0c\u4e0d\u53ef\u4fe1\u4efb\u3002<\/p>\n\n\n\n
\u5f53\u9047\u5230\u4ee5\u4e0a\u8fd9\u4e9b\u60c5\u51b5\u65f6\u6211\u4eec\u53ef\u4ee5\u8bbe\u7f6eisolation\u4e0b\u9762\u8fd9\u4e9b\u679a\u4e3e\u503c\uff1a
DEFAULT\uff1a\u91c7\u7528\u6570\u636e\u5e93\u9ed8\u8ba4\u9694\u79bb\u7ea7\u522b
SERIALIZABLE\uff1a\u6700\u4e25\u683c\u7684\u7ea7\u522b\uff0c\u4e8b\u52a1\u4e32\u884c\u6267\u884c\uff0c\u8d44\u6e90\u6d88\u8017\u6700\u5927\uff1b
REPEATABLE_READ\uff1a\u4fdd\u8bc1\u4e86\u4e00\u4e2a\u4e8b\u52a1\u4e0d\u4f1a\u4fee\u6539\u5df2\u7ecf\u7531\u53e6\u4e00\u4e2a\u4e8b\u52a1\u8bfb\u53d6\u4f46\u672a\u63d0\u4ea4\uff08\u56de\u6eda\uff09\u7684\u6570\u636e\u3002\u907f\u514d\u4e86\u201c\u810f\u8bfb\u53d6\u201d\u548c\u201c\u4e0d\u53ef\u91cd\u590d\u8bfb\u53d6\u201d\u7684\u60c5\u51b5\uff0c\u4f46\u662f\u5e26\u6765\u4e86\u66f4\u591a\u7684\u6027\u80fd\u635f\u5931\u3002
READ_COMMITTED:\u5927\u591a\u6570\u4e3b\u6d41\u6570\u636e\u5e93\u7684\u9ed8\u8ba4\u4e8b\u52a1\u7b49\u7ea7\uff0c\u4fdd\u8bc1\u4e86\u4e00\u4e2a\u4e8b\u52a1\u4e0d\u4f1a\u8bfb\u5230\u53e6\u4e00\u4e2a\u5e76\u884c\u4e8b\u52a1\u5df2\u4fee\u6539\u4f46\u672a\u63d0\u4ea4\u7684\u6570\u636e\uff0c\u907f\u514d\u4e86\u201c\u810f\u8bfb\u53d6\u201d\u3002\u8be5\u7ea7\u522b\u9002\u7528\u4e8e\u5927\u591a\u6570\u7cfb\u7edf\u3002
READ_UNCOMMITTED\uff1a\u4fdd\u8bc1\u4e86\u8bfb\u53d6\u8fc7\u7a0b\u4e2d\u4e0d\u4f1a\u8bfb\u53d6\u5230\u975e\u6cd5\u6570\u636e\u3002\u9694\u79bb\u7ea7\u522b\u5728\u4e8e\u5904\u7406\u591a\u4e8b\u52a1\u7684\u5e76\u53d1\u95ee\u9898\u3002<\/p>\n\n\n\n
\u5173\u4e8epropagation\u5c5e\u6027\u76847\u4e2a\u4f20\u64ad\u884c\u4e3a
REQUIRED\uff1a\u6307\u5b9a\u5f53\u524d\u65b9\u6cd5\u5fc5\u9700\u5728\u4e8b\u52a1\u73af\u5883\u4e2d\u8fd0\u884c\uff0c\u5982\u679c\u5f53\u524d\u6709\u4e8b\u52a1\u73af\u5883\u5c31\u52a0\u5165\u5f53\u524d\u6b63\u5728\u6267\u884c\u7684\u4e8b\u52a1\u73af\u5883\uff0c\u5982\u679c\u5f53\u524d\u6ca1\u6709\u4e8b\u52a1\uff0c\u5c31\u65b0\u5efa\u4e00\u4e2a\u4e8b\u52a1\u3002\u8fd9\u662f\u9ed8\u8ba4\u503c\u3002
SUPPORTS\uff1a\u6307\u5b9a\u5f53\u524d\u65b9\u6cd5\u52a0\u5165\u5f53\u524d\u4e8b\u52a1\u73af\u5883\uff0c\u5982\u679c\u5f53\u524d\u6ca1\u6709\u4e8b\u52a1\uff0c\u5c31\u4ee5\u975e\u4e8b\u52a1\u65b9\u5f0f\u6267\u884c\u3002
MANDATORY\uff1a\u6307\u5b9a\u5f53\u524d\u65b9\u6cd5\u5fc5\u987b\u52a0\u5165\u5f53\u524d\u4e8b\u52a1\u73af\u5883\uff0c\u5982\u679c\u5f53\u524d\u6ca1\u6709\u4e8b\u52a1\uff0c\u5c31\u629b\u51fa\u5f02\u5e38\u3002
REQUIRES_NEW\uff1a\u6307\u5b9a\u5f53\u524d\u65b9\u6cd5\u603b\u662f\u4f1a\u4e3a\u81ea\u5df1\u53d1\u8d77\u4e00\u4e2a\u65b0\u7684\u4e8b\u52a1\uff0c\u5982\u679c\u53d1\u73b0\u5f53\u524d\u65b9\u6cd5\u5df2\u8fd0\u884c\u5728\u4e00\u4e2a\u4e8b\u52a1\u4e2d,\u5219\u539f\u6709\u4e8b\u52a1\u88ab\u6302\u8d77,\u6211\u81ea\u5df1\u521b\u5efa\u4e00\u4e2a\u5c5e\u4e8e\u81ea\u5df1\u7684\u4e8b\u52a1,\u76f4\u6211\u81ea\u5df1\u8fd9\u4e2a\u65b9\u6cd5commit\u7ed3\u675f,\u539f\u5148\u7684\u4e8b\u52a1\u624d\u4f1a\u6062\u590d\u6267\u884c\u3002
NOT_SUPPORTED\uff1a\u6307\u5b9a\u5f53\u524d\u65b9\u6cd5\u4ee5\u975e\u4e8b\u52a1\u65b9\u5f0f\u6267\u884c\u64cd\u4f5c\uff0c\u5982\u679c\u5f53\u524d\u5b58\u5728\u4e8b\u52a1\uff0c\u5c31\u628a\u5f53\u524d\u4e8b\u52a1\u6302\u8d77\uff0c\u7b49\u6211\u4ee5\u975e\u4e8b\u52a1\u7684\u72b6\u6001\u8fd0\u884c\u5b8c\uff0c\u518d\u7ee7\u7eed\u539f\u6765\u7684\u4e8b\u52a1\u3002
NEVER\uff1a\u6307\u5b9a\u5f53\u524d\u65b9\u6cd5\u7edd\u5bf9\u4e0d\u80fd\u5728\u4e8b\u52a1\u8303\u56f4\u5185\u6267\u884c\uff0c\u5982\u679c\u65b9\u6cd5\u5728\u67d0\u4e2a\u4e8b\u52a1\u8303\u56f4\u5185\u6267\u884c\uff0c\u5bb9\u5668\u5c31\u629b\u5f02\u5e38\uff0c\u53ea\u6709\u6ca1\u5173\u8054\u5230\u4e8b\u52a1\uff0c\u624d\u6b63\u5e38\u6267\u884c\u3002
NESTED\uff1a\u6307\u5b9a\u5f53\u524d\u65b9\u6cd5\u6267\u884c\u65f6\uff0c\u5982\u679c\u5df2\u7ecf\u6709\u4e00\u4e2a\u4e8b\u52a1\u5b58\u5728,\u5219\u8fd0\u884c\u5728\u8fd9\u4e2a\u5d4c\u5957\u7684\u4e8b\u52a1\u4e2d.\u5982\u679c\u5f53\u524d\u73af\u5883\u6ca1\u6709\u8fd0\u884c\u7684\u4e8b\u52a1\uff0c\u5c31\u65b0\u5efa\u4e00\u4e2a\u4e8b\u52a1\uff0c\u5e76\u4e0e\u7236\u4e8b\u52a1\u76f8\u4e92\u72ec\u7acb\uff0c\u8fd9\u4e2a\u4e8b\u52a1\u62e5\u6709\u591a\u4e2a\u53ef\u4ee5\u56de\u6eda\u7684\u4fdd\u8bc1\u70b9\u3002\u5c31\u662f\u6307\u6211\u81ea\u5df1\u5185\u90e8\u4e8b\u52a1\u56de\u6eda\u4e0d\u4f1a\u5bf9\u5916\u90e8\u4e8b\u52a1\u9020\u6210\u5f71\u54cd\uff0c\u53ea\u5bf9DataSourceTransactionManager\u4e8b\u52a1\u7ba1\u7406\u5668\u8d77\u6548\u3002<\/p>\n\n\n\n
\u6ce8\u610f\uff1a<\/strong> <\/p>\n\n\n\n
\"\"<\/figure >\n