python sqlite3 study

不包含第三方库

import time
import sqlite3

# 创建与数据库的连接
conn = sqlite3.connect('scores.db')

# 创建一个游标 cursor
cur = conn.cursor()

# 建表的sql语句
sql_text_1 = '''CREATE TABLE scores
           (name TEXT,
            class TEXT,
            sex TEXT,
            language NUMBER,
            math NUMBER,
            english NUMBER);'''
# 执行sql语句
cur.execute(sql_text_1)

start = time.time()
for i in range(0, 1000000):
    # 插入数据
    sql_text_2 = "INSERT INTO scores VALUES('A', '一班', '男', 96, 94, {})".format(i + 1)
    cur.execute(sql_text_2)

end = time.time()
conn.commit()
print(end - start)

# 关闭游标
cur.close()
# 关闭连接
conn.close()