conn = sqlite3.connect('test.db')#打开或创建数据库文件
c = conn.cursor()#获取游标#sql语句,创建company表格
sql ='''
create table company
(id integer not null primary key autoincrement,
name text not null,
age int not null,
address char(50),
salary real);
'''
c.execute(sql)#执行sql语句
conn.commit()#提交数据库操作
c.close()#关闭游标
conn.close()#关闭数据库连接
3.插入数据
conn = sqlite3.connect('test.db')#打开或创建数据库文件
c = conn.cursor()#获取游标
sql ='insert into company(name, age, address, salary) values ("张三",32,"成都",8000)'#自增id,可以不用加#sql = 'insert into company(id, name, age, address, salary) values (2,"张三",32,"成都",8000)'
c.execute(sql)#执行sql语句
conn.commit()#提交数据库操作
c.close()#关闭游标
conn.close()#关闭数据库连接'''
采集数据一般写法
data = [2,"张三",32,"成都",8000]
sql = 'insert into company (id, name, age, address, salary) value (%s)'%','.join(data)
'''
4.查询
conn = sqlite3.connect('test.db')#打开或创建数据库文件
c = conn.cursor()#获取游标#sql = 'select id,name,address,salary from company'
sql ='select * from company'
data = c.execute(sql)for d in data:print(d)print('id',d[0])print('name',d[1])print('address',d[2])print('salary',d[3])print('---------------------------------')
c.close()#关闭游标
conn.close()#关闭数据库连接