数据库操作
编写一个Python程序,实现以下功能:
(1)连接到SQLite数据库company.db;
(2)创建一个名为"employees"的表,包含id(主键)、name、salary字段;
(3)插入3条员工记录;
(4)查询并打印所有salary大于5000的员工;
(5)更新其中一条记录的salary;
(6)删除一条记录。
请根据要求,补全代码。
(本题无需运行通过,写入代码即可)
import sqlite3
conn = sqlite3. ① ('company.db')
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE IF NOT EXISTS employees (
id id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
salary REAL
)
''')
②
cursor.executemany('INSERT INTO employees VALUES(?,?,?)'', ③ )
conn.commit()
print("薪资大于5000的员工:")
cursor.execute('SELECT * FROM employees WHERE ④ ')
for row in ⑤ :
print(row)
cursor.execute(' UPDATE employees SET salary = 5500 WHERE id = 1')
conn.commit()
cursor.execute('DELETE FROM employees WHERE id = 2')
conn.commit()
conn.close()