Python3我一直装不上cx_Oracle模块,没法测试代码是否能用,在此求助!!谢谢各位了~
代码功能非常简单,就是建立一个功能菜单,执行SQL语句
现在附上代码,希望有cx_Oracle模块的dalao帮我运行一下,如果有错误,帮我改改
import prettytable
import cx_Oracle as db
conn = db.connect('xxxxx/xxxxxxxx')
cursor = conn.cursor()
def main():
"""
图书馆数据库管理系统
:return:
"""
while True:
print("Welcome to Library".center(92, '*'))
menu = prettytable.PrettyTable() # 初始化表格
menu.field_names = ['Function', 'manager', 'floor', 'BookInformation',
'reader', 'ReaderInformation', 'ReaderBorrow','boorow', 'Exit'] # 添加表格字段
menu.add_row(['Hot key', 'M', 'F', 'B', 'R', 'RI', 'RB', 'BW'])
print(menu)
try:
choice = input("Please enter the function key: ").upper()
except(KeyError, EOFError, KeyboardInterrupt):
choice = 'Q'
if choice == 'M':
manager()
if choice == 'F':
pass
if choice == 'B':
pass
if choice == 'R':
pass
if choice == 'RI':
pass
if choice == 'RB':
pass
if choice == 'BW':
pass
if choice == 'Q':
exit()
def manager():
manager = """
create table manager( /*管理员表*/
gbh char(20) not null /*管理员编号,主键*/
constraint mg_pk primary key,
gzc varchar(10) not null unique, /*职称*/
gmm char(10) not null, /*对应密码*/
gqx varchar(20), /*对应权限*/
llch number(2) not null /*对应楼层*/
);
"""
# 插入manager表中的数据
mag_data = """
insert into manager(gbh,gzc,gmm,gqx,llch)
values('1002','cleaner','1234','clean',1);
insert into manager(gbh,gzc,gmm,gqx,llch)
values('1003','manger','1235','clean',2);
insert into manager(gbh,gzc,gmm,gqx,llch)
values('1000','baishu','1236','clean',1);
insert into manager(gbh,gzc,gmm,gqx,llch)
values('1004','zhibang','1237','zhibang',1);
"""
cursor.execute(manager)
cursor.execute(mag_data)
conn.commit()
sql = 'select * from manager'
cursor.execute(sql)
rows = cursor.fetchall()
for row in rows:
print(row)
cursor.close()
conn.close()
if __name__ == '__main__':
main()
你用的是windows吧?windows下装类似cxOracle之类的,请到这里找http://www.lfd.uci.edu/~gohlk...