{"id":238,"date":"2020-08-10T22:35:04","date_gmt":"2020-08-10T14:35:04","guid":{"rendered":"http:\/\/moyisuiying.com\/?p=238"},"modified":"2020-12-10T14:24:00","modified_gmt":"2020-12-10T06:24:00","slug":"spring%e4%bd%bf%e7%94%a8%e7%ba%af%e6%b3%a8%e8%a7%a3%e9%85%8d%e7%bd%ae%e4%ba%8b%e5%8a%a1%e7%ae%a1%e7%90%86%e5%b9%b6%e5%ae%9e%e7%8e%b0%e7%ae%80%e5%8d%95%e7%9a%84%e5%a2%9e%e5%88%a0%e6%9f%a5%e6%94%b9","status":"publish","type":"post","link":"http:\/\/moyisuiying.com\/index.php\/javastudy\/238.html","title":{"rendered":"Spring\u4f7f\u7528\u7eaf\u6ce8\u89e3\u914d\u7f6e\u4e8b\u52a1\u7ba1\u7406\u5e76\u5b9e\u73b0\u7b80\u5355\u7684\u589e\u5220\u67e5\u6539\u4ee5\u53ca\u6a21\u62df\u8f6c\u8d26\u529f\u80fd"},"content":{"rendered":"\n

\u5728\u4e4b\u524d\u7684\u6587\u7ae0\uff0c\u7b14\u8005\u5df2\u7ecf\u4f7f\u7528XML\u914d\u7f6e\u5b9e\u73b0\u4e86\u5bf9MySQL\u7684\u4e8b\u52a1\u7ba1\u7406\u4f7f\u7528Spring\u7684\u4e8b\u52a1\u7ba1\u7406\u5668\u914d\u7f6e\u6570\u636e\u5e93\u7684\u4e8b\u52a1<\/a>\uff0cSpring\u4e5f\u652f\u6301\u4f7f\u7528\u6ce8\u89e3\u8fdb\u884c\u914d\u7f6e\u4ece\u800c\u5b9e\u73b0\u5bf9\u4e8b\u52a1\u7684\u7ba1\u7406\uff0c\u6b64\u6b21\u4fbf\u8be6\u7ec6\u8bf4\u660e\u5982\u4f55\u4f7f\u7528\u6ce8\u89e3\u914d\u7f6e\u5b9e\u73b0Spring\u4e8b\u52a1\u7684\u7ba1\u7406\u3002
1.\u9996\u5148\u5efa\u7acb\u5b9e\u9a8c\u6d4b\u8bd5\u73af\u5883
1.1\u521b\u5efa\u6570\u636e\u5e93\u4ee5\u53ca\u6570\u636e\u8868Account\u3002<\/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.2\u5728idea\u4e2d\u5efa\u7acbmaven\u5de5\u7a0b\u3002
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
1.3\u5728pom.xml\u4e2d\u5f15\u5165\u5fc5\u987b\u7684\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    <groupId>org.example<\/groupId>\n    <artifactId>springdemo_tx_annotaiton<\/artifactId>\n    <version>1.0-SNAPSHOT<\/version>\n    <properties>\n        <project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>\n        <maven.compiler.source>1.8<\/maven.compiler.source>\n        <maven.compiler.target>1.8<\/maven.compiler.target>\n        <spring.version>5.2.8.RELEASE<\/spring.version>\n    <\/properties>\n    <dependencies>\n<!--        \u5f15\u5165Spring\u4f9d\u8d56-->\n        <dependency>\n            <groupId>org.springframework<\/groupId>\n            <artifactId>spring-context<\/artifactId>\n            <version>${spring.version}<\/version>\n        <\/dependency>\n        <dependency>\n            <groupId>org.springframework<\/groupId>\n            <artifactId>spring-jdbc<\/artifactId>\n            <version>${spring.version}<\/version>\n        <\/dependency>\n        <dependency>\n            <groupId>org.springframework<\/groupId>\n            <artifactId>spring-tx<\/artifactId>\n            <version>${spring.version}<\/version>\n        <\/dependency>\n        <!-- \u5f15\u5165MySQL\u4f9d\u8d56 -->\n        <dependency>\n            <groupId>mysql<\/groupId>\n            <artifactId>mysql-connector-java<\/artifactId>\n            <version>8.0.21<\/version>\n        <\/dependency>\n        <!-- \u5f15\u5165c3p0\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\n    <\/dependencies>\n\n<\/project><\/code><\/pre>\n\n\n\n
1.4\u521b\u5efa\u6570\u636e\u5e93\u8fde\u63a5\u914d\u7f6e\u6587\u4ef6db.properties<\/p>\n\n\n\n
jdbc.url=jdbc:mysql:\/\/localhost:3306\/springdemo?serverTimezone=UTC\njdbc.name=root\njdbc.password=root\njdbc.driver=com.mysql.cj.jdbc.Driver<\/code><\/pre>\n\n\n\n
2.\u5f00\u59cb\u4e66\u5199dao,entity,service\u5305\u4e0b\u7684\u4ee3\u7801\u3002
2.1\u521b\u5efa\u5b9e\u4f53\u7c7b<\/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 **\/\n@Repository(\"account\")\n@Scope(\"prototype\")\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
2.2\u521b\u5efa\u7528\u548c\u8bbf\u95ee\u6570\u636e\u5e93\u7684\u6301\u4e45\u5c42\u63a5\u53e3\u4ee5\u53ca\u5176\u5b9e\u73b0\u7c7b<\/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.beans.factory.annotation.Autowired;\nimport org.springframework.jdbc.core.BeanPropertyRowMapper;\nimport org.springframework.jdbc.core.JdbcTemplate;\nimport org.springframework.stereotype.Repository;\n\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 **\/\n@Repository(\"accountDao\")\npublic class AccountDaoImpl implements AccountDao {\n    \/\/\u7528\u4e8e\u8fdb\u884cMySQL\u589e\u5220\u67e5\u6539,\u81ea\u52a8\u6ce8\u5165\n    @Autowired\n    JdbcTemplate jdbcTemplate = null;\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
\u7528\u4e8e\u8bbf\u95ee\u6570\u636e\u5e93\u7684JdbcTemplate\u9700\u8981\u81ea\u52a8\u6ce8\u5165\uff0c\u7b49\u4f1a\u518d\u5728\u914d\u7f6e\u7c7b\u4e2d\u914d\u7f6e\u8fd9\u4e2aJdbcTemplate\u7528\u4e8e\u6ce8\u5165\u3002
2.3\u4e66\u5199\u4e1a\u52a1\u903b\u8f91\u63a5\u53e3\u4ee5\u53ca\u5176\u5b9e\u73b0\u7c7b<\/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
java
package service;
import dao.AccountDao;
import entity.Account;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Isolation;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;<\/p>\n\n\n\n
import java.util.List;
\/**<\/p>\n\n\n\n