{"id":224,"date":"2020-08-09T14:15:25","date_gmt":"2020-08-09T06:15:25","guid":{"rendered":"http:\/\/moyisuiying.com\/?p=224"},"modified":"2020-12-10T14:24:25","modified_gmt":"2020-12-10T06:24:25","slug":"%e8%af%a6%e8%a7%a3%e8%87%aa%e5%ae%9a%e4%b9%89spring%e4%b8%admysql%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\/224.html","title":{"rendered":"\u8be6\u89e3\u81ea\u5b9a\u4e49Spring\u4e2dMySQL\u6570\u636e\u5e93\u7684\u4e8b\u52a1"},"content":{"rendered":"\n

1.\u5728\u6211\u4eec\u8fdb\u884c\u6570\u636e\u5e93\u64cd\u4f5c\u65f6\uff0c\u4e3a\u4e86\u5b58\u53d6\u6570\u636e\u7684\u5b89\u5168\uff0c\u9700\u8981\u8fdb\u884c\u4e8b\u52a1\u652f\u6301\uff0c\u4e0b\u9762\u6211\u4eec\u5148\u770b\u4e00\u4e0bMySQL\u7684\u4e8b\u52a1\uff1a
1.1MySQL \u4e8b\u52a1\u4e3b\u8981\u7528\u4e8e\u5904\u7406\u64cd\u4f5c\u91cf\u5927\uff0c\u590d\u6742\u5ea6\u9ad8\u7684\u6570\u636e\u3002\u6bd4\u5982\u8bf4\uff0c\u5728\u4eba\u5458\u7ba1\u7406\u7cfb\u7edf\u4e2d\uff0c\u4f60\u5220\u9664\u4e00\u4e2a\u4eba\u5458\uff0c\u4f60\u65e2\u9700\u8981\u5220\u9664\u4eba\u5458\u7684\u57fa\u672c\u8d44\u6599\uff0c\u4e5f\u8981\u5220\u9664\u548c\u8be5\u4eba\u5458\u76f8\u5173\u7684\u4fe1\u606f\uff0c\u5982\u4fe1\u7bb1\uff0c\u6587\u7ae0\u7b49\u7b49\uff0c\u8fd9\u6837\uff0c\u8fd9\u4e9b\u6570\u636e\u5e93\u64cd\u4f5c\u8bed\u53e5\u5c31\u6784\u6210\u4e00\u4e2a\u4e8b\u52a1\uff01
1.2\u5728 MySQL \u4e2d\u53ea\u6709\u4f7f\u7528\u4e86 Innodb \u6570\u636e\u5e93\u5f15\u64ce\u7684\u6570\u636e\u5e93\u6216\u8868\u624d\u652f\u6301\u4e8b\u52a1\u3002
\u4e8b\u52a1\u5904\u7406\u53ef\u4ee5\u7528\u6765\u7ef4\u62a4\u6570\u636e\u5e93\u7684\u5b8c\u6574\u6027\uff0c\u4fdd\u8bc1\u6210\u6279\u7684 SQL \u8bed\u53e5\u8981\u4e48\u5168\u90e8\u6267\u884c\uff0c\u8981\u4e48\u5168\u90e8\u4e0d\u6267\u884c\u3002
1.3\u4e8b\u52a1\u7528\u6765\u7ba1\u7406 insert,update,delete \u8bed\u53e5.
1.4\u4e00\u822c\u6765\u8bf4\uff0c\u4e8b\u52a1\u662f\u5fc5\u987b\u6ee1\u8db34\u4e2a\u6761\u4ef6\uff08ACID\uff09\uff1a\uff1a\u539f\u5b50\u6027\uff08Atomicity\uff0c\u6216\u79f0\u4e0d\u53ef\u5206\u5272\u6027\uff09\u3001\u4e00\u81f4\u6027\uff08Consistency\uff09\u3001\u9694\u79bb\u6027\uff08Isolation\uff0c\u53c8\u79f0\u72ec\u7acb\u6027\uff09\u3001\u6301\u4e45\u6027\uff08Durability\uff09\u3002
1.4.1\u539f\u5b50\u6027\uff1a\u4e00\u4e2a\u4e8b\u52a1\uff08transaction\uff09\u4e2d\u7684\u6240\u6709\u64cd\u4f5c\uff0c\u8981\u4e48\u5168\u90e8\u5b8c\u6210\uff0c\u8981\u4e48\u5168\u90e8\u4e0d\u5b8c\u6210\uff0c\u4e0d\u4f1a\u7ed3\u675f\u5728\u4e2d\u95f4\u67d0\u4e2a\u73af\u8282\u3002\u4e8b\u52a1\u5728\u6267\u884c\u8fc7\u7a0b\u4e2d\u53d1\u751f\u9519\u8bef\uff0c\u4f1a\u88ab\u56de\u6eda\uff08Rollback\uff09\u5230\u4e8b\u52a1\u5f00\u59cb\u524d\u7684\u72b6\u6001\uff0c\u5c31\u50cf\u8fd9\u4e2a\u4e8b\u52a1\u4ece\u6765\u6ca1\u6709\u6267\u884c\u8fc7\u4e00\u6837\u3002
1.4.2\u4e00\u81f4\u6027\uff1a\u5728\u4e8b\u52a1\u5f00\u59cb\u4e4b\u524d\u548c\u4e8b\u52a1\u7ed3\u675f\u4ee5\u540e\uff0c\u6570\u636e\u5e93\u7684\u5b8c\u6574\u6027\u6ca1\u6709\u88ab\u7834\u574f\u3002\u8fd9\u8868\u793a\u5199\u5165\u7684\u8d44\u6599\u5fc5\u987b\u5b8c\u5168\u7b26\u5408\u6240\u6709\u7684\u9884\u8bbe\u89c4\u5219\uff0c\u8fd9\u5305\u542b\u8d44\u6599\u7684\u7cbe\u786e\u5ea6\u3001\u4e32\u8054\u6027\u4ee5\u53ca\u540e\u7eed\u6570\u636e\u5e93\u53ef\u4ee5\u81ea\u53d1\u6027\u5730\u5b8c\u6210\u9884\u5b9a\u7684\u5de5\u4f5c\u3002
1.4.3\u9694\u79bb\u6027\uff1a\u6570\u636e\u5e93\u5141\u8bb8\u591a\u4e2a\u5e76\u53d1\u4e8b\u52a1\u540c\u65f6\u5bf9\u5176\u6570\u636e\u8fdb\u884c\u8bfb\u5199\u548c\u4fee\u6539\u7684\u80fd\u529b\uff0c\u9694\u79bb\u6027\u53ef\u4ee5\u9632\u6b62\u591a\u4e2a\u4e8b\u52a1\u5e76\u53d1\u6267\u884c\u65f6\u7531\u4e8e\u4ea4\u53c9\u6267\u884c\u800c\u5bfc\u81f4\u6570\u636e\u7684\u4e0d\u4e00\u81f4\u3002\u4e8b\u52a1\u9694\u79bb\u5206\u4e3a\u4e0d\u540c\u7ea7\u522b\uff0c\u5305\u62ec\u8bfb\u672a\u63d0\u4ea4\uff08Read uncommitted\uff09\u3001\u8bfb\u63d0\u4ea4\uff08read committed\uff09\u3001\u53ef\u91cd\u590d\u8bfb\uff08repeatable read\uff09\u548c\u4e32\u884c\u5316\uff08Serializable\uff09\u3002
1.4.5\u6301\u4e45\u6027\uff1a\u4e8b\u52a1\u5904\u7406\u7ed3\u675f\u540e\uff0c\u5bf9\u6570\u636e\u7684\u4fee\u6539\u5c31\u662f\u6c38\u4e45\u7684\uff0c\u5373\u4fbf\u7cfb\u7edf\u6545\u969c\u4e5f\u4e0d\u4f1a\u4e22\u5931\u3002
2.\u4e3a\u4ec0\u4e48\u9700\u8981\u4e8b\u52a1
\u4e3e\u4e2a\u7b80\u5355\u7684\u4f8b\u5b50\uff1a\u5047\u8bbe\u6211\u5728\u94f6\u884c\u4e2d\u7684\u8d26\u6237\u4e2d\u67091000\u5757\u94b1\uff0c\u800c\u6211\u5973\u670b\u53cb\u7684\u8d26\u53f7\u4f59\u989d\u4e3a0\uff0c\u6211\u73b0\u5728\u60f3\u628a\u8fd91000\u5757\u94b1\u8f6c\u7ed9\u6211\u7684\u5973\u670b\u53cb\uff0c\u8fd9\u65f6\u94f6\u884c\u7cfb\u7edf\u5728\u540e\u7aef\u64cd\u4f5c\u6570\u636e\u5e93\u5b58\u53d6\u6570\u636e\u65f6\u7684\u5927\u81f4\u64cd\u4f5c\u5206\u4e3a\u4e24\u6b65\uff1a\uff081\uff09\u4ece\u6570\u636e\u5e93\u4e2d\u5c06\u6211\u7684\u94f6\u884c\u5b58\u6b3e\u91d1\u989d\u4ece1000\u7f6e\u4e3a0.\uff082\uff09\u4ece\u6570\u636e\u5e93\u4e2d\u5c06\u6211\u5973\u670b\u53cb\u7684\u94f6\u884c\u8d26\u6237\u4f59\u989d\u4ece0\u7f6e\u4e3a1000.
\u6309\u7167\u6b63\u5e38\u7684\u6d41\u7a0b\uff0c\u5982\u679c\u4e0d\u51fa\u73b0\u610f\u5916\uff0c\u90a3\u4e48\u4f1a\u6210\u529f\u8f6c\u8d26\uff0c\u6211\u8d26\u6237\u7684\u4f59\u989d\u4e3a0\uff0c\u6211\u5973\u670b\u53cb\u7684\u8d26\u6237\u4f59\u989d\u4e3a1000.\u4f46\u662f\uff0c\u5982\u679c\u5728\u6211\u8f6c\u8d26\u7684\u8fc7\u7a0b\u4e2d\u670d\u52a1\u5668\u53d1\u751f\u4e86\u9519\u8bef\uff0c\u5e76\u4e14\u521a\u597d\u5728\u6b65\u9aa4\uff081\uff09\u548c\uff082\uff09\u4e4b\u95f4\u53d1\u751f\u4e86\u6545\u969c\uff0c\u5bfc\u81f4\u6b65\u9aa4\uff082\uff09\u65e0\u6cd5\u6267\u884c\uff0c\u90a3\u4e48\u8fd9\u65f6\u5019\u9020\u6210\u7684\u7ed3\u679c\u5c31\u662f\u6211\u7684\u8d26\u6237\u4f59\u989d\u4ece1000\u53d8\u4e3a0\u4e86\uff0c\u4f46\u662f\u6211\u5973\u670b\u53cb\u7684\u8d26\u6237\u4f59\u989d\u8fd8\u662f0\uff0c\u8fd91000\u5757\u94b1\u6ca1\u6709\u8f6c\u5230\u6211\u5973\u670b\u53cb\u7684\u8d26\u6237\u91cc\uff0c\u88ab\u94f6\u884c\u7ed9\u201c\u5403\u4e86\u201d\u3002\u6240\u4ee5\u4e3a\u4e86\u5b89\u5168\uff0c\u6211\u4eec\u9700\u8981\u5c06\u8f6c\u8d26\u6b65\u9aa4\uff081\uff09\u548c\uff082\uff09\u770b\u6210\u4e00\u4e2a\u6574\u4f53\uff0c\u4e5f\u5c31\u662f\u770b\u6210\u4e00\u4e2a\u4e8b\u52a1\uff0c\u5f53\u5176\u4e2d\u7684\u4efb\u4f55\u4e00\u4e2a\u6b65\u9aa4\u51fa\u73b0\u4e86\u9519\u8bef\uff0c\u8be5\u4e8b\u52a1\u90fd\u4e0d\u4f1a\u63d0\u4ea4\uff0c\u76f4\u63a5\u56de\u6eda\uff0c\u8fd9\u6837\u5c31\u4e0d\u4f1a\u51fa\u73b0\u6211\u8f6c\u8d26\u65f6\u6211\u7684\u8d26\u53f7\u91d1\u989d\u4ece1000\u53d8\u4e3a0\u4e86\uff0c\u800c\u6211\u7684\u5973\u670b\u53cb\u7684\u8d26\u53f7\u8fd8\u662f0\u7684\u73b0\u8c61 \u3002\u8fd9\u65f6\u5019\u8981\u4e48\u6211\u7684\u8d26\u53f7\u662f1000\uff0c\u5973\u670b\u53cb\u7684\u8d26\u53f7\u662f0\uff0c\u8981\u4e48\u662f\u6211\u7684\u8d26\u6237\u662f0\uff0c\u6211\u5973\u670b\u53cb\u7684\u8d26\u6237\u662f1000\uff0c\u8fd9\u5c31\u4fdd\u8bc1\u4e86\u6211\u94f6\u884c\u8d26\u53f7\u7684\u5b89\u5168\u3002
3.\u5728Spring\u4e2d\u662f\u652f\u6301\u4e8b\u52a1\u7ba1\u7406\u7684\uff0c\u6211\u4eec\u53ea\u9700\u8981\u914d\u7f6e\u597d\u5bf9\u5e94\u7684\u6587\u4ef6\u5c31\u53ef\u4ee5\u4e86\u3002\u4e3a\u4e86\u66f4\u52a0\u6df1\u5165\u5b66\u4e60\u548c\u63a2\u7a76Spring\u7684\u4e8b\u52a1\u7ba1\u7406\uff0c\u6b64\u6b21\u5b9e\u73b0\u81ea\u5b9a\u4e49Spring\u7684\u4e8b\u52a1\u7ba1\u7406\u3002
3.1\u5efa\u7acb\u6570\u636e\u5e93\uff0c\u5e76\u5efa\u7acbAccount\u8868\u5355<\/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
3.2\u5728maven\u4e2d\u521b\u5efa\u4e00\u4e2a\u9879\u76ee\u3002<\/p>\n\n\n\n
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
3.3\u5728pom.xml\u4e2d\u5f15\u5165\u4f9d\u8d56\u6587\u4ef6<\/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>springdemo4<\/artifactId>\n    <version>1.0-SNAPSHOT<\/version>\n    <dependencies>\n<!--        \u5f15\u5165MySQL\u7684\u4f9d\u8d56\u6587\u4ef6-->\n        <dependency>\n            <groupId>mysql<\/groupId>\n            <artifactId>mysql-connector-java<\/artifactId>\n            <version>8.0.21<\/version>\n        <\/dependency>\n<!--        \u5f15\u5165Spring\u7684\u4f9d\u8d56\u6587\u4ef6-->\n        <dependency>\n            <groupId>org.springframework<\/groupId>\n            <artifactId>spring-core<\/artifactId>\n            <version>5.2.8.RELEASE<\/version>\n        <\/dependency>\n        <!-- https:\/\/mvnrepository.com\/artifact\/org.springframework\/spring-context -->\n        <dependency>\n            <groupId>org.springframework<\/groupId>\n            <artifactId>spring-context<\/artifactId>\n            <version>5.2.8.RELEASE<\/version>\n        <\/dependency>\n        <!-- \u5f15\u5165jdbc\u8fde\u63a5\u6570\u636e\u5e93\u7684\u5de5\u5177\u4f9d\u8d56\uff0c\u7528\u4e8e\u8bbf\u95ee\u6570\u636e\u5e93\u63d0\u4f9b\u4fbf\u5229\u64cd\u4f5c -->\n        <dependency>\n            <groupId>commons-dbutils<\/groupId>\n            <artifactId>commons-dbutils<\/artifactId>\n            <version>1.7<\/version>\n        <\/dependency>\n        <!--\u5f15\u5165c3p0\u6570\u636e\u5e93\u8fde\u63a5\u6c60-->\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\n    <\/dependencies>\n\n<\/project><\/code><\/pre>\n\n\n\n
4.\u5f00\u59cb\u7f16\u5199\u4ee3\u7801<\/strong>
4.1\u5728entity\u5305\u4e2d\u5f00\u59cb\u7f16\u5199Account\u5b9e\u4f53\u7c7b\u3002<\/p>\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
4.2\u5728dao\u5305\u4e2d\u7f16\u5199AccountDao\u63a5\u53e3<\/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
4.3\u5728service\u5305\u4e2d\u521b\u5efaAccountService\u63a5\u53e3<\/p>\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
5.\u5f00\u59cb\u4e66\u5199\u4e8b\u52a1\u652f\u6301\u5de5\u5177\u7c7b
5.1\u5728util\u5305\u4e2d\u65b0\u5efaDataConnectionUtil.java<\/p>\n\n\n\n
package util;\n\nimport javax.sql.DataSource;\nimport java.sql.Connection;\nimport java.sql.SQLException;\n\n\/**\n * Classname:DataConnectionUtil\n *\n * @description:\n * @author: \u964c\u610f\u968f\u5f71\n * @Date: 2020-08-02 12:52\n * @Version: 1.0\n **\/\npublic class DataConnectionUtil {\n    \/\/\u7ebf\u7a0b\u5c40\u90e8\u53d8\u91cf\uff0c\u540c\u4e00\u4e2a ThreadLocal \u6240\u5305\u542b\u7684\u5bf9\u8c61\uff0c\u5728\u4e0d\u540c\u7684 Thread \u4e2d\u6709\u4e0d\u540c\u7684\u526f\u672c\uff0c\u7528\u4e8e\u9632\u6b62\u591a\u7ebf\u7a0b\u5171\u4eab\uff0c\u4ece\u800c\u66f4\u52a0\u5b89\u5168\n    private static ThreadLocal<Connection> threadLocal=new ThreadLocal<Connection>();\n    \/\/\u6570\u636e\u5e93\u7684\u6570\u636e\u6e90\n    private DataSource dataSource ;\n  \/\/\u7528\u6237\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u6ce8\u5165\u6570\u636e\u6e90\n    public void setDataSource(DataSource dataSource) {\n        this.dataSource = dataSource;\n    }\n  \/**\n   * @Description :\u83b7\u53d6\u6570\u636e\u5e93\u8fde\u63a5\n   * @Date 12:00 2020\/8\/9 0009\n   * @Param * @param  \uff1a\n   * @return java.sql.Connection\n   **\/\n    public Connection getConnection(){\n        \/\/\u4ece\u83b7\u53d6\u8fde\u63a5\n        Connection connection = threadLocal.get();\n        if (connection == null){\n            \/\/\u5c1a\u672a\u6709\u8fde\u63a5\n            try {\n                \/\/\u4ece\u6570\u636e\u6e90\u4e2d\u83b7\u53d6\u4e00\u4e2a\u8fde\u63a5\n                connection = dataSource.getConnection();\n                \/\/\u5c06\u8be5\u8fde\u63a5\u8bbe\u7f6e\u5230\u7ebf\u7a0b\u5c40\u90e8\u53d8\u91cf\u4e2d\n                threadLocal.set(connection);\n                return connection;\n            } catch (SQLException e) {\n               throw  new RuntimeException(\"\u83b7\u53d6\u6570\u636e\u5e93\u8fde\u63a5\u9519\u8bef\uff01\");\n            }\n        }\n        return connection;\n    }\n    \/**\n     * @Description :\u4ece\u7ebf\u7a0b\u5c40\u90e8\u53d8\u91cf\u4e2d\u79fb\u9664\u5df2\u7ecf\u7ed1\u5b9a\u7684\u8fde\u63a5\u5bf9\u8c61\n     * @Date 12:04 2020\/8\/9 0009\n     * @Param * @param  \uff1a\n     * @return void\n     **\/\n public void removeConnection(){\n        threadLocal.remove();\n }\n}<\/code><\/pre>\n\n\n\n
\u5728\u83b7\u53d6\u7ebf\u7a0b\u8fde\u63a5\u7684\u8fc7\u7a0b\u4e2d\uff0c\u6211\u4eec\u5c06\u4ece\u6570\u636e\u6e90DataSource\u83b7\u53d6\u7684\u8fde\u63a5\u5bf9\u8c61\u4fdd\u5b58\u5230\u5c40\u90e8\u7ebf\u7a0b\u53d8\u91cfThreadLocal\u4e2d\u3002\u5bf9\u4e8eThreadLocal\uff0c\u6709\u4ee5\u4e0b\u7279\u70b9\uff1a
ThreadLoal \u53d8\u91cf\uff0c\u7ebf\u7a0b\u5c40\u90e8\u53d8\u91cf\uff0c\u540c\u4e00\u4e2a ThreadLocal \u6240\u5305\u542b\u7684\u5bf9\u8c61\uff0c\u5728\u4e0d\u540c\u7684 Thread \u4e2d\u6709\u4e0d\u540c\u7684\u526f\u672c\u3002\u8fd9\u91cc\u6709\u51e0\u70b9\u9700\u8981\u6ce8\u610f\uff1a
\u56e0\u4e3a\u6bcf\u4e2a Thread \u5185\u6709\u81ea\u5df1\u7684\u5b9e\u4f8b\u526f\u672c\uff0c\u4e14\u8be5\u526f\u672c\u53ea\u80fd\u7531\u5f53\u524d Thread \u4f7f\u7528\u3002\u8fd9\u662f\u4e5f\u662f ThreadLocal \u547d\u540d\u7684\u7531\u6765\u3002\u65e2\u7136\u6bcf\u4e2a Thread \u6709\u81ea\u5df1\u7684\u5b9e\u4f8b\u526f\u672c\uff0c\u4e14\u5176\u5b83 Thread \u4e0d\u53ef\u8bbf\u95ee\uff0c\u90a3\u5c31\u4e0d\u5b58\u5728\u591a\u7ebf\u7a0b\u95f4\u5171\u4eab\u7684\u95ee\u9898\u3002ThreadLocal \u63d0\u4f9b\u4e86\u7ebf\u7a0b\u672c\u5730\u7684\u5b9e\u4f8b\u3002\u5b83\u4e0e\u666e\u901a\u53d8\u91cf\u7684\u533a\u522b\u5728\u4e8e\uff0c\u6bcf\u4e2a\u4f7f\u7528\u8be5\u53d8\u91cf\u7684\u7ebf\u7a0b\u90fd\u4f1a\u521d\u59cb\u5316\u4e00\u4e2a\u5b8c\u5168\u72ec\u7acb\u7684\u5b9e\u4f8b\u526f\u672c\u3002ThreadLocal \u53d8\u91cf\u901a\u5e38\u88abprivate static\u4fee\u9970\u3002\u5f53\u4e00\u4e2a\u7ebf\u7a0b\u7ed3\u675f\u65f6\uff0c\u5b83\u6240\u4f7f\u7528\u7684\u6240\u6709 ThreadLocal \u76f8\u5bf9\u7684\u5b9e\u4f8b\u526f\u672c\u90fd\u53ef\u88ab\u56de\u6536\u3002\u603b\u7684\u6765\u8bf4\uff0cThreadLocal \u9002\u7528\u4e8e\u6bcf\u4e2a\u7ebf\u7a0b\u9700\u8981\u81ea\u5df1\u72ec\u7acb\u7684\u5b9e\u4f8b\u4e14\u8be5\u5b9e\u4f8b\u9700\u8981\u5728\u591a\u4e2a\u65b9\u6cd5\u4e2d\u88ab\u4f7f\u7528\uff0c\u4e5f\u5373\u53d8\u91cf\u5728\u7ebf\u7a0b\u95f4\u9694\u79bb\u800c\u5728\u65b9\u6cd5\u6216\u7c7b\u95f4\u5171\u4eab\u7684\u573a\u666f\u3002
5.2\u521b\u5efa\u4e8b\u52a1\u7ba1\u7406\u7684TransactionManager.java<\/p>\n\n\n\n
package util;\n\nimport java.sql.SQLException;\n\n\/**\n * Classname:TransactionManager\n *\n * @description:\n * @author: \u964c\u610f\u968f\u5f71\n * @Date: 2020-08-02 13:00\n * @Version: 1.0\n **\/\npublic class TransactionManager {\n    \/\/\u6570\u636e\u5e93\u8fde\u63a5\u5de5\u5177\u83b7\u53d6\u8fde\u63a5\n   private DataConnectionUtil dataConnectionUtil ;\n   \/**\n    * @Description :\u7528\u4e8e\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u6ce8\u5165DataConnectionUtil\n    * @Date 12:11 2020\/8\/9 0009\n    * @Param * @param dataConnectionUtil \uff1a\n    * @return void\n    **\/\n    public void setDataConnectionUtil(DataConnectionUtil dataConnectionUtil) {\n        this.dataConnectionUtil = dataConnectionUtil;\n    }\n   \/**\n    * @Description :\u5f00\u59cb\u4e8b\u52a1\n    * @Date 12:12 2020\/8\/9 0009\n    * @Param * @param  \uff1a\n    * @return void\n    **\/\n    public void beginTransaction(){\n       try {\n           \/\/\u5c06\u6570\u636e\u6d41\u8fde\u63a5Connection\u5bf9\u8c61\u8bbe\u7f6e\u4e3a\u7981\u6b62\u81ea\u52a8\u63d0\u4ea4\uff0c\u6539\u4e3a\u624b\u52a8\u63d0\u4ea4\n           dataConnectionUtil.getConnection().setAutoCommit(false);\n       } catch (SQLException e) {\n           e.printStackTrace();\n       }\n   }\n   \/**\n    * @Description :\u63d0\u4ea4\u4e8b\u52a1\uff0c\u5f53\u6240\u6709\u64cd\u4f5c\u6b65\u9aa4\u90fd\u6b63\u786e\u65e0\u8bef\u65f6\u624b\u52a8\u63d0\u4ea4\u4e8b\u52a1\n    * @Date 12:12 2020\/8\/9 0009\n    * @Param * @param  \uff1a\n    * @return void\n    **\/\n public  void commit(){\n     try {\n         \/\/\u63d0\u4ea4\u4e8b\u52a1\n         dataConnectionUtil.getConnection().commit();\n     } catch (SQLException e) {\n         e.printStackTrace();\n     }\n }\n \/**\n  * @Description :\u56de\u6eda\u4e8b\u52a1\u3002\u5f53\u6570\u636e\u5e93\u64cd\u4f5c\u8fc7\u7a0b\u4e2d\u4efb\u4f55\u4e00\u4e2a\u6b65\u9aa4\u51fa\u73b0\u95ee\u9898\u4fbf\u56de\u6eda\u4e8b\u52a1\n  * @Date 12:13 2020\/8\/9 0009\n  * @Param * @param  \uff1a\n  * @return void\n  **\/\n public void rollback(){\n     try {\n         \/\/\u56de\u6eda\u4e8b\u52a1\n         dataConnectionUtil.getConnection().rollback();\n     } catch (SQLException e) {\n         e.printStackTrace();\n     }\n }\n \/**\n  * @Description :\u91ca\u653e\u8d44\u6e90\n  * @Date 12:14 2020\/8\/9 0009\n  * @Param * @param  \uff1a\n  * @return void\n  **\/\n public void release(){\n     \/\/\u79fb\u9664Connection\u5bf9\u8c61\n       dataConnectionUtil.removeConnection();\n }\n}<\/code><\/pre>\n\n\n\n
6.\u4e66\u5199\u4e1a\u52a1\u903b\u8f91\u548c\u6301\u4e45\u5c42\u4ee3\u7801
6.1\u5728dao\u5305\u4e2d\u65b0\u5efaAccountDao\u7684\u5b9e\u73b0\u7c7bAccountDaoImpl.java<\/p>\n\n\n\n
package dao;\n\nimport entity.Account;\nimport org.apache.commons.dbutils.QueryRunner;\nimport org.apache.commons.dbutils.handlers.BeanHandler;\nimport org.apache.commons.dbutils.handlers.BeanListHandler;\nimport org.springframework.stereotype.Repository;\nimport util.DataConnectionUtil;\n\nimport java.sql.SQLException;\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    QueryRunner queryRunner = null;\n  \/\/    \u81ea\u5b9a\u4e49\u6570\u636e\u8fde\u63a5\u5de5\u5177\n    DataConnectionUtil dataConnectionUtil;\n    \/**\n     * @Description :\u65b9\u4fbf\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u6ce8\u5165QueryRunner\u5bf9\u8c61\n     * @Date 12:16 2020\/8\/9 0009\n     * @Param * @param queryRunner \uff1a\n     * @return void\n     **\/\n    public void setQueryRunner(QueryRunner queryRunner) {\n        this.queryRunner = queryRunner;\n    }\n \/**\n  * @Description :\u65b9\u4fbf\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u6ce8\u5165DataConnectionUtil\u5bf9\u8c61\n  * @Date 12:17 2020\/8\/9 0009\n  * @Param * @param dataConnectionUtil \uff1a\n  * @return void\n  **\/\n    public void setDataConnectionUtil(DataConnectionUtil dataConnectionUtil) {\n        this.dataConnectionUtil = dataConnectionUtil;\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        try {\n            return queryRunner.update(dataConnectionUtil.getConnection(),\"insert into account(name,password,age,createTIme,money) values(?,?,?,?,?)\",\n                    newAccount.getName(),newAccount.getPassword(),\n                    newAccount.getAge(),newAccount.getCreateTime(),newAccount.getMoney())== 1;\n        } catch (SQLException e) {\n            e.printStackTrace();\n        }finally {\n            return  false;\n        }\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        try {\n            return queryRunner.update(dataConnectionUtil.getConnection(),\"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        } catch (SQLException e) {\n            e.printStackTrace();\n        }finally {\n            return  false;\n        }\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        try {\n            return queryRunner.update(dataConnectionUtil.getConnection(),\"delete from account where id=?\",id) == 1;\n        } catch (SQLException e) {\n            e.printStackTrace();\n        }finally {\n            return  false;\n        }\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        Account account;\n        try {\n         account = queryRunner.query(dataConnectionUtil.getConnection(),\"select* from account where id=?\", new BeanHandler<Account>(Account.class), id);\n         return  account;\n        } catch (SQLException e) {\n            e.printStackTrace();\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        try {\n            return queryRunner.query(dataConnectionUtil.getConnection(),\"select* from account\",new BeanListHandler<Account>(Account.class));\n        } catch (SQLException e) {\n            e.printStackTrace();\n        }\n            return  null;\n\n    }\n\n}<\/code><\/pre>\n\n\n\n
6.2\u5728service\u5305\u4e2d\u65b0\u5efaAccountService\u7684\u5b9e\u73b0\u6765AccountServiceImpl.java<\/p>\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        \/\/\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
7.\u6211\u4eec\u5df2\u7ecf\u5199\u597d\u4e86\u5bf9\u7528\u6237\u8bbf\u95ee\u7684\u5b9e\u4f53\u7c7b\uff0c\u4e0e\u6570\u636e\u5e93\u6253\u4ea4\u9053\u7684dao\uff0c\u4ee5\u53ca\u4e1a\u52a1\u903b\u8f91\u7684Service\uff0c\u4f46\u662f\u6211\u4eec\u73b0\u5728\u8fd8\u6ca1\u6709\u771f\u6b63\u548c\u4e8b\u52a1\u7ba1\u7406\u626f\u4e0a\u5173\u7cfb\u3002\u6211\u4eec\u8d1f\u8d23\u5bf9\u4e8b\u52a1\u7684\u7ba1\u7406\u65f6\u662f\u8981\u5728\u4e1a\u52a1\u903b\u8f91\u8fd9\u91cc\u8fdb\u884c\u4e8b\u52a1\u7684\u63a7\u5236\u3002\u56e0\u6b64\u8981\u5bf9AccountServiceImpl\u8fdb\u884c\u4e8b\u52a1\u7684\u7ba1\u7406\u3002\u90a3\u4e48\u6211\u4eec\u8be5\u5982\u4f55\u8fdb\u884c\u7ba1\u7406\u5462\uff1f
\u6211\u4eec\u9996\u5148\u60f3\u5230\u6700\u7b80\u5355\u7684\u7ba1\u7406\u65b9\u6cd5\uff1a<\/p>\n\n\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        try {\n            \/\/\u5f00\u59cb\u4e8b\u52a1\n            transactionManager.beginTransaction();\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        \/\/\u66f4\u65b0\u8f6c\u8d26\u76ee\u6807\u8005\u7684\u8d26\u6237\n        boolean b1 = this.updateAccount(targetAccount);\n        \/\/\u63d0\u4ea4\u4e8b\u52a1\n        transactionManager.commit();\n            return  b == true && b1 == true;\n\n        }catch (Exception e){\n             e.printStackTrace();\n             \/\/\u56de\u6eda\u4e8b\u52a1\n             transactionManager.rollback();\n\n        }\n        \/\/\u91ca\u653e\u8d44\u6e90\n        transactionManager.release();\n        return  false;\n    }<\/code><\/pre>\n\n\n\n
\u6211\u4eec\u5728AccountServiceImpl\u5185\u90e8\u8fdb\u884c\u5bf9\u4e8b\u52a1\u7684\u7ba1\u7406\uff0c\u62ff tranferMoney(int sourceId, int targetId, int money)\u51fd\u6570\u4e3a\u4f8b\uff0c\u5bf9\u4e8b\u52a1\u7684\u7ba1\u7406\u7ecf\u5386\uff1a1.beginTransaction\u5f00\u59cb\u4e8b\u52a1\uff1b
2.\u662f\u5426\u6709\u5f02\u5e38\uff1f
2.1\u6b65\u9aa4\u5168\u90fd\u6b63\u5e38\u5219commit\u63d0\u4ea4\u4e8b\u52a1
2.2\u6b65\u9aa4\u4e2d\u5b58\u5728\u5f02\u5e38\u5219rollback\u56de\u6eda\u4e8b\u52a1\u3002
3.release\u91ca\u653eConnection\u5bf9\u8c61\u3002
\u663e\u7136\u8fd9\u662f\u5f88\u597d\u7406\u89e3\u7684\u4e8b\u52a1\u7ba1\u7406\u65b9\u5f0f\uff0c\u4f46\u662f\u6211\u4eec\u53ef\u4ee5\u770b\u5230\u5728AccountServiceImpl\u4e2d\u8fd8\u6709\u5f88\u591a\u4e2a\u5176\u5b83\u7684\u65b9\u6cd5\uff0c\u6bd4\u5982saveAccount(Account account)\uff0cupdateAccount(Account newAccount)\u7b49\u8fd9\u4e9b\u65b9\u6cd5\uff0c\u8981\u662f\u6211\u4eec\u6bcf\u4e2a\u65b9\u6cd5\u90fd\u50cftranferMoney(int sourceId, int targetId, int money)\u51fd\u6570\u4e00\u6837\u8fdb\u884c\u4e8b\u52a1\u7ba1\u7406\uff0c\u90a3\u4e48\u663e\u7136\u4ee3\u7801\u4f1a\u5197\u4f59\u91cd\u590d\uff0c\u5f88\u4e0d\u53cb\u597d\u3002\u7531\u4e8e\u8fd9\u51e0\u4e2a\u6b65\u9aa4\u90fd\u662f\u4e00\u81f4\u7684\uff0c\u9996\u5148\u5f00\u59cb\u4e8b\u52a1\uff0c\u5176\u6b21\u5982\u679c\u6ca1\u6709\u5f02\u5e38\u5219\u63d0\u4ea4\u4e8b\u52a1\uff0c\u6709\u5f02\u5e38\u5219\u56de\u6eda\u4e8b\u52a1\uff0c\u6700\u540e\u662f\u91ca\u653e\u4e8b\u52a1\u3002\u6211\u4eec\u53ef\u4ee5\u6839\u636e\u8fd9\u4e2a\u6267\u884c\u89c4\u5f8b\uff0c\u4f7f\u7528\u52a8\u6001\u4ee3\u7406\u7684\u65b9\u5f0f\u5bf9AccountServiceImpl\u4e2d\u7684\u6bcf\u4e2a\u4e0e\u6570\u636e\u5e93\u6253\u4ea4\u9053\u7684\u65b9\u6cd5\u8fdb\u884c\u589e\u5f3a\uff0c\u4ece\u800c\u51cf\u5c11\u4e86\u4ee3\u7801\u7684\u5197\u4f59\u3002
8.\u5728factory\u5305\u4e2d\u65b0\u5efa\u4e00\u4e2aBeanFactory.java\u4f7f\u7528\u52a8\u6001\u4ee3\u7406\u5bf9AccountServiceImpl\u7684\u4e1a\u52a1\u903b\u8f91\u8fdb\u884c\u589e\u5f3a\u3002<\/p>\n\n\n\n
package factory;\n\nimport service.AccountService;\nimport util.TransactionManager;\nimport java.lang.reflect.InvocationHandler;\nimport java.lang.reflect.Method;\nimport java.lang.reflect.Proxy;\n\n\/**\n * Classname:BeanFactory\n *\n * @description:\n * @author: \u964c\u610f\u968f\u5f71\n * @Date: 2020-08-02 15:47\n * @Version: 1.0\n **\/\npublic class BeanFactory {\n    \/\/\u4f7f\u7528AccountServiceImpl\u7684\u7236\u63a5\u53e3\uff0c\u4f5c\u4e3a\u88ab\u4ee3\u7406\u7684\u63a5\u53e3\n   private     AccountService accountService ;\n   \/\/\u4e8b\u52a1\u7ba1\u7406\n    private TransactionManager transactionManager;\n   \/**\n    * @Description :\u65b9\u4fbf\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u8fdb\u884c\u6ce8\u5165AccountServiceImpl\n    * @Date 13:03 2020\/8\/9 0009\n    * @Param * @param accountService \uff1a\n    * @return void\n    **\/\n    public void setAccountService(AccountService accountService) {\n        this.accountService = accountService;\n    }\n   \/**\n    * @Description :\u65b9\u4fbf\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u6ce8\u5165TransactionManager\n    * @Date 13:03 2020\/8\/9 0009\n    * @Param * @param transactionManager \uff1a\n    * @return void\n    **\/\n    public void setTransactionManager(TransactionManager transactionManager) {\n        this.transactionManager = transactionManager;\n    }\n    \/**\n     * @Description :\u8fd4\u56de\u4e00\u4e2a\u7ecf\u8fc7\u52a8\u6001\u4ee3\u7406\u589e\u5f3a\u540e\u7684AccountService\u5bf9\u8c61\uff0c\u5b9e\u9645\u4e0a\u662f\u5bf9AccountServiceImpl\u8fdb\u884c\u589e\u5f3a\u540e\u8fd4\u56de\u5176\u7236\u63a5\u53e3\uff0c\u9762\u5411\u63a5\u53e3\u7f16\u7a0b\n     * @Date 13:03 2020\/8\/9 0009\n     * @Param * @param  \uff1a\n     * @return service.AccountService\n     **\/\n   public  AccountService AccountServiceInstance(){\n       Object proxyInstance = Proxy.newProxyInstance(accountService.getClass().getClassLoader(),\n               accountService.getClass().getInterfaces(),\n               new InvocationHandler() {\n          \/**\n           * @Description :\u901a\u8fc7\u52a8\u6001\u4ee3\u7406\u5bf9accountService\u7684\u65b9\u6cd5\u8fdb\u884c\u589e\u5f3a\n           * @Date 13:05 2020\/8\/9 0009\n           * @Param * @param proxy  \u88ab\u4ee3\u7406\u7684\u5bf9\u8c61\uff0c\u4e5f\u5c31\u662faccountService\n           * @param method \uff1a\u9700\u8981\u589e\u5f3a\u7684\u65b9\u6cd5\n           * @param args \uff1a\u65b9\u6cd5\u4e2d\u7684\u5b9e\u9645\u53c2\u6570\u6570\u7ec4\n           * @return java.lang.Object\n           **\/\n           public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {\n               Object value = null;\n               try {\n                   \/\/\u5f00\u59cb\u4e8b\u52a1\n                   transactionManager.beginTransaction();\n                   \/\/\u8c03\u7528\u8be5\u65b9\u6cd5\u5e76\u8fd4\u56de\u7ed3\u679c\n                   value = method.invoke(accountService, args);\n                   \/\/\u63d0\u4ea4\u4e8b\u52a1\n                 transactionManager.commit();\n           \n               }catch (Exception e){\n                   transactionManager.rollback();\n                   e.printStackTrace();\n               }finally {\n                   transactionManager.release();\n               }\n               return  value;\n           }\n       });\n       return (AccountService) proxyInstance;\n   }\n\n}<\/code><\/pre>\n\n\n\n
\u8be5\u7c7b\u4e2d\u7684private AccountService accountService\u5b9e\u9645\u4e0a\u901a\u8fc7set\u65b9\u6cd5\u4ece\u5916\u90e8\u6ce8\u5165\u4e00\u4e2aAccountService\u7684\u5b9e\u73b0\u7c7bAccountServiceImpl\u540e\uff0caccountService\u5b9e\u9645\u4e0a\u5c31\u662f\u4e00\u4e2aAccountServiceImpl\uff0c\u4e0d\u8fc7\uff0c\u5728\u52a8\u6001\u4ee3\u7406\u4e2d\uff0c\u9700\u8981\u4f7f\u7528\u5230\u63a5\u53e3\u7684\u6570\u7ec4\uff0c\u6240\u4ee5\u6211\u4eec\u9700\u8981\u4f7f\u7528AccountServiceImpl\u7684\u7236\u63a5\u53e3 AccountService\u4f5c\u4e3a\u53c2\u6570\u53d8\u91cfaccountService\uff0c\u7136\u540e\u5728 AccountServiceInstance()\u4e2d\u5229\u7528\u52a8\u6001\u4ee3\u7406\u8fdb\u884c\u589e\u5f3aAccountServiceImpl\u3002
\u52a8\u6001\u4ee3\u7406\u7684\u65b9\u6cd5\u89e3\u6790\uff1a
public static Object newProxyInstance\u200b(ClassLoader loader,
Class[] interfaces,
InvocationHandler h)
\u53c2\u6570 \uff1a
loader - \u7c7b\u52a0\u8f7d\u5668\u6765\u5b9a\u4e49\u4ee3\u7406\u7c7b
interfaces - \u8981\u5b9e\u73b0\u7684\u4ee3\u7406\u7c7b\u7684\u63a5\u53e3\u5217\u8868
h - \u8c03\u5ea6\u65b9\u6cd5\u8c03\u7528\u7684\u8c03\u7528\u5904\u7406\u51fd\u6570
\u7ed3\u679c \uff1a\u5177\u6709\u7531\u6307\u5b9a\u7684\u7c7b\u52a0\u8f7d\u5668\u5b9a\u4e49\u5e76\u5b9e\u73b0\u6307\u5b9a\u63a5\u53e3\u7684\u4ee3\u7406\u7c7b\u7684\u6307\u5b9a\u8c03\u7528\u5904\u7406\u7a0b\u5e8f\u7684\u4ee3\u7406\u5b9e\u4f8b\u3002
\u5728\u672c\u6b21\u6d4b\u8bd5\u4e2d\uff0c\u5b9e\u73b0\u7684\u4ee3\u7406\u7c7b\u7684\u63a5\u53e3\u5217\u8868\u662fAccountService \u4e2d\u7684\u6240\u6709\u65b9\u6cd5\u3002\u5982\u679c\u60f3\u8981\u72ec\u80c6\u4ee3\u7406\u67d0\u4e9b\u65b9\u6cd5\u800c\u4e0d\u662f\u6240\u6709\u7684\u65b9\u6cd5\uff0c\u53ef\u4ee5\u4ece accountService.getClass().getInterfaces()\u63a5\u53e3\u6570\u7ec4\u4e2d\u9009\u62e9\u81ea\u5df1\u60f3\u8981\u52a0\u5f3a\u7684\u63a5\u53e3\u3002
9.\u914d\u7f6ebean.xml\u6587\u4ef6<\/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       xsi:schemaLocation=\"http:\/\/www.springframework.org\/schema\/beans\n        http:\/\/www.springframework.org\/schema\/beans\/spring-beans.xsd\">\n    <!-- \u914d\u7f6e\u5b9e\u4f53\u7c7bAccount-->\n    <bean id=\"account\" class=\"entity.Account\" scope=\"prototype\"><\/bean>\n<!--    \u914d\u7f6eDataConnectionUtil-->\n    <bean id=\"dataConnectionUtil\" class=\"util.DataConnectionUtil\">\n<!--        \u6ce8\u5165\u6570\u636e\u6e90DataSource-->\n        <property name=\"dataSource\" ref=\"dataSource\"><\/property>\n    <\/bean>\n<!--    \u914d\u7f6eTransactionManager-->\n    <bean id=\"transactionManager\" class=\"util.TransactionManager\">\n<!--        \u6ce8\u5165DataConnectionUtil-->\n        <property name=\"dataConnectionUtil\" ref=\"dataConnectionUtil\"><\/property>\n    <\/bean>\n<!--    \u914d\u7f6eBeanFactory\uff0c\u65b9\u4fbf\u901a\u8fc7\u5de5\u5382\u65b9\u6cd5\u83b7\u53d6\u589e\u5f3a\u540e\u7684AccountServiceImpl-->\n        <bean id=\"beanFactory\"  class=\"factory.BeanFactory\" >\n<!--            \u6ce8\u5165TransactionManager-->\n            <property name=\"transactionManager\" ref=\"transactionManager\"><\/property>\n<!--            \u6ce8\u5165AccountServiceImpl-->\n            <property name=\"accountService\" ref=\"accountService\"><\/property>\n        <\/bean>\n<!--    \u901a\u8fc7beanFactory\u7684AccountServiceInstance\u65b9\u6cd5\u83b7\u53d6\u7ecf\u8fc7\u52a8\u6001\u4ee3\u7406\u589e\u5f3a\u540e\u7684AccountServiceImpl-->\n    <bean id=\"beanFactoryService\" factory-bean=\"beanFactory\" factory-method=\"AccountServiceInstance\">\n    <\/bean>\n<!--    \u914d\u7f6eAccountDaoImpl-->\n        <bean id=\"accountDao\" class=\"dao.AccountDaoImpl\">\n<!--            \u6ce8\u5165queryRunner-->\n         <property name=\"queryRunner\" ref=\"queryRunner\"><\/property>\n<!--            \u6ce8\u5165dataConnectionUtil-->\n        <property name=\"dataConnectionUtil\" ref=\"dataConnectionUtil\"><\/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<!--     \u914d\u7f6eQueryRunner-->\n        <bean  id=\"queryRunner\" class=\"org.apache.commons.dbutils.QueryRunner\"> <\/bean>\n<!--    \u914d\u7f6ec3p0\u7684\u6570\u636e\u5e93ComboPooledDataSource-->\n        <bean id=\"dataSource\" class=\"com.mchange.v2.c3p0.ComboPooledDataSource\">\n<!--            \u6570\u636e\u5e93\u8fde\u63a5\u7684\u7528\u6237\u540d-->\n            <property name=\"user\" value=\"root\"><\/property>\n            <!--            \u6570\u636e\u5e93\u8fde\u63a5\u7684\u9a71\u52a8-->\n            <property name=\"driverClass\" value=\"com.mysql.cj.jdbc.Driver\"><\/property>\n            <!--            \u6570\u636e\u5e93\u8fde\u63a5\u7684\u5bc6\u7801-->\n            <property name=\"password\" value=\"root\"><\/property>\n            <!--            \u6570\u636e\u5e93\u8fde\u63a5\u7684URL-->\n            <property name=\"jdbcUrl\" value=\"jdbc:mysql:\/\/localhost:3306\/springdemo?serverTimezone=UTC\"><\/property>\n        <\/bean>\n\n<\/beans><\/code><\/pre>\n\n\n\n
10.\u8fdb\u884c\u6d4b\u8bd5<\/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 testTran1(){\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    @Test\n    public void testTran2(){\n        \/\/\u83b7\u53d6\u901a\u8fc7\u52a8\u6001\u4ee3\u7406\u589e\u5f3a\u540e\u53ef\u8fdb\u884c\u4e8b\u52a1\u7ba1\u7406\u7684AccountServiceImpl\n        AccountService accountService = applicationContext.getBean(\"beanFactoryService\", AccountService.class);\n        accountService.tranferMoney(3,6,100);\n    }\n}<\/code><\/pre>\n\n\n\n
\u5b8c\u6574\u7684\u76ee\u5f55\u4e3a\uff1a
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
11.\u5f00\u59cb\u6d4b\u8bd5
11.1\u9996\u5148\u5728\u6570\u636e\u5e93\u4e2d\u63d2\u5165\u4e24\u6761\u6570\u636e\uff1a
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
11.1\u9996\u5148\u6d4b\u6ca1\u6709\u8fdb\u884c\u4e8b\u52a1\u7ba1\u7406\u7684 testTran1()\u6d4b\u8bd5\u8f6c\u8d26\u8fd0\u884c\u6b63\u786e\u7684\u60c5\u51b5\uff1a
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p >\n
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/<\/figure >\n