Python操作SQLite3

1、连接数据库

import sqlite3                      #引入包

conn = sqlite3.connect("test.db")   #默认在当前路径创建  打开或者创建数据库文件
print("open database successfully")

2、创建数据表

import sqlite3
conn = sqlite3.connect("test.db")   #默认在当前路径创建  打开或者创建数据库文件
print("成功打开数据库")

c = conn.cursor()      #1获取一个游标

#建表语句
sql = '''
    create table company
        (id int primary key not null,
        name text not null,
        age int not null,
        address char(50),
        salary real);
'''

c.execute(sql)         #2执行sql
conn.commit()          #3提交
conn.close()           #关闭数据过连接

print("成功建表")

3、在2的基础上插入数据

import sqlite3
conn = sqlite3.connect("test.db")   #默认在当前路径创建  打开或者创建数据库文件
print("成功打开数据库")

c = conn.cursor()      #1获取一个游标

#SQL插入语句语法
sql = '''
    insert into company
    (id,name,age,address,salary)
    values(2,"zhangsan",23,"陕西西安",8000)
'''

c.execute(sql)         #2执行sql
conn.commit()          #3提交
conn.close()           #关闭数据过连接

print("插入数据成功")

4、在3的基础上查找数据

import sqlite3
conn = sqlite3.connect("test.db")   #默认在当前路径创建  打开或者创建数据库文件
print("成功打开数据库")

c = conn.cursor()      #1获取一个游标
#SQL查找语句
sql = '''
    select * from company
'''

cursor = c.execute(sql)         #2执行sql

#打印
#print(cursor)
for row in cursor:
    print("id = ",row[0])
    print("name = ",row[1])
    print("age = ",row[2])
    print("address = ",row[3])
    print("salary = ",row[4],"\n")

conn.close()           #关闭数据过连接

print("查询数据成功")

更多操作：https://blog.csdn.net/hhy1107786871/article/details/86540125?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522160024824419725264625847%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=160024824419725264625847&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v2-1-86540125.first_rank_ecpm_v3_pc_rank_v2&utm_term=sqlite3+python&spm=1018.2118.3001.4187