学习笔记(27):21天通关Python（仅视频课）-案例实操：用程序执行SQL脚本

立即学习:https://edu.youkuaiyun.com/course/play/24797/282207?utm_source=blogtoedu

import sqlite3

conn = sqlite3.connect('test54.db')
# conn.execute('''
# create table user_tb (
#       _id integer primary key autoincrement,
#       name text,
#       paihang integer ,
#       leixing text);
# ''')
try:
    result = 0;
    with open('test54.sql', 'r', True, 'UTF-8') as f:
        sql = f.read()
        result = conn.executescript(sql).rowcount

    conn.execute('select * from user_tb')
    for r in conn.execute('select * from user_tb'):
        print(r)

    if result:
        print("成功：", result)
        conn.commit()
    else:
        print('错误')
        conn.rollback()

except OSError as e:
    print('有错误')
    print(e.args)
    print(e.strerror)
    print(e.errno)
    conn.rollback()
finally:
    conn.close()