单选题

执行以下代码,数据表中共有几条数据? (    )

import sqlite3 

conn=sglite3.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()

A

2

B

3

C

4

D

5

赣ICP备20007335号-2