基于python酒店管理系统设计与实现.zip（论文+项目源码）

import pymysql import datetime connection = pymysql.connect(host='localhost', port=3306, user='root', password='123456', db='hotel', charset='utf8') # 客户办理入住 def create_kh(): try: uno = input('请输入客户编号>>: ') uname = input('请输入客户姓名>>: ') usex = input('请输入客户性别>>: ') uid = input('请输入客户身份证号>>: ') utel = input('请输入客户联系方式>>: ') cursor = connection.cursor() sql = 'INSERT INTO user(uno, uname, usex, uid,utel) VALUES(%s,%s,%s,%s,%s)' result = cursor.execute(sql,(uno, uname, usex, uid,utel)) print('受影响行数：', result) connection.commit() cursor.close() except Exception as e: print('操作失败，失败信息为：', e) finally: connection.close() # 客户健康打卡 def create_dk(): try: hid = input('请输入卡的编号>>: ') htemp = input('请输入体温>>: ') hkey = input('请输入健康码颜色>>: ') htype = input('请输入健康状态>>: ') cursor = connection.cursor() sql = 'INSERT INTO health(hid, htemp, hkey, htype) VALUES(%s,%s,%s,%s)' result = cursor.execute(sql,(hid, htemp, hkey, htype)) print('受影响行数：', result) connection.commit() cursor.close() except Exception as e: print('操作失败，失败信息为：', e) finally: connection.close() # 更新退房时间 def update_sj(): try: uno = input('更新退房时间,请输入客户编号>>: ') outtime = datetime.datetime.today() cursor = connection.cursor() sql = 'UPDATE live SET outtime = %s WHERE uno = %s' result = cursor.execute(sql,(outtime, uno)) print('受影响行数：', result) connection.commit() cursor.close() except Exception as e : print('操作失败，失败信息为：', e) connection.rollback() finally: connection.close() def create_yg(): try: rno = input('请输入房间编号>>: ') rtype = input('请输入房间类型>>: ') rstate = input('请输入房间状态>>: ') rprice = input('请输入房间价格>>: ') cursor = connection.cursor() sql = 'INSERT INTO room(rno, rtype, rstate, rprice) VALUES(%s,%s,%s,%s)' result = cursor.execute(sql,(rno, rtype, rstate, rprice)) print('受影响行数：', result) connection.commit() cursor.close() except Exception as e: print('操作失败，失败信息为：', e) finally: connection.close() # 员工删除房间 def delete_fj(): try: rno = input('请输入房间编号>>：') cursor = connection.cursor() sql = 'DELETE FROM room WHERE rno = %s' sql = sql % rno print(sql) result = cursor.execute(sql) print('删除的数据为：', result) connection.commit() cursor.close() except Exception as e: print('操作失败，失败信息为：', e) connection.rollback() finally: connection.close() # 员工删除客户 def delete_kh(): try: uno = input('请输入客户编号>>：') cursor = connection.cursor() sql = 'DELETE FROM user WHERE uno = %s' sql = sql % uno print(sql) result = cursor.execute(sql) print('删除的数据为：', result) connection.commit() cursor.close() except Exception as e: print('操作失败，失败信息为：', e) connection.rollback() finally: connection.close() # 员工查询客户信息 def select_kh(): try: uno = input('请输入客户编号>>: ') cursor = connection.cursor() sql = 'SELECT uno, uname , usex , uid , utel FROM user WHERE uno = %s' cursor.execute(sql, (uno,)) result = cursor.fetchone() print('查询到数据为：', result) except Exception as e: print('操作失败，失败信息为：', e) connection.close() # 员工查询房间信息 def select_room(): try: cursor = connection.cursor() sql = "SELECT * FROM room;" cursor.execute(sql) results = cursor.fetchall() print('执行sql成功：', sql) print('查询结果：') print("rno\t\t\t", "rtype\t\t\t\t\t\t\t", "rstate\t\t\t\t\t", "rprice\t\t\t") # 遍历结果 for row in results: rno = row[0] rtype = row[1] rstate = row[2] rprice = row[3] print(rno, "\t\t\t", rtype, "\t\t\t", rstate, "\t\t\t", rprice) except Exception as e: raise e connection.close() # 选择菜单 def Menu(): print('*************************欢迎来到酒店管理系统********************') print('\t\t\t\t1.客户办理入住') print('\t\t\t\t2.客户健康打卡') print('\t\t\t\t3.客户办理退房') print('\t\t\t\t4.员工增加房间') print('\t\t\t\t5.员工删除房间') print('\t\t\t\t6.员工删除客户') print('\t\t\t\t7.员工查询客户信息') print('\t\t\t\t8.员工查询房间信息') print('\t\t\t\t0.退出') print('************************************************************') # 主程序 def main(): print('##########################酒店管理系统###########################') while True: Menu() select=eval(input('请选择功能：')) if select==1: create_kh() print('办理入住成功！') print('\n') elif select==2: create_dk() print('打卡成功！') print('\n') elif select==3: update_sj() print('办理退房成功！') print('\n') elif select==4: create_yg() print('添加房间成功！') print('\n') elif select==5: delete_fj() print('删除房间成功！') print('\n') elif select==6: delete_kh() print('删除客户成功！') print('\n') elif select==7: select_kh() print('\n') elif select==8: select_room() print('\n') else: print('谢谢使用') break if __name__ == '__main__': main()