【Spring实现模拟银行转账】

àì夳堔傛蜴生んèń 2024-03-31 14:30 41阅读 0赞

## 数据库建表和插入数据 ##

1、数据库建表

![904d78f300d442ff94e031c5b1e6ad97.png][]

2、插入数据

![0a8cdb8ea8164b638aa7c81608285cfd.png][]

## 项目目录 ##

![63ca5b0cb1664399b3376ea8ca6d8e30.png][]

## 代码部分 ##

1、IAccountDao.java

package com.qingruan.dao;
    
    public interface IAccountDao {
        public void addMoney(String name,double money);
        public void subMoney(String name,double money);
    
    }

2、AccountDaoImpl.java

>     package com.qingruan.dao.impl;
>     
>     import com.qingruan.dao.IAccountDao;
>     import org.springframework.beans.factory.annotation.Autowired;
>     import org.springframework.jdbc.core.JdbcTemplate;
>     import org.springframework.stereotype.Repository;
>     
>     @Repository
>     public class AccountDaoImpl implements IAccountDao {
>     
>         @Autowired
>         private JdbcTemplate jdbcTemplate;
>     
>         @Override
>         public void addMoney(String name, double money) {
>             String sql="update account set money = money + ? where name = ?";
>             jdbcTemplate.update(sql,money,name);
>         }
>     
>         @Override
>         public void subMoney(String name, double money) {
>             String sql="update account set money = money - ? where name = ?";
>             jdbcTemplate.update(sql,money,name);
>         }
>     }

3、IAccountService.java

>     package com.qingruan.service;
>     
>     
>     public interface IAccountService {
>         public void transfer(String form,String target,double money);
>     }

4、AccountServiceImpl.java

>     package com.qingruan.service.impl;
>     
>     import com.qingruan.dao.IAccountDao;
>     import com.qingruan.service.IAccountService;
>     import org.springframework.beans.factory.annotation.Autowired;
>     import org.springframework.stereotype.Service;
>     
>     @Service
>     public class AccountServiceImpl implements IAccountService {
>         @Autowired
>         private IAccountDao accountDao;
>     
>         @Override
>         public void transfer(String form, String target, double money) {
>             accountDao.subMoney(form,money);
>             //System.out.println(1/0);
>             accountDao.addMoney(target,money);
>         }
>     }

5、TestApp.java

>     package com.qingruan.test;
>     
>     import com.qingruan.service.IAccountService;
>     import com.qingruan.service.impl.AccountServiceImpl;
>     import org.junit.Test;
>     import org.springframework.context.ApplicationContext;
>     import org.springframework.context.support.ClassPathXmlApplicationContext;
>     
>     public class TestApp {
>     
>         @Test
>         public void test(){
>             ApplicationContext app = new ClassPathXmlApplicationContext("applicationContext.xml");
>             AccountServiceImpl service = (AccountServiceImpl)app.getBean(IAccountService.class);
>             service.transfer("李四","张三",500);
>         }
>     }

## 配置文件 ##

[904d78f300d442ff94e031c5b1e6ad97.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/99847ed6312445ec8ce19863f8adecba.png
[0a8cdb8ea8164b638aa7c81608285cfd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/6b9320209b024142863024c78bfb84c4.png
[63ca5b0cb1664399b3376ea8ca6d8e30.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/4b348d8a33cd4452bdcbebc800e8c0c1.png