A59992. 执行以下Python代码,数据表中共有几条数据?( )import sqlite3
单选题
知识点
题目描述
执行以下Python代码,数据表中共有几条数据?( )
import sqlite3
conn = sqlite3.connect('student_info.db')
cursor = conn.cursor()
cursor.execute('''CREATE TABLE IF NOT EXISTS Student
(id INTEGER PRIMARY KEY, name TEXT, age INTEGER)''')
cursor.execute("INSERT INTO Student (id, name, age) VALUES (1, 'Alice', 20)")
cursor.execute("INSERT INTO Student (id, name, age) VALUES (2, 'Bob', 22)")
cursor.execute("INSERT INTO Student (id, name, age) VALUES (3, 'Charlie', 21)")
cursor.execute("SELECT * FROM Student")
students = cursor.fetchall()
for student in students:
print(f"ID: {student[0]}, Name: {student[1]}, Age: {student[2]}")
cursor.execute("UPDATE Student SET age = 23 WHERE id = 2")
cursor.execute("DELETE FROM Student WHERE id = 3")
conn.commit()
conn.close()选项(单选)
答案解析
详细答案解析为会员权益,按每日次数查看。
开通 / 升级会员