执行以下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()
2
3
4
5