基于SSM的银行业务系统

基于SSM的银行业务系统

本项目采用Spring+SpringMVC+Mybatis框架实现了一个支持用户登录、转账、存款、取款的银行简易业务系统。

项目环境：

开发工具：InteliJ IDEA 2020.1.2
数据库：MySQL 8.0.30
服务器：Tomcat 8.5.15

项目目录结构

• ssmdemo
  • src
    • main
      • java
        • ssmdemo
          • controller
            • UserController
            • AccountController
          • dao
            • UserMapper
            • AccountMapper
          • pojo
            • Account
            • User
          • service
            • impl
              - AccountServiceImpl
              - UserServiceImpl
          • util
            • DBUtil
      • webapp
        • jsp
          • accountList.jsp
          • deposit.jsp
          • login.jsp
          • newAccount.jsp
          • transfer.jsp
          • withdrawMoney.jsp
          • styles.css

核心功能实现代码

1.登录功能实现

UserController

@Controller
public class UserController {
    @Autowired
    private UserService service;

    @RequestMapping("/s")
    public String login(String username,String password) {
        User user = service.login(username,password);
        if(user!=null){
            return "forward:/getAll";
        }
        return "/login";
    }
}

UserMapper

public interface UserMapper {

    @Select("select * from user where username=#{username} and password=#{password}")
    User login(@Param("username") String username,@Param("password")String password);
    @Select("select * from user where username=#{username}")
    User query(@Param("username") String username);

}

UserServiceImpl

@Override
    public User login(String username,String password) {
        try{
            SqlSession sqlSession = DBUtil.getSqlSession();
            UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
            return userMapper.login(username, password);
        }catch (Exception e){
            System.out.println(e);
            return null;
        }
    }

2.存取、转账功能

AccountController

@RequestMapping("/transfer")
    public String transfer(int fromId, int toId, int amount) throws IOException {
        accountService.transfer(fromId,toId,amount);
        return "forward:/getAll";
    }
    @RequestMapping("/withdrawMoney")
    public String withdrawMoney(Account account,Model model){
        model.addAttribute("Account",account);
        return "withdrawMoney";
    }
    @RequestMapping("/withdrawMoneyUp")
    public String withdrawMoneyUp(Account account){
        accountService.withdrawMoney(account);
        return "forward:/getAll";
    }
    @RequestMapping("/deposit")
    public String deposit(Account account,Model model){
        model.addAttribute("Account",account);
        return "deposit";
    }

AccountMapper

 @Update("update account set balance=#{balance} where id = #{id}")
    int withdrawMoney(Account account);

    @Insert("insert into account(name, balance) value(#{name},#{balance})")
    int deposit(Account account);

AccountServiceImpl

 @Override
    // 转账
    public void transfer(int from, int to, int amount) throws IOException {
        Account accountFrom = this.findById(from);
        Account accountTo = this.findById(to);

        if (accountFrom.getBalance() >= amount) {
            accountFrom.setBalance(accountFrom.getBalance()-amount);
            this.update(accountFrom);
            accountTo.setBalance(accountTo.getBalance()+amount);
            this.update(accountTo);
        }

    }

    @Override
    public int withdrawMoney(Account account) {
        try{
            SqlSession sqlSession = DBUtil.getSqlSession();
            AccountMapper accountMapper = sqlSession.getMapper(AccountMapper.class);
            Account byId = accountMapper.findById(account.getId());
            if(byId!=null){
                account.setBalance(byId.getBalance()-account.getBalance());
            }
            int i = accountMapper.withdrawMoney(account);
            sqlSession.commit();
            return i;
        }catch (Exception e){
            return 0;
        }
    }

    @Override
    public int deposit(Account account) {
        try{
            SqlSession sqlSession = DBUtil.getSqlSession();
            AccountMapper accountMapper = sqlSession.getMapper(AccountMapper.class);
            UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
            User query = userMapper.query(account.getName());
            if(query==null){
                return 0;
            }else{
                int i = accountMapper.deposit(account);
                sqlSession.commit();
                return i;
            }
        }catch (Exception e){
            return 0;
        }
    }