連接sqlite3數(shù)據(jù)庫(kù)

import sqlite3

path = '/static/sqlite3/demo.sqlite3'
// 如果路徑存在這個(gè)sqlite3文件則連接，如果不存在就創(chuàng)建并連接
conn = sqlite3.connect(path)

創(chuàng)建表

conn.execute('''
      CREATE TABLE IF NOT EXISTS People
         (ID INTEGER  PRIMARY KEY NOT NULL,
          Name TEXT NOT NULL,
          Age INT,
          Sex TEXT   
         );
         ''')

增刪改查

add = "insert into People(Name, Age, Sex) values ('陳', 22, '男') "
conn.execute(add)

select = "select * from People"
conn.execute(select)

update = "update People set Name = 'chen' "
conn.execute(update)

deleteData = "delete from People where Name = 'chen' "
conn.execute(deleteData)

dropTable = "drop table People"
conn.execute(dropTable)

所以總的來(lái)說(shuō)需要執(zhí)行sql語(yǔ)句的時(shí)候使用 execute方法執(zhí)行。

最后保存關(guān)閉數(shù)據(jù)庫(kù)

conn.commit()
conn.close()