连接sqlite3数据库，逐行读取文本文件并插入test.db

import sqlite3
for line in open("jinju.txt"):

    conn = sqlite3.connect('test.db')
    print "Opened database successfully";

    conn.execute("INSERT INTO USER (ID,NAME) \
          VALUES (1, line )");



conn.commit()
print "Records created successfully";
conn.close()

把一个每行为一句话的文本文件jinju.txt逐行读取，insert到一个test.db的数据库，有两个字段ID和USER.