期末数据库大作业,自学python花了好几天时间写了这个小程序,因为网上资料不多完整的代码也很少,所以在这里记录一下,大神不喜勿喷。
数据库:Oracle
语言:Python
import cx_Oracle
import os
conn = cx_Oracle.connect('test/123456@localhost/orcl')
cursor = conn.cursor()
#登录 001 123456
'''
def index(admin_no,admin_passwd):
cursor.execute("select * from admin where admin_no='"+admin_no+"'")
tel=cursor.fetchone()
if tel[2]==admin_passwd:
print("登录成功")
else:
print("用户或密码错误")
'''
#管理员插入
def admin_insert(admin_no,admin_name,admin_passwd,admin_tel):
cursor.execute("insert into admin values('"+admin_no+"','"+admin_name+"','"+admin_passwd+"','"+admin_tel+"')");
conn.commit();
#管理员更改
def admin_update(admin_noo):
admin_no=input("更改的编号:")
admin_name=input("更改的姓名:")
admin_passwd=input("更改的密码:")
admin_tel=input("更改的电话:")
cursor.execute("update admin set admin_no='"+admin_no+"',admin_name='"+admin_name+"',admin_passwd='"+admin_passwd+"',admin_tel='"+admin_tel+"' where admin_no='"+admin_noo+"'");
conn.commit();
#管理员删除
def admin_delete(admin_no):
cursor.execute("delete from admin where admin_no='"+admin_no+"'");
conn.commit();
#裁判插入
def referee_insert(referee_no,referee_name,referee_sex,referee_dept):
cursor.execute("insert into referee values('"+referee_no+"','"+referee_name+"','"+referee_sex+"','"+referee_dept+"')");
conn.commit();
#裁判更改
def referee_update(referee_noo):
referee_no=input("更改的编号:")
referee_name=input("更改的姓名;")
referee_sex=input("更改的性别:")
referee_dept=input("更改的项目:")
cursor.execute("update referee set referee_no='"+referee_no+"',referee_name='"+referee_name+"',referee_sex='"+referee_sex+"',referee_dept='"+referee_dept+"' where referee_no='"+referee_noo+"'");
conn.commit();
#裁判删除
def referee_delete(referee_no):
cursor.execute("delete from referee where referee_no='"+referee_no+"'");
conn.commit();
#运动员插入
def player_insert(player_no,player_name,player_sex,player_dept,player_age):
cursor.execute("insert into player values('"+player_no+"','"+player_name+"','"+player_sex+"','"+player_dept+"','"+player_age+"')");
#运动员更改
def player_update(player_noo):
player_no=input("更改的编号:")
player_name=input("更改的姓名;")
player_sex=input("更改的性别:")
player_dept=input("更改的项目:")
player_age=input("更改的年龄:")
cursor.execute("update player set player_no='"+player_no+"',player_name='"+player_name+"',player_sex='"+player_sex+"',player_dept='"+player_dept+"',player_age='"+player_age+"' where player_no='"+player_noo+"'");
conn.commit();
#运动员删除
def player_delete(player_no):
cursor.execute("delete from player where player_no='"+player_no+"'");
conn.commit();
#分数插入
def score_insert(score_no,score_pno,score_dno,score_sno,score_score):
cursor.execute("insert into score values('"+score_no+"','"+score_pno+"','"+score_dno+"','"+score_sno+"','"+score_score+"')");
#分数更改
def score_update(score_noo):
score_no=input("更改的成绩编号:")
score_pno=input("更改的选手编号;")
score_dno=input("更改的项目编号:")
score_sno=input("更改的排名:")
score_score=input("更改的成绩:")
cursor.execute("update score set score_no='"+score_no+"',score_pno='"+score_pno+"',score_dno='"+score_dno+"',score_sno='"+score_sno+"',score_score='"+score_score+"' where score_no='"+score_noo+"'");
conn.commit();
#分数删除
def score_delete(score_no):
cursor.execute("delete from score where score_no='"+score_no+"'");
conn.commit();
while(True):
print("1.登录")
print("2.退出")
str=input("请选择功能:")
if(str=='1'): #登录
admin_no=input("请输入用户名:")
admin_passwd=input("请输入密码:")
#print(admin_no)
#print(admin_passwd)
cursor.execute("select * from admin where admin_no='"+admin_no+"' ")
passwd=cursor.fetchone()
#print(passwd)
if passwd[2]==admin_passwd:
#os.system("cls")
print("登录成功")
while(True):
print("1.管理员管理")
print("2.裁判管理")
print("3.运动员管理")
print("4.分数管理")
print("5.返回")
str=input("请选择功能:")
if(str=='1'): #管理员管理
while(True):
print("1.增加")
print("2.删除")
print("3.查询")
print("4.修改")
print("5.返回")
str=input("请选择功能:")
if(str=='1'): #增加管理员
admin_no=input("管理员编号:")
admin_name=input("管理员姓名:")
admin_passwd=input("管理员密码:")
admin_tel=input("管理员电话:")
admin_insert(admin_no,admin_name,admin_passwd,admin_tel)
print("添加成功!")
elif(str=='2'): #删除管理员
admin_no=input("要删除的管理员编号:")
admin_delete(admin_no)
print("删除成功!")
elif(str=='3'): #查询管理员
cursor.execute ("select * from admin")
rows = cursor.fetchall() #得到所有数据集
for row in rows:
print("%s,%s,%s,%s" % (row[0], row[1], row[2],row[3]))
elif(str=='4'): #修改管理员
admin_noo=input("要修改的管理员编号:")
admin_update(admin_noo)
else: #返回
break
elif(str=='2'): #裁判员管理
while(True):
print("1.增加")
print("2.删除")
print("3.查询")
print("4.修改")
print("5.返回")
str=input("请选择功能:")
if(str=='1'): #增加裁判员
referee_no=input("裁判编号:")
referee_name=input("裁判员姓名:")
referee_sex=input("裁判员性别:")
referee_dept=input("裁判员项目:")
referee_insert(referee_no,referee_name,referee_sex,referee_dept)
print("添加成功!")
elif(str=='2'): #删除裁判员
referee_no=input("要删除的裁判员编号:")
referee_delete(referee_no)
print("删除成功!")
elif(str=='3'): #查询裁判员
cursor.execute ("select * from referee")
rows = cursor.fetchall() #得到所有数据集
for row in rows:
print("%s,%s,%s,%s" % (row[0], row[1], row[2],row[3]))
elif(str=='4'): #修改裁判员
referee_noo=input("要修改的管理员编号:")
referee_update(referee_noo)
else: #返回
break
elif(str=='3'): #运动员管理
while(True):
print("1.增加")
print("2.删除")
print("3.查询")
print("4.修改")
print("5.返回")
str=input("请选择功能:")
if(str=='1'): #增加运动员
player_no=input("运动员编号:")
player_name=input("运动员员姓名:")
player_sex=input("运动员性别:")
player_dept=input("运动员项目:")
player_age=input("运动员年龄:")
player_insert(player_no,player_name,player_sex,player_dept,player_age)
print("添加成功!")
elif(str=='2'): #删除运动员
player_no=input("要删除的运动员编号:")
player_delete(player_no)
print("删除成功!")
elif(str=='3'): #查询运动员
cursor.execute ("select * from player")
rows = cursor.fetchall() #得到所有数据集
for row in rows:
print("%s,%s,%s,%s,%s" % (row[0], row[1], row[2],row[3],row[4]))
elif(str=='4'): #修改运动员
player_noo=input("要修改的管理员编号:")
player_update(referee_noo)
else: #返回
break
elif(str=='4'): #分数查询
while(True):
print("1.增加")
print("2.删除")
print("3.查询")
print("4.修改")
print("5.返回")
str=input("请选择功能:")
if(str=='1'): #增加分数
score_no=input("成绩编号:")
score_pno=input("运动员编号:")
score_dno=input("项目编号:")
score_sno=input("排名:")
score_score=input("成绩")
score_insert(score_no,score_pno,score_dno,score_sno,score_score)
print("添加成功!")
elif(str=='2'): #删除分数
score_no=input("要删除的分数编号:")
score_delete(score_no)
print("删除成功!")
elif(str=='3'): #查询分数
cursor.execute ("select * from score")
rows = cursor.fetchall() #得到所有数据集
for row in rows:
print("%s,%s,%s,%s,%s" % (row[0], row[1], row[2],row[3],row[4]))
elif(str=='4'): #修改分数
score_noo=input("要修改的分数编号:")
score_update(score_noo)
else: #返回
break
else:
print("用户或密码错误")
else: #退出
break