学习笔记（11):Python 面试100讲（基于Python3.x）-操作SQLite数据库

立即学习: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)