JAVA-EE搭建数据库和JSP前端页面实现银行转账业务------计算机网络经典

旧约Alatus

已于 2024-01-18 15:01:40 修改

阅读量105

点赞数 1

分类专栏： JAVA 计算机网络文章标签： java sql 1024程序员节 java-ee tomcat mysql jsp

于 2023-10-26 11:35:13 首次发布

本文链接：https://blog.csdn.net/2201_75960169/article/details/134052338

版权

JAVA 同时被 2 个专栏收录

553 篇文章 3 订阅

订阅专栏

计算机网络

134 篇文章 0 订阅

订阅专栏

CREATE TABLE t_act(id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,actno VARCHAR(255) NOT NULL,balance DECIMAL(10,2))
INSERT INTO t_act(id,actno,balance) VALUES(NULL,'act001',50000)
INSERT INTO t_act(id,actno,balance) VALUES(NULL,'act002',0)
SELECT * FROM t_act
SELECT * FROM t_act WHERE actno = 'act001'
SELECT * FROM t_act WHERE actno = 'act001'
CREATE TABLE t_act(id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,actno VARCHAR(255) NOT NULL,balance DECIMAL(10,2))
INSERT INTO t_act(id,actno,balance) VALUES(NULL,'act001',50000)
INSERT INTO t_act(id,actno,balance) VALUES(NULL,'act002',0)
SELECT * FROM t_act
SELECT * FROM t_act WHERE actno = 'act001'
SELECT * FROM t_act WHERE actno = 'act001'

package com.bjpowernode.Bank.exception;

public class MoneyNotEnoughException extends Exception
{
    public MoneyNotEnoughException(){}
    public MoneyNotEnoughException(String msg){super(msg);}
}

package com.bjpowernode.Bank.exception;

public class MoneyNotEnoughException extends Exception
{
    public MoneyNotEnoughException(){}
    public MoneyNotEnoughException(String msg){super(msg);}
}

package com.bjpowernode.Bank.exception;

public class AppException extends Exception
{
    public AppException(){}

    public AppException(String message) {
        super(message);
    }
}

package com.bjpowernode.Bank.exception;

public class AppException extends Exception
{
    public AppException(){}

    public AppException(String message) {
        super(message);
    }
}

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
    <head>
        <title>Title</title>
        <base href="${pageContext.request.scheme}://${pageContext.request.serverName}:${pageContext.request.serverPort}${pageContext.request.contextPath}/">
    </head>
    <body>
        <form action="bank/transfer" method="post">
            转出账户:<input type="text" name="fromActno"><br>
            转入账户:<input type="text" name="toActno"><br>
            转账金额:<input type="text" name="Value"><br>
            <input type="submit" name="转账">
        </form>
    </body>
</html>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
    <head>
        <title>Title</title>
        <base href="${pageContext.request.scheme}://${pageContext.request.serverName}:${pageContext.request.serverPort}${pageContext.request.contextPath}/">
    </head>
    <body>
        <form action="bank/transfer" method="post">
            转出账户:<input type="text" name="fromActno"><br>
            转入账户:<input type="text" name="toActno"><br>
            转账金额:<input type="text" name="Value"><br>
            <input type="submit" name="转账">
        </form>
    </body>
</html>