runxinzhi.com
首页
百度搜索
ATM取款机系统模拟仿真
#!/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" read newpassword update_sql_password="update $TABLENAME set password=$newpassword where name='$name'" mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${update_sql_password}" main ;; #取款 3) echo "Please input how money do you want draw money" read draw 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` if [[ $draw -gt $nowmoney ]] then echo "The card money is little" main else let "nowmoney=$nowmoney-$draw" update_sql="update $TABLENAME set money=$nowmoney where name='$name'"; mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${update_sql}" fi main ;; #存款 4)echo "Please input how money do you want Deposit money" read deposit 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` let "nowmoney=$nowmoney+$deposit" update_sql="update $TABLENAME set money=$nowmoney where name='$name'"; mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${update_sql}" main ;; #退出系统 5) echo "Now you level the system!!" exit ;; esac } #输入密码函数 passwordfun() { read password select_sql_pass="select password from ${TABLENAME} where name='$name'" realpassword=` mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${select_sql_pass}" |awk '{print $1}'|tail -n1` if [[ $password -eq $realpassword ]] then main #密码不对,重新输入 elif [[ $password -ne $realpassword ]] then let "flag++" if [[ $flag -gt 4 ]] then echo "you password enter three times ,the system quit !!" exit 0 fi echo "sorry passwors is wrong,Please input password again" passwordfun fi } echo "Please input the card name:" #输入用户名 #输入用户函数进行判断 namefun() { read name select_sql_name="select name from ${TABLENAME} where name='$name'" real=` mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${select_sql_name}" |awk '{print $1}'|tail -n1` if [[ -n $real ]] ; then echo "Please input the password:" passwordfun #帐号不对,重新输入 else let "flag1++" if [[ $flag1 -gt 4 ]] then echo "you name enter three times ,the system quit !!" exit 0 fi echo "sorry name is wrong,Please input name again" namefun fi } namefun
相关阅读:
redis缓存和mysql数据库同步
msf生成shellcode
转 如何用mt7620方案的rt2860v2驱动实现wifi探针功能,网上能搜到一些方法,但是讲的好模糊?
解决 “不支持尝试执行的操作”错误
解决win7资源监视器不能开启
mp3文件 ID3v2 帧标识的含义
LoadImage函数问题
AutoCAD ObjectARX(VC)开发基础与实例教程2014版光盘镜像
Python计算文件MD5值
objectARX 获取指定图层上所有实体ID
原文地址:https://www.cnblogs.com/linuxer/p/2441243.html
最新文章
51 Nod 1556计算(默慈金数的应用)
默慈金数
Oracle监听服务
Oracle数据库常见版本
MongoDB(课时30 $group)
MongoDB(课时29 MapReduce)
MongoDB(课时28 group操作)
MongoDB(课时27 消除重复数据)
MongoDB(课时26 聚合(取的集合个数))
MongoDB(课时25 地理信息索引)
热门文章
MongoDB(课时24 全文索引)
MongoDB(课时22 过期索引)
优化
微服务
记一次redis读取超时的排查过程(SADD惹的祸)
快速的统计千万级别uv
类
阿里云磁盘
使用PHP来简单的创建一个RPC服务
Memcache和Redis
Copyright © 2020-2023
润新知