帮帮忙运行一下这段代码?

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()
阅读 2.5k
1 个回答
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题