{"id":254,"date":"2020-08-13T15:03:06","date_gmt":"2020-08-13T07:03:06","guid":{"rendered":"http:\/\/moyisuiying.com\/?p=254"},"modified":"2020-12-10T14:24:25","modified_gmt":"2020-12-10T06:24:25","slug":"%e8%af%a6%e8%a7%a3ssm%e7%8e%af%e5%a2%83%e7%9a%84%e6%90%ad%e5%bb%ba%ef%bc%88%e4%b8%8b%ef%bc%89","status":"publish","type":"post","link":"http:\/\/moyisuiying.com\/index.php\/javastudy\/254.html","title":{"rendered":"\u8be6\u89e3SSM\u73af\u5883\u7684\u642d\u5efa\uff08\u4e0b\uff09"},"content":{"rendered":"\n<p>\u5728\u4e0a\u4e00\u7bc7\u535a\u5ba2\u4e2d<a href=\"http:\/\/moyisuiying.com\/index.php\/javastudy\/249.html\">\u8be6\u89e3SSM\u73af\u5883\u7684\u642d\u5efa\uff08\u4e0a\uff09<\/a>\uff0c\u6211\u4e5f\u7ecf\u642d\u5efa\u597d\u4e86\u662fSSM\u7684\u57fa\u672c\u6846\u67b6\uff0c\u5e76\u8fdb\u884c\u4e86\u7b80\u5355\u7684\u6d4b\u8bd5\u3002\u4f46\u662f\u5e76\u6ca1\u6709\u7ed9MySQL\u6dfb\u52a0\u4e8b\u52a1\u7ba1\u7406\u4ee5\u53ca\u5e76\u6ca1\u6709\u6d4b\u8bd5\u6570\u636e\u5e93\u7684\u589e\u5220\u67e5\u6539\u529f\u80fd\u3002\u63a5\u4e0b\u6765\u4fbf\u7ee7\u7eed\u8be6\u7ec6\u8fdb\u884c\u5404\u4e2a\u529f\u80fd\u7684\u6d4b\u8bd5\u3002<br>1.\u6dfb\u52a0\u65b0\u7684\u4f9d\u8d56<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code> &lt;!-- \u5f15\u5165aop\u4f9d\u8d56 -->\n      &lt;dependency>\n          &lt;groupId>org.aspectj&lt;\/groupId>\n          &lt;artifactId>aspectjweaver&lt;\/artifactId>\n          &lt;version>1.9.6&lt;\/version>\n      &lt;\/dependency>\n      &lt;!-- \u5f15\u5165Spring\u89e3\u6790JSon\u6570\u636e\u7684\u4f9d\u8d56 -->\n      &lt;dependency>\n          &lt;groupId>com.fasterxml.jackson.core&lt;\/groupId>\n          &lt;artifactId>jackson-databind&lt;\/artifactId>\n          &lt;version>2.11.2&lt;\/version>\n      &lt;\/dependency>\n      &lt;dependency>\n          &lt;groupId>com.fasterxml.jackson.core&lt;\/groupId>\n          &lt;artifactId>jackson-core&lt;\/artifactId>\n          &lt;version>2.11.2&lt;\/version>\n      &lt;\/dependency>\n      &lt;!-- \u5c06\u53c2\u6570map\u7684\u53c2\u6570\u503c\u6ce8\u5165JavaBean\u4e2d -->\n      &lt;dependency>\n          &lt;groupId>commons-beanutils&lt;\/groupId>\n          &lt;artifactId>commons-beanutils&lt;\/artifactId>\n          &lt;version>1.9.4&lt;\/version>\n      &lt;\/dependency><\/code><\/pre>\n\n\n\n<p>\u5b8c\u6574\u7684pom.xml\u6587\u4ef6\u4e3a\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?xml version=\"1.0\" encoding=\"UTF-8\"?>\n\n&lt;project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" 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  &lt;modelVersion>4.0.0&lt;\/modelVersion>\n\n  &lt;groupId>org.example&lt;\/groupId>\n  &lt;artifactId>ssmdemo3&lt;\/artifactId>\n  &lt;version>1.0-SNAPSHOT&lt;\/version>\n  &lt;packaging>war&lt;\/packaging>\n\n  &lt;name>ssmdemo3 Maven Webapp&lt;\/name>\n  &lt;!-- FIXME change it to the project's website -->\n  &lt;url>http:\/\/www.example.com&lt;\/url>\n\n  &lt;properties>\n&lt;!--    \u9879\u76ee\u7f16\u7801-->\n    &lt;project.build.sourceEncoding>UTF-8&lt;\/project.build.sourceEncoding>\n    &lt;maven.compiler.source>1.8&lt;\/maven.compiler.source>\n    &lt;maven.compiler.target>1.8&lt;\/maven.compiler.target>\n&lt;!--    \u7528\u6237\u7248\u672c\u9501\u5b9a\uff0c\u65b9\u4fbf\u4fee\u6539\u7248\u672c-->\n    &lt;spring.version>5.2.8.RELEASE&lt;\/spring.version>\n  &lt;\/properties>\n\n  &lt;dependencies>\n&lt;!--    \u5f15\u5165JUnit\u6d4b\u8bd5\u4f9d\u8d56-->\n    &lt;dependency>\n      &lt;groupId>org.junit.jupiter&lt;\/groupId>\n      &lt;artifactId>junit-jupiter-api&lt;\/artifactId>\n      &lt;version>5.7.0-M1&lt;\/version>\n      &lt;scope>test&lt;\/scope>\n    &lt;\/dependency>\n&lt;!--    \u5f15\u5165Spring\u7684\u4f9d\u8d56-->\n    &lt;dependency>\n      &lt;groupId>org.springframework&lt;\/groupId>\n      &lt;artifactId>spring-context&lt;\/artifactId>\n      &lt;version>${spring.version}&lt;\/version>\n    &lt;\/dependency>\n    &lt;dependency>\n      &lt;groupId>org.springframework&lt;\/groupId>\n      &lt;artifactId>spring-web&lt;\/artifactId>\n      &lt;version>${spring.version}&lt;\/version>\n    &lt;\/dependency>\n    &lt;dependency>\n      &lt;groupId>org.springframework&lt;\/groupId>\n      &lt;artifactId>spring-tx&lt;\/artifactId>\n      &lt;version>${spring.version}&lt;\/version>\n    &lt;\/dependency>\n    &lt;dependency>\n      &lt;groupId>org.springframework&lt;\/groupId>\n      &lt;artifactId>spring-webmvc&lt;\/artifactId>\n      &lt;version>${spring.version}&lt;\/version>\n    &lt;\/dependency>\n    &lt;dependency>\n      &lt;groupId>org.springframework&lt;\/groupId>\n      &lt;artifactId>spring-tx&lt;\/artifactId>\n      &lt;version>5.2.8.RELEASE&lt;\/version>\n    &lt;\/dependency>\n\n    &lt;!-- \u5f15\u5165Spring-jdbc\u4f9d\u8d56\u5305 -->\n    &lt;dependency>\n      &lt;groupId>org.springframework&lt;\/groupId>\n      &lt;artifactId>spring-jdbc&lt;\/artifactId>\n      &lt;version>${spring.version}&lt;\/version>\n    &lt;\/dependency>\n&lt;!--\u5f15\u5165servlet\u7684\u4f9d\u8d56\u5305-->\n    &lt;dependency>\n      &lt;groupId>javax.servlet&lt;\/groupId>\n      &lt;artifactId>servlet-api&lt;\/artifactId>\n      &lt;version>2.5&lt;\/version>\n      &lt;scope>provided&lt;\/scope>\n    &lt;\/dependency>\n&lt;!--\u5f15\u5165jsp\u4f9d\u8d56\u5305-->\n    &lt;dependency>\n      &lt;groupId>javax.servlet.jsp&lt;\/groupId>\n      &lt;artifactId>jsp-api&lt;\/artifactId>\n      &lt;version>2.0&lt;\/version>\n      &lt;scope>provided&lt;\/scope>\n    &lt;\/dependency>\n    &lt;!-- \u5f15\u5165mybatis\u4f9d\u8d56 -->\n    &lt;dependency>\n      &lt;groupId>org.mybatis&lt;\/groupId>\n      &lt;artifactId>mybatis&lt;\/artifactId>\n      &lt;version>3.5.5&lt;\/version>\n    &lt;\/dependency>\n    &lt;!-- \u5f15\u5165mybatis\u7684Spring\u4f9d\u8d56 -->\n    &lt;dependency>\n      &lt;groupId>org.mybatis&lt;\/groupId>\n      &lt;artifactId>mybatis-spring&lt;\/artifactId>\n      &lt;version>2.0.5&lt;\/version>\n    &lt;\/dependency>\n    &lt;!-- \u5f15\u5165MySQL\u4f9d\u8d56 -->\n    &lt;dependency>\n      &lt;groupId>mysql&lt;\/groupId>\n      &lt;artifactId>mysql-connector-java&lt;\/artifactId>\n      &lt;version>8.0.21&lt;\/version>\n    &lt;\/dependency>\n    &lt;!-- \u5f15\u5165c3p0\u8fde\u63a5\u6c60 -->\n    &lt;dependency>\n      &lt;groupId>com.mchange&lt;\/groupId>\n      &lt;artifactId>c3p0&lt;\/artifactId>\n      &lt;version>0.9.5.5&lt;\/version>\n    &lt;\/dependency>\n    &lt;!-- \u5f15\u5165jstl\u8868\u8fbe\u5f0f\u7684\u4f9d\u8d56\u5305 -->\n    &lt;dependency>\n      &lt;groupId>javax.servlet.jsp.jstl&lt;\/groupId>\n      &lt;artifactId>jstl&lt;\/artifactId>\n      &lt;version>1.2&lt;\/version>\n    &lt;\/dependency>\n      &lt;!-- \u5f15\u5165aop\u4f9d\u8d56 -->\n      &lt;dependency>\n          &lt;groupId>org.aspectj&lt;\/groupId>\n          &lt;artifactId>aspectjweaver&lt;\/artifactId>\n          &lt;version>1.9.6&lt;\/version>\n      &lt;\/dependency>\n      &lt;!-- \u5f15\u5165Spring\u89e3\u6790JSon\u6570\u636e\u7684\u4f9d\u8d56 -->\n      &lt;dependency>\n          &lt;groupId>com.fasterxml.jackson.core&lt;\/groupId>\n          &lt;artifactId>jackson-databind&lt;\/artifactId>\n          &lt;version>2.11.2&lt;\/version>\n      &lt;\/dependency>\n      &lt;dependency>\n          &lt;groupId>com.fasterxml.jackson.core&lt;\/groupId>\n          &lt;artifactId>jackson-core&lt;\/artifactId>\n          &lt;version>2.11.2&lt;\/version>\n      &lt;\/dependency>\n      &lt;!-- \u5c06\u53c2\u6570map\u7684\u53c2\u6570\u503c\u6ce8\u5165JavaBean\u4e2d -->\n      &lt;dependency>\n          &lt;groupId>commons-beanutils&lt;\/groupId>\n          &lt;artifactId>commons-beanutils&lt;\/artifactId>\n          &lt;version>1.9.4&lt;\/version>\n      &lt;\/dependency>\n\n  &lt;\/dependencies>\n\n  &lt;build>\n    &lt;finalName>ssmdemo3&lt;\/finalName>\n    &lt;pluginManagement>&lt;!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->\n      &lt;plugins>\n        &lt;plugin>\n          &lt;artifactId>maven-clean-plugin&lt;\/artifactId>\n          &lt;version>3.1.0&lt;\/version>\n        &lt;\/plugin>\n        &lt;!-- see http:\/\/maven.apache.org\/ref\/current\/maven-core\/default-bindings.html#Plugin_bindings_for_war_packaging -->\n        &lt;plugin>\n          &lt;artifactId>maven-resources-plugin&lt;\/artifactId>\n          &lt;version>3.0.2&lt;\/version>\n        &lt;\/plugin>\n        &lt;plugin>\n          &lt;artifactId>maven-compiler-plugin&lt;\/artifactId>\n          &lt;version>3.8.0&lt;\/version>\n        &lt;\/plugin>\n        &lt;plugin>\n          &lt;artifactId>maven-surefire-plugin&lt;\/artifactId>\n          &lt;version>2.22.1&lt;\/version>\n        &lt;\/plugin>\n        &lt;plugin>\n          &lt;artifactId>maven-war-plugin&lt;\/artifactId>\n          &lt;version>3.2.2&lt;\/version>\n        &lt;\/plugin>\n        &lt;plugin>\n          &lt;artifactId>maven-install-plugin&lt;\/artifactId>\n          &lt;version>2.5.2&lt;\/version>\n        &lt;\/plugin>\n        &lt;plugin>\n          &lt;artifactId>maven-deploy-plugin&lt;\/artifactId>\n          &lt;version>2.8.2&lt;\/version>\n        &lt;\/plugin>\n      &lt;\/plugins>\n    &lt;\/pluginManagement>\n  &lt;\/build>\n&lt;\/project><\/code><\/pre>\n\n\n\n<p>2.\u66f4\u65b0AccountDao.java\u7684\u4ee3\u7801\uff0c\u6dfb\u52a0mybatis\u7684\u6ce8\u89e3<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>package dao;\n\nimport entity.Account;\nimport org.apache.ibatis.annotations.Delete;\nimport org.apache.ibatis.annotations.Insert;\nimport org.apache.ibatis.annotations.Select;\nimport org.apache.ibatis.annotations.Update;\nimport org.springframework.stereotype.Repository;\n\nimport java.util.List;\n\n\/**\n * Classname:AccountDao\n * @description:\u7528\u4e8e\u8bbf\u95ee\u6570\u636e\u5e93,\u5b9e\u73b0\u5bf9\u6570\u636e\u5e93\u7684\u589e\u5220\u9664\u6539\u64cd\u4f5c\n * @author: \u964c\u610f\u968f\u5f71\n * @Date: 2020-08-12 19:55\n * @Version: 1.0\n **\/\n@Repository(\"accountDao\")\npublic interface AccountDao {\n    \/**\n     * @Description :\u5411\u6570\u636e\u5e93\u4e2d\u5b58\u5165\u65b0\u7684\u7528\u6237,\u5e76\u8fd4\u56de\u662f\u5426\u5b58\u50a8\u6210\u529f\n     * @Date 19:56 2020\/8\/12 0012\n     * @Param * @param account \uff1a\u8981\u4fdd\u5b58\u7684\u7528\u6237\n     * @return boolean\n     **\/\n    @Insert(\"insert into account(name,password,age,createTime,money) values(#{name},#{password},#{age},#{createTime},#{money})\")\n     public  int saveAccount(Account account);\n     \/**\n      * @Description :\u66f4\u65b0\u7528\u6237\n      * @Date 19:58 2020\/8\/12 0012\n      * @Param * @param account \uff1a\n      * @return boolean\n      **\/\n     @Update(\"update account set name=#{name},password=#{password},age=#{age},createTime=#{createTime},money=#{money} where id=#{id}\")\n     public int updateAccount(Account account);\n     \/**\n      * @Description :\u901a\u8fc7ID\u5220\u9664\u7528\u6237\n      * @Date 19:59 2020\/8\/12 0012\n      * @Param * @param id \uff1a\n      * @return boolean\n      **\/\n     @Delete(\"delete from account where id=#{id}\")\n     public  int deleteAccount(int id);\n     \/**\n      * @Description :\u901a\u8fc7\u7528\u6237id\u67e5\u627e\u7528\u6237\n      * @Date 19:59 2020\/8\/12 0012\n      * @Param * @param id \uff1a\n      * @return entity.Account\n      **\/\n     @Select(\"select* from account where id=#{id}\")\n     public Account findAccount(int id);\n     \/**\n      * @Description :\u67e5\u627e\u6240\u6709\u7684\u7528\u6237\n      * @Date 20:00 2020\/8\/12 0012\n      * @Param * @param  \uff1a\n      * @return java.util.List&lt;entity.Account>\n      **\/\n     @Select(\"select* from account\")\n     public List&lt;Account> findAllAccount();\n}<\/code><\/pre>\n\n\n\n<p>3.\u5728AccountService.java\u4e2d\u6dfb\u52a0\u8f6c\u8d26\u65b9\u6cd5\u7528\u4e8e\u6a21\u62df\u4e8b\u52a1\u662f\u5426\u6b63\u786e\u6267\u884c\uff0c\u540c\u65f6\u5728AccountServiceImpl.java\u4e2d\u5b9e\u73b0\u8be5\u63a5\u53e3\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>package service;\n\nimport entity.Account;\n\nimport java.util.List;\n\n\/**\n * Classname:ssmdemo3\n * @description: \u7528\u6237\u4e1a\u52a1\u903b\u8f91\u63a5\u53e3\n * @author: \u964c\u610f\u968f\u5f71\n * @Date: 2020-08-12 19:55\n *\/\npublic interface AccountService {\n    \/**\n     * @Description :\u5411\u6570\u636e\u5e93\u4e2d\u5b58\u5165\u65b0\u7684\u7528\u6237,\u5e76\u8fd4\u56de\u662f\u5426\u5b58\u50a8\u6210\u529f\n     * @Date 19:56 2020\/8\/12 0012\n     * @Param * @param account \uff1a\u8981\u4fdd\u5b58\u7684\u7528\u6237\n     * @return boolean\n     **\/\n    public  boolean saveAccount(Account account);\n    \/**\n     * @Description :\u66f4\u65b0\u7528\u6237\n     * @Date 19:58 2020\/8\/12 0012\n     * @Param * @param account \uff1a\n     * @return boolean\n     **\/\n    public boolean updateAccount(Account account);\n    \/**\n     * @Description :\u901a\u8fc7ID\u5220\u9664\u7528\u6237\n     * @Date 19:59 2020\/8\/12 0012\n     * @Param * @param id \uff1a\n     * @return boolean\n     **\/\n    public  boolean deleteAccount(int id);\n    \/**\n     * @Description :\u901a\u8fc7\u7528\u6237id\u67e5\u627e\u7528\u6237\n     * @Date 19:59 2020\/8\/12 0012\n     * @Param * @param id \uff1a\n     * @return entity.Account\n     **\/\n    public Account findAccount(int id);\n    \/**\n     * @Description :\u67e5\u627e\u6240\u6709\u7684\u7528\u6237\n     * @Date 20:00 2020\/8\/12 0012\n     * @Param * @param  \uff1a\n     * @return java.util.List&lt;entity.Account>\n     **\/\n    public List&lt;Account> findAllAccount();\n    \/**\n     * @Description :ID\u4e3asourceId\u7684\u7528\u6237\u8f6c\u8d26money\u5230\u7528\u6237ID\u4e3atargetId\u7684\u7528\u6237\n     * @Date 22:51 2020\/8\/12 0012\n     * @Param * @param sourceId\n     * @param targetId\n     * @param money \uff1a\n     * @return boolean\n     **\/\n    public boolean transMoney(int sourceId,int targetId,int money);\n}<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>package service.impl;\n\nimport dao.AccountDao;\nimport entity.Account;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.stereotype.Service;\nimport service.AccountService;\n\nimport java.util.List;\n\n\/**\n * Classname:AccountServiceImpl\n *\n * @description:\n * @author: \u964c\u610f\u968f\u5f71\n * @Date: 2020-08-12 20:11\n * @Version: 1.0\n **\/\n@Service(\"accountService\")\npublic class AccountServiceImpl implements AccountService {\n    \/\/\u81ea\u52a8\u6ce8\u5165dao\n    @Autowired\n    AccountDao accountDao;\n    @Override\n    public boolean saveAccount(Account account) {\n        return  accountDao.saveAccount(account)==1;\n    }\n\n    @Override\n    public boolean updateAccount(Account account) {\n        return accountDao.updateAccount(account)==1;\n    }\n\n    @Override\n    public boolean deleteAccount(int id) {\n        return accountDao.deleteAccount(id)==1;\n    }\n\n    @Override\n    public Account findAccount(int id) {\n        return accountDao.findAccount(id);\n    }\n\n    @Override\n    public List&lt;Account> findAllAccount() {\n        return accountDao.findAllAccount();\n    }\n\n    @Override\n    public boolean transMoney(int sourceId, int targetId, int money) {\n\/\/        \u83b7\u53d6\u5bf9\u5e94\u7684\u7528\u6237\n        Account sourceIdAccount = accountDao.findAccount(sourceId);\n        Account targetAccount = accountDao.findAccount(targetId);\n        if (sourceIdAccount== null ||targetAccount == null){\n            return false;\n        }\n\/\/        \u66f4\u65b0\u8d26\u6237\u4f59\u989d\n       sourceIdAccount.setMoney(sourceIdAccount.getMoney()-money);\n        targetAccount.setMoney(targetAccount.getMoney()+money);\n        boolean  fla1 = this.updateAccount(sourceIdAccount);\n       \/\/\u6a21\u62df\u8f6c\u8d26\u51fa\u9519\u8bef\n        int i = 9\/0;\n        boolean fla2 = this.updateAccount(targetAccount);\n        return fla1==true&amp;&amp;fla2==true;\n    }\n}<\/code><\/pre>\n\n\n\n<p>4.\u5728index.jsp\u4e2d\u6dfb\u52a0\u6dfb\u52a0\u4ee3\u7801<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;%--\n  Created by IntelliJ IDEA.\n  User: \u964c\u610f\u968f\u5f71\n  Date: 2020\/8\/5 0005\n  Time: 23:17\n  To change this template use File | Settings | File Templates.\n--%>\n&lt;%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\"  isELIgnored=\"false\" %>\n&lt;html>\n&lt;head>\n &lt;title>\u6d4b\u8bd5\u9996\u9875&lt;\/title>\n&lt;\/head>\n&lt;body>\n&lt;h3>\u9996\u9875&lt;\/h3>\n&lt;a href=\"account\/saveAccount?name=aaa&amp;password=aaa&amp;age=18&amp;money=240\">\u4fdd\u5b58\u7528\u6237&lt;\/a>&lt;br>\n&lt;a href=\"account\/updateAccount?id=25&amp;name=bbb&amp;password=bbb&amp;age=23&amp;money=640\">\u66f4\u65b0\u7528\u6237&lt;\/a>&lt;br>\n&lt;a href=\"account\/deleteAccount?id=25\">\u5220\u9664\u7528\u6237&lt;\/a>&lt;br>\n&lt;a href=\"account\/findOne?id=25\">\u67e5\u627e\u7528\u6237&lt;\/a>&lt;br>\n&lt;a href=\"account\/findAllAccount\">\u67e5\u627e\u6240\u6709\u7528\u6237&lt;\/a>&lt;br>\n&lt;a href=\"account\/transMoney?sourceId=23&amp;targetId=25&amp;money=100\">\u8f6c\u8d26&lt;\/a>&lt;br>\n&lt;\/body>\n&lt;\/html><\/code><\/pre>\n\n\n\n<p>\u8fdb\u884c\u6d4b\u8bd5\u5404\u79cd\u65b9\u6cd5\u3002<br>\u5728pages\u6587\u4ef6\u5939\u4e2d\u6dfb\u52a0AccountList.jsp\u7528\u4e8e\u5c55\u793a\u67e5\u8be2\u7684\u7528\u6237<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;%--\n  Created by IntelliJ IDEA.\n  User: \u964c\u610f\u968f\u5f71\n  Date: 2020\/8\/12 0012\n  Time: 23:25\n  To change this template use File | Settings | File Templates.\n--%>\n&lt;%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" isELIgnored=\"false\" %>\n&lt;%@taglib uri=\"http:\/\/java.sun.com\/jsp\/jstl\/core\" prefix=\"c\"%>\n&lt;html>\n&lt;head>\n    &lt;title>\u67e5\u8be2\u7528\u6237\u9875\u9762&lt;\/title>\n&lt;\/head>\n&lt;body>\n &lt;c:if test=\"${ not empty accountList}\" >\n        &lt;c:forEach items=\"${accountList}\" var=\"account\" >\n            &lt;tr>\n                &lt;td>${account.id}&lt;\/td>\n                &lt;td>${account.name}&lt;\/td>\n                &lt;td>${account.password}&lt;\/td>\n                &lt;td>${account.age}&lt;\/td>\n                &lt;td>${account.money}&lt;\/td>\n                &lt;td>${account.createTime}&lt;\/td>\n            &lt;\/tr>\n            &lt;br>\n        &lt;\/c:forEach>\n &lt;\/c:if>\n &lt;c:if test=\"${not empty account}\">\n     &lt;tr>\n         &lt;td>${account.id}&lt;\/td>\n         &lt;td>${account.name}&lt;\/td>\n         &lt;td>${account.password}&lt;\/td>\n         &lt;td>${account.age}&lt;\/td>\n         &lt;td>${account.money}&lt;\/td>\n         &lt;td>${account.createTime}&lt;\/td>\n     &lt;\/tr>\n &lt;\/c:if>\n\n&lt;\/body>\n&lt;\/html><\/code><\/pre>\n\n\n\n<p>5.\u66f4\u65b0controller\u4e2d\u7684AccountController.java\u4e2d\u7684\u65b9\u6cd5<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>package controller;\n\nimport entity.Account;\nimport org.apache.commons.beanutils.BeanUtilsBean;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.stereotype.Controller;\nimport org.springframework.web.bind.annotation.RequestMapping;\nimport org.springframework.web.bind.annotation.RequestParam;\nimport org.springframework.web.servlet.ModelAndView;\nimport service.AccountService;\nimport javax.servlet.http.HttpServletRequest;\nimport java.util.List;\nimport java.util.Map;\n\n\/**\n * Classname:AccountController\n * @description:\u63a7\u5236\u5668\n * @author: \u964c\u610f\u968f\u5f71\n * @Date: 2020-08-12 20:02\n * @Version: 1.0\n **\/\n@Controller\n@RequestMapping(\"\/account\")\npublic class AccountController {\n    @Autowired\n  private AccountService accountService;\n    @RequestMapping(\"\/testSSM\")\n    public String testSSM(){\n        \/\/\u8c03\u7528\u6d4b\u8bd5\u65b9\u6cd5\n        accountService.findAllAccount();\n        System.out.println(\"\u6846\u67b6\u642d\u5efa\u6210\u529f\uff01\");\n        return \"sucess\";\n    }\n    @RequestMapping(value = \"\/saveAccount\")\n    public ModelAndView saveAccount(HttpServletRequest httpServletRequest){\n        Account account = new Account();\n        Map parameterMap = httpServletRequest.getParameterMap();\n        BeanUtilsBean beanUtilsBean = new BeanUtilsBean();\n        try {\n            beanUtilsBean.populate(account,parameterMap);\n            boolean fla = accountService.saveAccount(account);\n            System.out.println(\"\u4fdd\u5b58\u6210\u529f\uff1a\"+fla);\n            ModelAndView modelAndView=new ModelAndView();\n            modelAndView.setViewName(\"sucess\");\n            if (fla){\n                modelAndView.addObject(\"msg\",\"\u4fdd\u5b58\u7528\u6237\u6210\u529f\uff01\");\n            }else{\n                modelAndView.addObject(\"msg\",\"\u4fdd\u5b58\u7528\u6237\u5931\u8d25\uff01\");\n            }\n            return modelAndView;\n        } catch (Exception e) {\n            e.printStackTrace();\n            throw  new RuntimeException(\"\u53c2\u6570\u9519\u8bef\u3002\u3002\");\n        }\n\n\n    }\n    @RequestMapping(\"\/updateAccount\")\n    public ModelAndView updateAccount(HttpServletRequest httpServletRequest){\n        Account account = new Account();\n        Map parameterMap = httpServletRequest.getParameterMap();\n        BeanUtilsBean beanUtilsBean = new BeanUtilsBean();\n        try {\n            beanUtilsBean.populate(account,parameterMap);\n            System.out.println(account);\n            boolean fla = accountService.updateAccount(account);\n            System.out.println(\"\u66f4\u65b0\u6210\u529f\uff1a\"+fla);\n            ModelAndView modelAndView=new ModelAndView();\n            modelAndView.setViewName(\"sucess\");\n            if (fla){\n                modelAndView.addObject(\"msg\",\"\u66f4\u65b0\u7528\u6237\u6210\u529f\uff01\");\n            }else{\n                modelAndView.addObject(\"msg\",\"\u66f4\u65b0\u7528\u6237\u5931\u8d25\uff01\");\n            }\n            return modelAndView;\n        } catch (Exception e) {\n            e.printStackTrace();\n            throw  new RuntimeException(\"\u53c2\u6570\u9519\u8bef\u3002\u3002\");\n        }\n    }\n    @RequestMapping(\"\/deleteAccount\")\n    public ModelAndView deleteAccount(@RequestParam int id){\n        boolean fla = accountService.deleteAccount(id);\n        System.out.println(\"\u5220\u9664\u6210\u529f\uff1a\"+fla);\n        ModelAndView modelAndView=new ModelAndView();\n        modelAndView.setViewName(\"sucess\");\n        if (fla){\n            modelAndView.addObject(\"msg\",\"\u5220\u9664\u7528\u6237\u6210\u529f\uff01\");\n        }else{\n            modelAndView.addObject(\"msg\",\"\u5220\u9664\u7528\u6237\u5931\u8d25\uff01\");\n        }\n        return modelAndView;\n    }\n    @RequestMapping(\"\/findOne\")\n    public  ModelAndView findOne(@RequestParam int id){\n        Account account = accountService.findAccount(id);\n        System.out.println(account);\n        ModelAndView modelAndView=new ModelAndView();\n        modelAndView.setViewName(\"accountList\");\n        modelAndView.addObject(\"account\",account);\n        return modelAndView;\n    }\n    @RequestMapping(\"\/findAllAccount\")\n    public  ModelAndView findAllAccount(){\n        List&lt;Account> accountList = accountService.findAllAccount();\n        System.out.println(accountList);\n        ModelAndView modelAndView=new ModelAndView();\n        modelAndView.setViewName(\"accountList\");\n        modelAndView.addObject(\"accountList\",accountList);\n        return modelAndView;\n    }\n    @RequestMapping(\"\/transMoney\")\n    public ModelAndView transMoney(@RequestParam int sourceId,@RequestParam int targetId,@RequestParam int money){\n        boolean fla = accountService.transMoney(sourceId,targetId,money);\n        System.out.println(\"\u8f6c\u8d26\u6210\u529f\uff1a\"+fla);\n        ModelAndView modelAndView=new ModelAndView();\n        modelAndView.setViewName(\"sucess\");\n        if (fla){\n            modelAndView.addObject(\"msg\",\"\u8f6c\u8d26\u6210\u529f\uff01\");\n        }else{\n            modelAndView.addObject(\"msg\",\"\u8f6c\u8d26\u5931\u8d25\uff01\");\n        }\n        return modelAndView;\n    }\n}<\/code><\/pre>\n\n\n\n<p>6.\u5728applicationContexConfig.xml\u4e2d\u6dfb\u52a0\u5bf9\u4e8b\u52a1\u7684\u7ba1\u7406<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?xml version=\"1.0\" encoding=\"UTF-8\"?>\n&lt;beans xmlns=\"http:\/\/www.springframework.org\/schema\/beans\"\n       xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n       xmlns:p=\"http:\/\/www.springframework.org\/schema\/p\"\n       xmlns:context=\"http:\/\/www.springframework.org\/schema\/context\"\n       xmlns:tx=\"http:\/\/www.springframework.org\/schema\/tx\"\n       xmlns:aop=\"http:\/\/www.springframework.org\/schema\/aop\"\n       xsi:schemaLocation=\"\n        http:&#47;&#47;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        http:\/\/www.springframework.org\/schema\/context\n        http:\/\/www.springframework.org\/schema\/context\/spring-context.xsd\">\n&lt;!--    \u5f00\u542f\u6ce8\u89e3\u626b\u63cf-->\n  &lt;context:component-scan base-package=\"service\"\/>\n &lt;context:component-scan base-package=\"entity\"\/>\n&lt;!--\u5bfc\u5165db.properties-->\n    &lt;context:property-placeholder location=\"classpath:db.properties\">&lt;\/context:property-placeholder>\n&lt;!--    \u914d\u7f6e\u6570\u636e\u6e90-->\n    &lt;bean  id=\"dataSource\" class=\"com.mchange.v2.c3p0.ComboPooledDataSource\">\n        &lt;property name=\"driverClass\" value=\"${jdbc.driver}\">&lt;\/property>\n        &lt;property name=\"user\" value=\"${jdbc.username}\">&lt;\/property>\n        &lt;property name=\"password\" value=\"${jdbc.password}\">&lt;\/property>\n        &lt;property name=\"jdbcUrl\" value=\"${jdbc.url}\">&lt;\/property>\n    &lt;\/bean>\n&lt;!--    \u914d\u7f6eSqlSessionFactoryBean-->\n    &lt;bean id=\"sqlSessionFactory\" class=\"org.mybatis.spring.SqlSessionFactoryBean\">\n        &lt;property name=\"dataSource\" ref=\"dataSource\">&lt;\/property>\n    &lt;\/bean>\n&lt;!--    \u914d\u7f6edao\u63a5\u53e3\u6240\u5728\u7684\u4f4d\u7f6e,\u8fd9\u91cc\u91c7\u7528\u7684\u6ce8\u89e3\u914d\u7f6emybatis\u7684dao\u63a5\u53e3-->\n    &lt;bean class=\"org.mybatis.spring.mapper.MapperScannerConfigurer\" id=\"mapperScannerConfigurer\">\n        &lt;property name=\"basePackage\" value=\"dao\">&lt;\/property>\n    &lt;\/bean>\n&lt;!--    \u6dfb\u52a0\u4e8b\u52a1\u7ba1\u7406-->\n    &lt;bean  id=\"transactionManager\" class=\"org.springframework.jdbc.datasource.DataSourceTransactionManager\">\n        &lt;property name=\"dataSource\" ref=\"dataSource\">&lt;\/property>\n    &lt;\/bean>\n    &lt;!--    \u914d\u7f6e\u4e8b\u52a1\u901a\u77e5-->\n    &lt;tx:advice transaction-manager=\"transactionManager\" id=\"transactionInterceptor\">\n        &lt;!--     \u914d\u7f6e\u4e8b\u52a1\u7684\u5c5e\u6027   -->\n        &lt;tx:attributes>\n            &lt;tx:method name=\"saveAccount\" isolation=\"DEFAULT\" propagation=\"REQUIRED\" read-only=\"false\"\/>\n            &lt;tx:method name=\"updateAccount\" isolation=\"DEFAULT\" propagation=\"REQUIRED\" read-only=\"false\"\/>\n            &lt;tx:method name=\"deleteAccount\" isolation=\"DEFAULT\" propagation=\"REQUIRED\" read-only=\"false\"\/>\n            &lt;tx:method name=\"findAccount\" isolation=\"DEFAULT\" propagation=\"REQUIRED\" read-only=\"true\"\/>\n            &lt;tx:method name=\"findAllAccount\" isolation=\"DEFAULT\" propagation=\"REQUIRED\" read-only=\"true\"\/>\n        &lt;\/tx:attributes>\n    &lt;\/tx:advice>\n\n &lt;aop:config>\n\n&lt;!--     \u914d\u7f6e\u5207\u9762\u70b9\uff0c\u8fd9\u91cc\u8868\u793a\u5bf9AccountServiceImpl.java\u4e2d\u7684\u6bcf\u4e2a\u65b9\u6cd5\u90fd\u8d77\u4f5c\u7528-->\n     &lt;aop:pointcut id=\"pt\" expression=\"execution(* service.impl.AccountServiceImpl.*(..))\"\/>\n     &lt;aop:advisor advice-ref=\"transactionInterceptor\" pointcut-ref=\"pt\">&lt;\/aop:advisor>\n &lt;\/aop:config>\n&lt;\/beans><\/code><\/pre>\n\n\n\n<p>7.\u542f\u52a8Tomcat\u8fdb\u884c\u6d4b\u8bd5\u3002\u7ecf\u8fc7\u6d4b\u8bd5\u53d1\u73b0\u6bcf\u4e2a\u529f\u80fd\u90fd\u6b63\u786e\uff0c\u914d\u7f6e\u7684\u4e8b\u52a1\u7ba1\u7406\u4e5f\u6b63\u786e\u3002<br>\u672c\u9879\u76ee\u7684\u4ee3\u7801\u5df2\u7ecf\u4e0a\u4f20\u5230\u4e2a\u4eba\u535a\u5ba2\u670d\u52a1\u5668\uff0c\u82e5\u6709\u9700\u8981\u8bf7\u81ea\u884c\u4e0b\u8f7d\uff08\u89e3\u538b\u540e\u5bfc\u5165idea\u5373\u53ef\uff09\uff1a<a href=\"http:\/\/moyisuiying.com\/wp-content\/uploads\/2020\/08\/ssmdemo4.rar\">http:\/\/moyisuiying.com\/wp-content\/uploads\/2020\/08\/ssmdemo4.rar<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8be6\u89e3SSM\u73af\u5883\u7684\u642d\u5efa\uff08\u4e0b\uff09<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,29],"tags":[49,50,13,24,38],"_links":{"self":[{"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/posts\/254"}],"collection":[{"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/comments?post=254"}],"version-history":[{"count":1,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/posts\/254\/revisions"}],"predecessor-version":[{"id":256,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/posts\/254\/revisions\/256"}],"wp:attachment":[{"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/media?parent=254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/categories?post=254"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/tags?post=254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}