在图书馆管理系统中，有一个列表 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()