第12093题 单选
Python使用sqlite3库批量插入new_books中所有书籍信息到books表的正确代码是以下哪项?

在图书馆管理系统中,已知书籍列表:new_books = [('Book 1', 'Author 1'), ('Book 2', 'Author 2')],需要将列表中所有书籍信息插入到books表中。

A
import sqlite3
conn = sqlite3.connect('library.db')
cursor = conn.cursor()
cursor.executemany('INSERT INTO books (title, author) VALUES (?, ?)', new_books)
conn.commit()
conn.close()
B
import sqlite3
conn = sqlite3.connect('library.db')
cursor = conn.cursor()
cursor.execute('INSERT INTO books (title, author) VALUES (?, ?)', new_books)
conn.commit()
conn.close()
C
import sqlite3
conn = sqlite3.connect('library.db')
cursor = conn.cursor()
cursor.executemany('INSERT INTO books (title, author) VALUES (?, ?)', new_books[0])
conn.commit()
conn.close()
D
import sqlite3
conn = sqlite3.connect('library.db')
cursor = conn.cursor()
cursor.execute('INSERT INTO books (title, author) VALUES (?, ?)', new_books[0])
conn.commit()
conn.close()