import sqlite3

# 導入SQLite驅動:
import sqlite3
# 連接到SQLite數(shù)據(jù)庫
# 數(shù)據(jù)庫文件是test.db
# 如果文件不存在，會自動在當前目錄創(chuàng)建:
conn = sqlite3.connect('test.db')
# 創(chuàng)建一個Cursor:
cursor = conn.cursor()
# 執(zhí)行一條SQL語句，創(chuàng)建user表:
cursor.execute('create table user (id varchar(20) primary key, name varchar(20))')


# 繼續(xù)執(zhí)行一條SQL語句，插入一條記錄:
cursor.execute('insert into user (id, name) values (\'1\', \'Michael\')')


# 通過rowcount獲得插入的行數(shù):
print(cursor.rowcount)


# 關閉Cursor:
cursor.close()
# 提交事務:
conn.commit()
# 關閉Connection:
conn.close()

execute()--執(zhí)行sql語句   
executemany--執(zhí)行多條sql語句   
close()--關閉游標   
fetchone()--從結果中取一條記錄，并將游標指向下一條記錄   
fetchmany()--從結果中取多條記錄   
fetchall()--從結果中取出所有記錄   
scroll()--游標滾動  

cursor.execute('create table user (id varchar(20) primary key, name varchar(20))')

CREATE TABLE "main"."test" (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT
);

cursor.execute('insert into user (id, name) values (\'1\', \'Michael\')')

fetchone()--從結果中取一條記錄，并將游標指向下一條記錄   
fetchmany()--從結果中取多條記錄   
fetchall()--從結果中取出所有記錄   

cursor.execute("select count(*) from user")
print(cursor.fetchone())
# (2,)

cursor.execute("select * from user")
print(cursor.fetchall())
# [('1', 'Michael'), ('2', 'Danny')]

cursor.execute("select * from user")
print(cursor.fetchone())
# ('1', 'Michael')

cursor.execute("select * from user LIMIT 1, 2")
print(cursor.fetchall())

cursor.execute("update user set name='test' where id='1'")

cursor.execute("delete from catalog where id = 4")