SqLite Demo

import sqlite3

# #打开或创建数据库文件
# conn = sqlite3.connect("test.db")
#
# #获取游标
# 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);
# '''
#
# #执行sql语句
# c.execute(sql)
#
# #提交数据库操作
# conn.commit()
#
# #关闭数据库连接
# conn.close()
#
# print("Opened database successfully")

# #插入数据
# #打开或创建数据库文件
# conn = sqlite3.connect("test.db")
#
# #获取游标
# c = conn.cursor()
#
# sql = '''
#     insert into company(id, name,age,address,salary)
#     values(1,'zhangSan',32,'程度',800)
# '''
#
# #执行sql语句
# c.execute(sql)
#
# #提交数据库操作
# conn.commit()
#
# #关闭数据库连接
# conn.close()
#
# print("Opened database successfully")

#查询数据
#插入数据
#打开或创建数据库文件
conn = sqlite3.connect("test.db")

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

sql = '''
    select id,name,address,salary from company
'''

cursor = c.execute(sql)

for row in cursor:
    print("id= ",row[0])
    print("name= ",row[1])
    print("address= ", row[2])
    print("salary= ",row[3])


#执行sql语句
c.execute(sql)

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

print("Opened database successfully")