import sqlite3

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


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


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


# 關(guān)閉Cursor:
cursor.close()
# 提交事務(wù):
conn.commit()
# 關(guān)閉Connection:
conn.close()

execute()--執(zhí)行sql語(yǔ)句   
executemany--執(zhí)行多條sql語(yǔ)句   
close()--關(guān)閉游標(biāo)   
fetchone()--從結(jié)果中取一條記錄，并將游標(biāo)指向下一條記錄   
fetchmany()--從結(jié)果中取多條記錄   
fetchall()--從結(jié)果中取出所有記錄   
scroll()--游標(biāo)滾動(dòng)  

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()--從結(jié)果中取一條記錄，并將游標(biāo)指向下一條記錄   
fetchmany()--從結(jié)果中取多條記錄   
fetchall()--從結(jié)果中取出所有記錄   

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")