def cancel_ticket(user_name):
db = pymysql.connect("localhost", "root", "", "new_schema")
cursor1 = db.cursor1()
try:
# 2、取消订票
print("cancel ticket? please input 1 or 0")
# cancel_ticket=input()
cancel_ticket = 1
cancel_ticket = int(cancel_ticket)
# 航班信息展示,输入航班信息就能确定位置
print("input flight_ID ")
# flight_ID = input()
flight_ID = 'A1'
sql_select_flight = "select * from airplane where flight_ID='%s'" % flight_ID
cursor1.execute(sql_select_flight)
rs = cursor1.fetchall()
for row in rs:
leftover = row[1]
# 修改表1主航班的flight_ID修改，提交保存leftover+1的表
if (cancel_ticket == 1):
leftover += 1
sql_cancel_ticket = "update airplane set leftover=%d where flight_ID='%s' " % (
leftover, flight_ID)
cursor1.execute(sql_cancel_ticket)
print("cancel success")
if (cancel_ticket == 0):
print("cancel exit sucess")
getInfoFromMySQL.getInfo('user_info', 'user_name', user_name, 0,
'show')
seat = ''
# 修改表2空座位信息，详细表座位信息修改,
sql_update = "update %s set empty=0 where seat='%s'" % (flight_ID,
seat)
cursor1.execute(sql_update)
# 修改表3){客户user_info表 :))1.航班 flight_ID ))2.座位 seat}
sql_update = "update user_info set seat='%s',flight_ID='%s' where user_name='%s'" % (
seat, flight_ID, user_name)
cursor1.execute(sql_update)
rs = cursor1.fetchall()
print("客户信息")
print("ID||user_name||user_password||seat||flight_ID")
getInfoFromMySQL.getInfo('user_info', 'user_name', user_name, 0,
'show')
except Exception as e:
print(e)
db.rollback()
db.commit()
db.close()
def main():
print("please log_in")
user_name = log_in.log_in()
#??pydev debugger: process 8328 is connecting
#选择界面循环
choice = 1
while choice != 0:
print(
"function:3.view table airplane 4.order 6.book_ticket 7.cancel_ticket"
)
_input = input()
_input = int(_input)
# _input = 4
if (_input == 3):
getInfoFromMySQL.getInfo('airplane', 'flight_ID', '', 0,
'all airplane')
if (_input == 4):
getInfoFromMySQL.getInfo('airplane', 'flight_ID', '', 0,
'order des airplane')
if (_input == 5):
break # find()
if (_input == 6):
try:
book_ticket.book_ticket(user_name)
except Exception as e:
print(e)
if (_input == 7):
cancel_ticket.cancel_ticket(user_name)
#提示是否跳出选择界面循环
print("want to exit,enter make choice ==0 else enter 1 to continue")
choice = input()
choice = int(choice)
if (choice != 0):
continue
else:
break
def cancel_ticket(user_name):
judge = 1
db = pymysql.connect("localhost", "root", "", "new_schema")
cursor1 = db.cursor()
try:
# 2、取消订票
print("cancel ticket? please input 1 or 0")
cancel_ticket = input()
# cancel_ticket = 1
cancel_ticket = int(cancel_ticket)
seat = getInfoFromMySQL.getInfo('user_info', 'user_name', user_name, 0,
'show')
_type = type(seat)
print("type(seat)", _type)
if (seat == ''): #??
judge = 0
# 航班信息展示,输入航班信息就能确定位置
print("input flight_ID ")
flight_ID = input()
# flight_ID = 'A1'
sql_select_flight = "select * from airplane where flight_ID='%s'" % flight_ID
cursor1.execute(sql_select_flight)
rs = cursor1.fetchall()
for row in rs:
leftover = row[1]
if (leftover < 150 and judge == 1):
# 修改表1主航班的flight_ID修改，提交保存leftover+1的表
if (cancel_ticket == 1):
leftover += 1
sql_cancel_ticket = "update airplane set leftover=%d where flight_ID='%s' " % (
leftover, flight_ID)
cursor1.execute(sql_cancel_ticket)
print("cancel success")
if (cancel_ticket == 0):
print("cancel exit sucess")
seat = getInfoFromMySQL.getInfo('user_info', 'user_name',
user_name, 0, 'NULL')
# 修改表2空座位信息，详细表座位信息修改,
sql_update = "update %s set empty=1 where seat='%s'" % (flight_ID,
seat)
cursor1.execute(sql_update) # print(sql_update)
db.commit()
sql_update = "update user_info set seat='',flight_ID='' where user_name='%s'" % user_name
cursor1.execute(sql_update)
db.commit()
print("客户信息")
print("ID||user_name||user_password||seat||flight_ID")
getInfoFromMySQL.getInfo('user_info', 'user_name', user_name, 0,
'show')
else:
print("已经cancel,不能重复")
except Exception as e:
print(e)
db.rollback()
cursor1.close()
db.commit()
db.close()
def book_ticket(user_name='Zheng'): # 订阅特定航班，先展示特定航班座位空的信息
db = pymysql.connect("localhost", "root", "", "new_schema")
cursor = db.cursor()
judge = 1
try:
# 航班信息展示
print("book ticket?please input flight_ID ")
flight_ID = input("输入想要航班名称")
# flight_ID='A1'
print("具体某一航班信息展示，此为%s" % flight_ID)
# flight_ID.lower()
try:
sql_select_flight = "select * from %s where empty=1" % flight_ID
cursor.execute(sql_select_flight)
rs = cursor.fetchall()
print("flight_ID|| seat ")
for row in rs:
print(row[0:2])
except Exception as e:
print(e)
db.rollback()
cursor.close() #另起一个游标先
cursor1 = db.cursor()
#1、订票,牵涉3张 表：1)主表airplane座位剩余leftover 2){航班具体座位信息 flight_A1 :)1)seat ))2.empty }
# 3){客户user_info表 :))1.航班 flight_ID ))2.座位 seat}
print("想要什么座位")
# book_=input()
book_ = 1
book_ = int(book_)
if (book_ == 1):
book_ = input()
seat = getInfoFromMySQL.getInfo('user_info', 'user_name',
user_name, 0, 'show')
if (seat != ''):
judge = 0
if (judge == 1):
seat = 'a1'
print("座位", seat)
# print("input the seat wanted %s"%seat)
#修改座位
# 1、订票,牵涉3张 表：1)主表airplane座位剩余leftover 2){航班具体座位信息 flight_A1 :)1)seat ))2.empty }
# 3){客户user_info表 :))1.航班 flight_ID ))2.座位 seat}
#1、1)主表airplane座位剩余leftover
# print("订座成功，您的航班信息")
#修改三张表,有
choice = 'alter --'
#修改1表主航班,leftover
sql_select_flight = "select * from airplane where flight_ID='%s'" % seat
cursor1.execute(sql_select_flight)
rs = cursor1.fetchall()
try:
for row in rs:
leftover = row[1]
# 更新后数据
leftover = int(leftover)
leftover -= 1
sql_update = "update airplane set leftover=%d where flight_ID='%s' " % (
leftover, flight_ID)
cursor1.execute(sql_update)
db.commit()
#更新后数据展示
except Exception as e:
print(e)
db.rollback()
#修改表2空座位信息，详细表座位信息修改,
sql_update = "update %s set empty=0 where seat='%s'" % (
flight_ID, seat)
cursor1.execute(sql_update)
# 修改表3){客户user_info表 :))1.航班 flight_ID ))2.座位 seat}
sql_update = "update user_info set seat='%s',flight_ID='%s' where user_name='%s'" % (
seat, flight_ID, user_name)
cursor1.execute(sql_update)
db.commit()
print("客户信息")
print("ID||user_name||user_password||seat||flight_ID")
getInfoFromMySQL.getInfo('user_info', 'user_name', user_name,
0, 'show')
else:
print("您已经已经订过此票了")
except Exception as e:
print(e)
db.rollback()
#??老是报cursor closed
cursor1.close()
db.commit()
db.close()
# book_ticket(user_name='Zheng')