# 1.连接数据库
conn = sqlite3.connect("test.db") #打开或创建数据库文件
print("Opened database successfully")
# 2.创建数据表
conn = sqlite3.connect("test.db") #打开或创建数据库文件
print("成功打开数据库")
c = conn.cursor() #获取游标
sql = '''
create table company
(id int primary key not null, #id 主键 非空
name text not null,
age int not null,
address char(50),
salary real);
'''
c.execute(sql) #执行sql语句
conn.commit() #提交数据库操作
conn.close() #关闭数据库连接
print("成功建表")
# 3.插入数据
conn = sqlite3.connect("test.db") #打开或创建数据库文件
print("成功打开数据库")
c = conn.cursor() #获取游标
sql1 = '''
insert into company (id,name,age,address,salary)
values (1,'张三',32,"成都",8000);
'''
sql2 = '''
insert into company (id,name,age,address,salary)
values (2,'李四',30,"重庆",18000);
'''
c.execute(sql1) #执行sql语句
c.execute(sql2)
conn.commit() #提交数据库操作
conn.close() #关闭数据库连接
print("插入数据完毕")
# 4.查询数据
conn = sqlite3.connect("test.db") #打开或创建数据库文件
print("成功打开数据库")
c = conn.cursor() #获取游标
sql = "select id,name,address,salary from company"
cursor = c.execute(sql) #执行sql语句
for row in cursor:
print("id = ",row[0])
print("name = ", row[1])
print("adress = ", row[2])
print("salary = ", row[3],"\n")
conn.close() #关闭数据库连接
print("查询完毕")
