74 lines
968 B
Python
74 lines
968 B
Python
import sqlite3
|
|
|
|
# 创建或者链接数据库
|
|
conn = sqlite3.connect('test.db')
|
|
|
|
# 创建游标
|
|
c = conn.cursor()
|
|
|
|
#########################
|
|
|
|
# 数据库创建表 datas
|
|
# id, name, date
|
|
|
|
sql = '''
|
|
CREATE TABLE IF NOT EXISTS datas (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
name VARCHAR(255),
|
|
date VARCHAR(255)
|
|
)
|
|
'''
|
|
|
|
c.execute(sql)
|
|
|
|
#########################
|
|
|
|
|
|
def get_datas():
|
|
sql = '''
|
|
SELECT * FROM datas
|
|
'''
|
|
|
|
c.execute(sql)
|
|
datas = c.fetchall()
|
|
|
|
print(datas)
|
|
|
|
#########################
|
|
|
|
# 插入数据
|
|
|
|
|
|
sql = '''
|
|
INSERT INTO datas (name, date) VALUES ('张三', '2019-01-01')
|
|
'''
|
|
|
|
c.execute(sql)
|
|
conn.commit()
|
|
|
|
get_datas()
|
|
|
|
#########################
|
|
|
|
# 修改数据
|
|
sql = '''
|
|
UPDATE datas SET name='李四' WHERE id=1
|
|
'''
|
|
|
|
c.execute(sql)
|
|
conn.commit()
|
|
|
|
get_datas()
|
|
|
|
#########################
|
|
|
|
# 删除数据
|
|
sql = '''
|
|
DELETE FROM datas WHERE id=1
|
|
'''
|
|
|
|
c.execute(sql)
|
|
conn.commit()
|
|
|
|
get_datas()
|