auto.js B0016 python 数据库写入数据 每两行写入数据库 2021-10-05

# -*- coding: utf-8 -*-
"""
Created on Mon Nov  9 18:46:31 2020

@author: Administrator
"""
import sqlite3

import sys
path="C:\guru99.txt"

# 连接数据库(如果不存在则创建)
conn = sqlite3.connect('TTKKFF.db')
print("Opened database successfully")
 
# 创建游标
cursor = conn.cursor()

 
# 创建表
sql = 'CREATE TABLE TiKu(id integer PRIMARY KEY autoincrement, question  varchar(300), ans varchar(20))'
cursor.execute(sql)
 
# 提交事物
conn.commit()


# 读取文件里面每一行
with open(path,'r') as f:
    for line in f:
        line1=line
        line2=f.readline()
        data = (line1, line2) # or ['love2', 2221]
        sql = "INSERT INTO TiKu(question, ans) VALUES(?, ?)"
        cursor.execute(sql, data)
                       
f.close()

# 关闭游标
cursor.close()
# 提交事物
conn.commit()
# 关闭连接
conn.close()