sqlite3数据库的增删查改

import sqlite3
# 打开或创建sqlite数据库
conn = sqlite3.connect("test.db")
print("opened database successfully")
c = conn.cursor()
# 创建表
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)
conn.commit()
conn.close()
print("成功建表")
# 插入数据
sql1 = '''
    insert into company(id,name,age,address,salary)
    values (1, '张三', 32, '成都', 8000)
'''
sql2 = '''
    insert into company(id,name,age,address,salary)
    values (2, '李四', 32, '成都', 8000)
'''
c.execute(sql1)
c.execute(sql2)
conn.commit()
conn.close()
print("数据插入成功")
# 查
sql3 = '''
    select * from company
'''
jg = c.execute(sql3)
for row in jg:
    print("id = ", row[0])
    print("name = ", row[1])
    print("age = ", row[2])
    print("address = ", row[3])
    print("salary = ", row[4])
conn.commit()
conn.close()
print("查询完毕")