#-*- codeing = utf-8 -*-
#@Time : 2020-07-21 9:33
#@Author : 姚云峰
#@File : testSqlite.py
#@Software : PyCharm
import sqlite3
# 创建数据库
# conn = sqlite3.connect("test.db") # 打开或创建数据库文件
# print("数据库打开成功")
#
# 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) # 执行sql御酒
#
# conn.commit() # 提交数据库
#
# conn.close() # 关闭数据库
#
# print("建表成功")
# 插入数据
#
# conn = sqlite3.connect("test.db") # 打开或创建数据库文件
# print("数据库打开成功")
#
# c = conn.cursor() # 获取游标
#
# sql1 = '''
#
# insert into company (id , name , age , address , salary)
# values (3 , '王五' , 32 , '天堂' , 5555)
#
# '''
#
# sql2 = '''
#
# insert into company (id , name , age , address , salary)
# values (2 , '李四' , 62 , '城南' , 15615)
#
# '''
#
# c.execute(sql1) # 执行sql御酒
# c.execute(sql2) # 执行sql御酒
#
# conn.commit() # 提交数据库
#
# conn.close() # 关闭数据库
# print("插入数据成功")
# 查询数据
conn = sqlite3.connect("test.db") # 打开或创建数据库文件
print("数据库打开成功")
c = conn.cursor() # 获取游标
sql = '''
select * from company;
'''
cursor = c.execute(sql) # 执行sql御酒
for row in cursor:
print(row)
conn.close() # 关闭数据库
print("查询完毕成功")