# -*-coding:utf-8 -*-
# 作者:不懂先生
# 日期: 2021/8/9
import sqlite3
# 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,
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,"重庆",80000)
'''
c.execute(sql) #执行sql语句
conn.commit()#提交数据库操作
conn.close()#关闭数据库链接
print("成功插入")
# 4.查询数据表
# select * from company 在数据表中查询所有数据
# select id,name from company 在数据表表查询单列或多列数据
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("address=", row[2])
print("salary=", row[3],"\n")
conn.close()
print("插入数据完毕")
Last modification:January 18th, 2022 at 04:28 pm
© The copyright belongs to the author