A28010. 学生数据库编写程序操作SQLite数据库，并读出表中的数据。具体要求如下:(1)打开数据库连接(2)清除已存在的表-students;(3)创建一个表students;(4)向新表播入数据;(5)读取表students中数据(本题无需运行通过，写入代码即可)import sqlite3 #打开数据库连接 ('test.db')conn = sqlite3.____①___('test.db') …
填空题
困难
知识点
题目描述
学生数据库
编写程序操作SQLite数据库，并读出表中的数据。
具体要求如下:
(1)打开数据库连接
(2)清除已存在的表-students;
(3)创建一个表students;
(4)向新表播入数据;
(5)读取表students中数据
(本题无需运行通过，写入代码即可)
import sqlite3
#打开数据库连接
('test.db')conn = sqlite3.____①___('test.db')
print("Opend database successfully")
#清除已存在的表 -students
conn.____②___('''DROP TABLE students''');
conn.____③___
#创建一个表students
conn.execute('''___④___students
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL);''')
print("Table created successfully");
conn.commit()
#插入数据
conn.execute("INSERT INTO students(ID,NAME,AGE) VALUES(1,'Allen',25)");
conn.execute("INSERT INTO students(ID,NAME,AGE) VALUES(2,'Maxsu',20)");
conn.execute("INSERT INTO students(ID,NAME,AGE) VALUES(3,'Teddy',24)");
print("Records Insert successfully");
print("-----");
#读取表students
____⑤___=conn.execute("SELECT * from students")
print("ID NAME AGE")
for it in cursor:
for i in range(len(it)):
print(it[i])
print('\n')
conn.close()参考答案
import sqlite3
#打开数据库连接
('test.db')conn = sqlite3.connect('test.db')
print("Opend database successfully")
#清除已存在的表 -students
conn.execute('''DROP TABLE students''');
conn.commit()
#创建一个表students
conn.execute(''' CREATE TABLE students
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL);''')
print("Table created successfully");
conn.commit()
#插入数据
conn.execute("INSERT INTO students(ID,NAME,AGE) VALUES(1,'Allen',25)");
conn.execute("INSERT INTO students(ID,NAME,AGE) VALUES(2,'Maxsu',20)");
conn.execute("INSERT INTO students(ID,NAME,AGE) VALUES(3,'Teddy',24)");
print("Records Insert successfully");
print("-----");
#读取表students
cursor=conn.execute("SELECT * from students")
print("ID NAME AGE")
for it in cursor:
for i in range(len(it)):
print(it[i])
print('\n')
conn.close()
上一题
下一题