Mybatis实现银行转账业务增删改查-----Mybatis框架

偏执的太偏执、 2024-03-07 04:42 116阅读 0赞

>     package com.powernode.bank.web;
>     
>     import com.powernode.bank.service.AccountService;
>     import com.powernode.bank.service.impl.AccountServiceImpl;
>     
>     import javax.servlet.ServletException;
>     import javax.servlet.annotation.WebServlet;
>     import javax.servlet.http.HttpServlet;
>     import javax.servlet.http.HttpServletRequest;
>     import javax.servlet.http.HttpServletResponse;
>     import java.io.IOException;
>     
>     @WebServlet("/transfer")
>     public class AccountServlet extends HttpServlet
>     {
>         //为了让这个对象在其他方法中也可以使用,我们声明为实例变量
>         private AccountService accountService = new AccountServiceImpl();
>         @Override
>         protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException
>         {
>             super.doGet(req, resp);
>             this.doPost(req,resp);
>         }
>     
>         @Override
>         protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
>         {
>             //获取表单数据
>             String fromActno = request.getParameter("fromActno");
>             String toActno = request.getParameter("toActno");
>             Double money = Double.parseDouble(request.getParameter("money"));
>             //调用Service的转账方法完成转账(调业务层)
>             accountService.transfer(fromActno,toActno,money);
>             //调用视图层
>         }
>     }
> 
>     package com.powernode.bank.web;
>     
>     import com.powernode.bank.service.AccountService;
>     import com.powernode.bank.service.impl.AccountServiceImpl;
>     
>     import javax.servlet.ServletException;
>     import javax.servlet.annotation.WebServlet;
>     import javax.servlet.http.HttpServlet;
>     import javax.servlet.http.HttpServletRequest;
>     import javax.servlet.http.HttpServletResponse;
>     import java.io.IOException;
>     
>     @WebServlet("/transfer")
>     public class AccountServlet extends HttpServlet
>     {
>         //为了让这个对象在其他方法中也可以使用,我们声明为实例变量
>         private AccountService accountService = new AccountServiceImpl();
>         @Override
>         protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException
>         {
>             super.doGet(req, resp);
>             this.doPost(req,resp);
>         }
>     
>         @Override
>         protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
>         {
>             //获取表单数据
>             String fromActno = request.getParameter("fromActno");
>             String toActno = request.getParameter("toActno");
>             Double money = Double.parseDouble(request.getParameter("money"));
>             //调用Service的转账方法完成转账(调业务层)
>             accountService.transfer(fromActno,toActno,money);
>             //调用视图层
>         }
>     }

>     package com.powernode.bank.utils;
>     
>     import org.apache.ibatis.io.Resources;
>     import org.apache.ibatis.session.SqlSession;
>     import org.apache.ibatis.session.SqlSessionFactory;
>     import org.apache.ibatis.session.SqlSessionFactoryBuilder;
>     
>     import java.io.IOException;
>     
>     public class SqlSessionUtil
>     {
>         private SqlSessionUtil(){}
>         private static SqlSessionFactory sqlSessionFactory;
>         static
>         {
>             try
>             {
>                 sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader("Mybatis-config.xml"));
>             }
>             catch (IOException e)
>             {
>                 throw new RuntimeException(e);
>             }
>         }
>         public static SqlSession openSession()
>         {
>             return sqlSessionFactory.openSession();
>         }
>     }
> 
>     package com.powernode.bank.utils;
>     
>     import org.apache.ibatis.io.Resources;
>     import org.apache.ibatis.session.SqlSession;
>     import org.apache.ibatis.session.SqlSessionFactory;
>     import org.apache.ibatis.session.SqlSessionFactoryBuilder;
>     
>     import java.io.IOException;
>     
>     public class SqlSessionUtil
>     {
>         private SqlSessionUtil(){}
>         private static SqlSessionFactory sqlSessionFactory;
>         static
>         {
>             try
>             {
>                 sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader("Mybatis-config.xml"));
>             }
>             catch (IOException e)
>             {
>                 throw new RuntimeException(e);
>             }
>         }
>         public static SqlSession openSession()
>         {
>             return sqlSessionFactory.openSession();
>         }
>     }

>     package com.powernode.bank.service;
>     
>     public interface AccountService
>     {
>         //账户业务类
>         void transfer(String from,String to,double money);
>     }
> 
>     package com.powernode.bank.service;
>     
>     public interface AccountService
>     {
>         //账户业务类
>         void transfer(String from,String to,double money);
>     }

>     package com.powernode.bank.service.impl;
>     
>     import com.powernode.bank.service.AccountService;
>     
>     public class AccountServiceImpl implements AccountService
>     {
>         @Override
>         public void transfer(String from, String to, double money)
>         {
>             //判断转出账户余额是否充足(需要查询语句)
>             //如果转出账户余额不足,提示用户
>             //如果转出账户余额充足,更新转出余额(Update)
>             //更新转入余额(Update)
>         }
>     }
> 
>     package com.powernode.bank.service.impl;
>     
>     import com.powernode.bank.service.AccountService;
>     
>     public class AccountServiceImpl implements AccountService
>     {
>         @Override
>         public void transfer(String from, String to, double money)
>         {
>             //判断转出账户余额是否充足(需要查询语句)
>             //如果转出账户余额不足,提示用户
>             //如果转出账户余额充足,更新转出余额(Update)
>             //更新转入余额(Update)
>         }
>     }

>     package com.powernode.bank.POJO;
>     
>     public class Account
>     {
>         //封装账户数据
>         private Long id;
>         private String actno;
>         private Double balance;
>     
>         @Override
>         public String toString() {
>             return "Account{" +
>                     "id=" + id +
>                     ", actno='" + actno + '\'' +
>                     ", balance=" + balance +
>                     '}';
>         }
>     
>         public Long getId() {
>             return id;
>         }
>     
>         public void setId(Long id) {
>             this.id = id;
>         }
>     
>         public String getActno() {
>             return actno;
>         }
>     
>         public void setActno(String actno) {
>             this.actno = actno;
>         }
>     
>         public Double getBalance() {
>             return balance;
>         }
>     
>         public void setBalance(Double balance) {
>             this.balance = balance;
>         }
>     
>         public Account(Long id, String actno, Double balance) {
>             this.id = id;
>             this.actno = actno;
>             this.balance = balance;
>         }
>     
>         public Account() {
>         }
>     }
> 
>     package com.powernode.bank.POJO;
>     
>     public class Account
>     {
>         //封装账户数据
>         private Long id;
>         private String actno;
>         private Double balance;
>     
>         @Override
>         public String toString() {
>             return "Account{" +
>                     "id=" + id +
>                     ", actno='" + actno + '\'' +
>                     ", balance=" + balance +
>                     '}';
>         }
>     
>         public Long getId() {
>             return id;
>         }
>     
>         public void setId(Long id) {
>             this.id = id;
>         }
>     
>         public String getActno() {
>             return actno;
>         }
>     
>         public void setActno(String actno) {
>             this.actno = actno;
>         }
>     
>         public Double getBalance() {
>             return balance;
>         }
>     
>         public void setBalance(Double balance) {
>             this.balance = balance;
>         }
>     
>         public Account(Long id, String actno, Double balance) {
>             this.id = id;
>             this.actno = actno;
>             this.balance = balance;
>         }
>     
>         public Account() {
>         }
>     }

>     package com.powernode.bank.dao;
>     
>     public interface AccountDao
>     {
>         //Dao对象中没有任何一个方法与业务挂钩
>         //没有任何业务在里面
>         //他们只负责进行CRUD
>         //MVC三层架构就是分层职能分工
>     }
> 
>     package com.powernode.bank.dao;
>     
>     public interface AccountDao
>     {
>         //Dao对象中没有任何一个方法与业务挂钩
>         //没有任何业务在里面
>         //他们只负责进行CRUD
>         //MVC三层架构就是分层职能分工
>     }