#!/bin/sh
HOSTNAME="localhost" #数据库信息
PORT="3306"
USERNAME="root"
PASSWORD=""
#数据库名称
DBNAME="bank"
TABLENAME="user"
#两个标记,用于判断是否超过输入
flag=1
flag1=1
#输入帐号密码成功后进行接下来操作
main()
{
echo "Please input what do you want to do ?(1、Balance inquiries 2、Change Password 3、draw money 4 、Deposit 5、exit) "
read choice
case $choice in
#查询余额
1 )
select_sql_money_now="select money from ${TABLENAME} where name='$name'"
nowmoney=` mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${select_sql_money_now}" |awk '{print $1}'|tail -n1`
echo "Balance inquiries is $nowmoney ¥"
main
;;
#修改密码
2)
echo "Please input the new password
ATM取款机系统模拟仿真
最新推荐文章于 2023-09-19 00:38:33 发布