python自動取款機程序_python ATM取款機----運維開發初學（上篇）

自動取款機基本功能：可以存取轉賬，刷卡信息查詢，銀行卡號歷史信息查詢，消費記錄查詢，修改密碼。

思維導圖如下：

數據庫設計：

mysql> desc balan_list; #保存賬號交易記錄option_type

+-------------+-------------+------+-----+---------+-------+

+-------------+-------------+------+-----+---------+-------+

| card_name?? | varchar(50) | YES? |???? | NULL??? |?????? |

| balance???? | int(11)???? | YES? |???? | NULL??? |?????? |

| option_type | varchar(30) | YES? |???? | NULL??? |?????? |

| pay_cash??? | int(11)???? | YES? |???? | NULL??? |?????? |

| option_time | varchar(50) | YES? |???? | NULL??? |?????? |

+-------------+-------------+------+-----+---------+-------+

5 rows in set (0.02 sec)

mysql> desc hist_list;#刷卡消費記錄

+-------------+-------------+------+-----+---------+-------+

+-------------+-------------+------+-----+---------+-------+

| order_num?? | int(11)???? | YES? |???? | NULL??? |?????? |

| order_name? | varchar(50) | YES? |???? | NULL??? |?????? |

| order_price | int(11)???? | YES? |???? | NULL??? |?????? |

| order_user? | varchar(50) | YES? |???? | NULL??? |?????? |

| order_time? | datetime??? | YES? |???? | NULL??? |?????? |

+-------------+-------------+------+-----+---------+-------+

5 rows in set (0.00 sec)

mysql> desc order_list;#商品列表

+-------------+-------------+------+-----+---------+-------+

+-------------+-------------+------+-----+---------+-------+

| order_id??? | int(11)???? | YES? |???? | NULL??? |?????? |

| order_name? | varchar(20) | YES? |???? | NULL??? |?????? |

| order_price | int(11)???? | YES? |???? | NULL??? |?????? |

+-------------+-------------+------+-----+---------+-------+

mysql> select * from user_account; #賬號信息表

+-----------+--------+---------+--------------+----------+-------------+

+-----------+--------+---------+--------------+----------+-------------+

| 9995501?? | 000000 |? 100772 |?1????? |?? 100000 | NULL??????? |

| 9995502?? | 111111 |??? 9812 |?2?????? |???? 1000 | NULL??????? |

| 9995503?? | 222222 |?? 15000 | 2??????????? |??????? 0 | NULL??????? |

| 9995504?? | 333333 |?? 16000 | 1??????????? |???? 1000 | NULL??????? |

+-----------+--------+---------+--------------+----------+-------------+

4 rows in set (0.00 sec)

mysql> desc lock_account;鎖賬號的表+-------+------------------+------+-----+---------+----------------+| Field | Type???????????? | Null | Key | Default | Extra????????? |+-------+------------------+------+-----+---------+----------------+| id??? | int(10) unsigned | NO?? | PRI | NULL??? | auto_increment || name? | varchar(45)????? | NO?? |???? |???????? |??????????????? |+-------+------------------+------+-----+---------+----------------+2 rows in set (0.00 sec)

本文來自互聯網用戶投稿，該文觀點僅代表作者本人，不代表本站立場。本站僅提供信息存儲空間服務，不擁有所有權，不承擔相關法律責任。
如若轉載，請注明出處：http://www.pswp.cn/news/453633.shtml
繁體地址，請注明出處：http://hk.pswp.cn/news/453633.shtml
英文地址，請注明出處：http://en.pswp.cn/news/453633.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！