#!/usr/bin/env python
# coding: utf-8
# In[29]:
import sqlalchemy
from sqlalchemy import create_engine
from sqlalchemy import Column
from sqlalchemy.types import CHAR, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from random import randint
from sqlalchemy import ForeignKey,select
from sqlalchemy import Table, MetaData
from sqlalchemy.orm import sessionmaker
from sqlalchemy import and_,or_
import numpy as np
HOSTNAME = "127.0.0.1"
PORT = "3306"
DATABASE = "ticketsystem"
USERNAME = "root"
PASSWORD = "110303"
DB_URI = "mysql+pymysql://{username}:{password}@{host}:{port}/{db}?charset=utf8". format(username=USERNAME,password=PASSWORD,host=HOSTNAME,port=PORT,db=DATABASE)
engine = create_engine(DB_URI)
conn = engine.connect()
result = conn.execute("select 1")
print(result.fetchone())
# In[30]:
import tkinter as tk
import tkinter.messagebox
import pickle
n=np.random.randint(0,1000)
window = tk.Tk()
window.title("欢迎使用铁路客票系统！")
window.geometry('500x600')
canvas = tk.Canvas(window, width=400, height=135, bg='pink')
canvas.pack(side='top')
tk.Label(window, text='铁路客票服务系统欢迎您',font=('Arial', 16)).pack()
tk.Label(window, text='用户名:', font=('Arial', 14)).place(x=10, y=170)
tk.Label(window, text='密码:', font=('Arial', 14)).place(x=10, y=210)
#用户名
var_usr_name = tk.StringVar()
var_usr_name.set('在此键入您的用户名')
entry_usr_name = tk.Entry(window, textvariable=var_usr_name, font=('Arial', 14))
entry_usr_name.place(x=120,y=175)
# 用户密码
var_usr_pwd = tk.IntVar()
entry_usr_pwd = tk.Entry(window, textvariable=var_usr_pwd, font=('Arial', 14), show='*')
entry_usr_pwd.place(x=120,y=215)
purchased_ticket_id=0
usr_name="test"
lookup_ticket_id=0
# 定义用户登录功能
def usr_login():
# 获取用户输入的usr_name和usr_pwd
global usr_name
usr_name = var_usr_name.get()
usr_pwd = var_usr_pwd.get()
Base=declarative_base()
md = MetaData(bind=engine) #引用MetaData
class user_info(Base):
__table__ = Table("user_info", md, autoload=True)
Session=sessionmaker(bind=engine)
session=Session()
record = session.query(user_info).filter(user_info.usr_name == usr_name).first()
if (record.usr_pwd == usr_pwd):
print("匹配成功")
tkinter.messagebox.showinfo(title='Welcome', message='欢迎使用铁路客票服务系统！ ' + usr_name)
Buy_Ticket()
else:
tk.messagebox.showerror(message='密码输入错误，请重试')
def usr_sign_up():
def sign_to_system():
# 以下三行就是获取我们注册时所输入的信息
np = new_pwd.get()
npf = new_pwd_confirm.get()
nn = new_name.get()
nphone = new_phone.get()
md = MetaData(bind=engine)
user_info = Table('user_info', md, autoload=True)
# 判断，如果两次密码输入不一致，则提示Error, Password and confirm password must be the same!
if np != npf:
tkinter.messagebox.showerror('错误', '两次密码输入请保持一致！')
ins_usr= user_info.insert()
ins_usr.execute(
usr_id=n,
usr_name=nn,
usr_pwd=np,
usr_phone=nphone
)
tkinter.messagebox.showinfo('Welcome', '恭喜！您已成功注册！')
window_sign_up.destroy()
window_sign_up = tk.Toplevel(window)
window_sign_up.geometry('300x200')
window_sign_up.title('Sign up window')
new_name = tk.StringVar() # 将输入的注册名赋值给变量
#new_name.set('example@tlxxxt.com')
tk.Label(window_sign_up, text='请输入用户名: ').place(x=10, y=10) # 将`User name:`放置在坐标（10,10）。
entry_new_name = tk.Entry(window_sign_up, textvariable=new_name) # 创建一个注册名的`entry`，变量为`new_name`
entry_new_name.place(x=130, y=10) # `entry`放置在坐标（150,10）.
new_pwd = tk.StringVar()
tk.Label(window_sign_up, text='密码 ').place(x=10, y=50)
entry_usr_pwd = tk.Entry(window_sign_up, textvariable=new_pwd, show='*')
entry_usr_pwd.place(x=130, y=50)
new_pwd_confirm = tk.StringVar()
tk.Label(window_sign_up, text='请再次输入密码 ').place(x=10, y=90)
entry_usr_pwd_confirm = tk.Entry(window_sign_up, textvariable=new_pwd_confirm, show='*')
entry_usr_pwd_confirm.place(x=130, y=90)
new_phone = tk.StringVar()
tk.Label(window_sign_up,text='请输入电话号码').place(x=10,y=130)
entry_usr_phone = tk.Entry(window_sign_up, textvariable=new_phone)
entry_usr_phone.place(x=130, y=130)
btn_comfirm_sign_up = tk.Button(window_sign_up, text='注册', command=sign_to_system)
btn_comfirm_sign_up.place(x=180, y=170)
btn_login = tk.Button(window, text='登陆', command=usr_login)
btn_login.place(x=120, y=240)
btn_sign_up = tk.Button(window, text='新用户？请注册新账户', command=usr_sign_up)
btn_sign_up.place(x=200, y=240)
var_admin_name = tk.StringVar()
var_admin_pwd = tk.StringVar()
def admin_login():
def verify_admin():
admin_name= var_admin_name.get()
admin_pwd = var_admin_pwd.get()
print(admin_name)
print(admin_pwd)
Base=declarative_base()
md = MetaData(bind=engine) #引用MetaData
class admin_info(Base):
__table__ = Table("admin_info", md, autoload=True)
Session=sessionmaker(bind=engine)
session=Session()
record = session.query(admin_info).filter(admin_info.admin_name==admin_name).first()
print("成功打开数据库")
print(record.admin_pwd)
if(record.admin_pwd == admin_pwd):
print("匹配成功")
tkinter.messagebox.showinfo(title='Welcome', message='欢迎使用系统管理功能! ' + admin_name)
admin_manage()
window_admin_login.destroy()
else:
print("匹配失败")
tkinter.messagebox.showerror(message='密码输入错误，请重试')
window_admin_login = tk.Toplevel(window)
window_admin_login.geometry('300x200')
window_admin_login.title('管理员登陆')
#获得用户输入的值
#管理员名
tk.Label(window_admin_login, text='管理员账户名 ').place(x=50, y=10) # 放置管理员登陆
entry_admin_name = tk.Entry(window_admin_login, textvariable=var_admin_name) #创建entry
entry_admin_name.place(x=130, y=10)
#管理员密码
tk.Label(window_admin_login, text='管理员账户密码').place(x=40, y=50) #放置管理员登陆密码
entry_admin_pwd = tk.Entry(window_admin_login, textvariable=var_admin_pwd, show='*') #创建entry
entry_admin_pwd.place(x=130, y=50)
btn_sign_up=tk.Button(window_admin_login,text='登陆',command=verify_admin)
btn_sign_up.place(x=150,y=100)
btn_admin_login = tk.Button(window, text='管理员登陆', command=admin_login)
btn_admin_login.place(x=400, y=240)
var_line_id = tk.StringVar()
var_line_station_1 = tk.StringVar()
var_line_station_2 = tk.StringVar()
var_line_station_3 = tk.StringVar()
var_line_station_4 = tk.StringVar()
var_line_station_5 = tk.StringVar()
int_line_distance = tk.IntVar()
int_station_id = tk.IntVar()
var_station_name = tk.StringVar()
var_station_open = tk.StringVar()
var_station_close = tk.StringVar()
var_station_location = tk.StringVar()
int_ticket_id = tk.IntVar()
var_start_station = tk.StringVar()
var_terminal_station = tk.StringVar()
var_stopping_station = tk.StringVar()
int_ticket_price = tk.IntVar()
int_available_seats = tk.IntVar()
var_go_time = tk.StringVar()
var_arr_time = tk.StringVar()
var_line_id = tk.StringVar()
var_train_id = tk.StringVar()
def admin_manage():
window_admin_manage=tk.Toplevel(window)
win
