存储过程说明.sql

来自「一个与金融方面有关的问题」· SQL 代码 · 共 31 行

--银行系统相关存储过程的说明

--客户退出封包处理
customer_exit_proc(@customer_name char(11))
--客户登陆封包处理
customer_login_proc(@customer_name char(11),@customer_pwd char(17),@customer_login_ip char(17))
--客户查询余额
findBalance_proc(@accountId char(19))
--存款
inMoney_proc(@account_id char(19),@account_pwd char(17),@moneyNum char(10),@opBankIP char(16))
--取款
outMoney_proc(@account_id char(19),@account_pwd char(17),@moneyNum char(10),@opBankIP char(16))
--转帐
transfer_proc(@outAccount_id char(19),@outAccount_pwd char(17),@inAccount_id char(19),@moneyNum char(10),@opBankIP char(17))
--注册新账户
register_account_proc(@account_id char(19),@account_pwd char(17)，@account_bank_ip char(17),@account_customer_name char(11),@account_balance char(9)='0.0')
--注册客户
register_customer_proc(@customer_name char(11),@customer_pwd char(17),
@customer_real_name char(11),@customer_regbank_ip char(17),
@customer_phone char(16)='have no',@customer_addr char(21)='have no',
@customer_email char(21) ='have no')
--首次注册
register_first_proc(@customer_name char(11),@customer_pwd char(17),
@account_id char(19),@account_pwd char(17),@customer_real_name char(11),
@customer_regbank_ip char(17),@customer_phone char(16),
@customer_addr char(21),@customer_email char(21))
--查询显示
show_customer_proc(@customer_name char(11))
--查询
find_customer_proc(@customer_name char(11))