立即学习:https://edu.csdn.net/course/play/26755/340154?utm_source=blogtoedu
题一:如何创建SQLite数据库
# create table and database
import sqlite3
import os
dbPath = 'data.sqlite'
if not os.path.exists(dbPath):
conn = sqlite3.connect(dbPath)
c = conn.curson()
c.execute('''create table persons
(id int primary key not null,
name text not null,
age int not null,
address char(100),
salary real);''')
conn.commit()
conn.close()
print('创建数据库成功')
题二:如何向SQLite表中插入数据
#2.insert
conn = sqlite3.connect(dbPath)
c.execute('delete from persons')
c.execute(''' insert into persons(id,name,age,address,salary)values(1,'Bill',32,'California',20000)''')
c.execute(''' insert into persons(id,name,age,address,salary)values(2,'Mike',30,'texas',10000)''')
c.execute(''' insert into persons(id,name,age,address,salary)values(3,'John',54,'Norway',30000)''')
conn.commit()
print('insert success')
题三:如何查询SQLite表中的数据
persons = c.execute('select name, age,address,salary from persons order by age')
print(type(persons))
result = []
for person inpersons:
value = {}
value['name'] = person[0]
value['age'] = person[1]
value['name'] = person[2]
result.append(value)
conn.close()
print(type(result))
print(result)
import json
resultStr = json.dumps(result)
print(resultStr)