java数据库字典用法_如何从数据库中返回字典？

我编写了访问数据库的函数 .

名为 Books 的表具有：

- a `book_id` TEXT column,

- a title TEXT column, and

- an author TEXT column.

对于第一个， run_query 是连接数据库的函数 .

get_book_cnt_per_author 是一个以这种形式返回元组列表的函数：

'author', number of books

我不知道如何通过循环使用 run_query 函数 . 因为我写的东西，我总是得到 None .

我不知道我的问题在哪里 . 我只为每位作者收到一本书 .

请告诉我这是什么问题 .

def get_books(db，book_cnt_list，book_cnt)：“”“(str，tuple列表，int) - > str列表

Precondition: the elements in book_cnt_list are sorted

in ascending order by author name.

Return a list of all the book titles whose authors

each have book_cnt books in the database with name db

according to the book_cnt_list. The book titles should be in

ascending order for each author, but not for the entire list.

Follow ascending order across authors, that is, the order

authors appear in book_cnt_list that is already sorted by

author name.

>>> author_cnt_list = get_book_cnt_per_author("e7_database.db")

>>> books_list = get_books("e7_database.db", author_cnt_list, 10)

>>> books_list[0]

'A Christmas Carol'

>>> books_list[9]

'The Life and Adventures of Nicholas Nickleby'

>>> books_list[10]

'Disgrace'

>>> books_list[-1]

'Youth'

"""

# HINT: First figure out which authors have book_cnt books

# using the book_cnt_list. Then, access the database db

# to retrieve the required information for those authors.

# Do not call any other of your E7 functions other than run_query.

list1 = []

for i in book_cnt_list:

if i[1] == "book_cnt":

list1.append(i[0])

for j in list1:

return run_query(my_db, '''SELECT title FROM Books OREDER BY Books.title ASC WHERE Books.author = ? ''', (j))

def create_author_dict(db)：“”“(str) - > {str：list of str}的字典

Return a dictionary that maps each author to the books they have written

according to the information in the Books table of the database

with name db.

>>> author_dict = create_author_dict('e7_database.db')

>>> author_dict['Isaac Asimov'].sort()

>>> author_dict['Isaac Asimov']

['Foundation', 'I Robot']

>>> author_dict['Maya Angelou']

['I Know Why the Caged Bird Sings']

"""

con = sqlite3.connect(db)

cur = con.cursor()

cur.execute('''SELECT author, title FROM Books WHERE Books.author = ?''')

new_list = cur.fetchall()

new_dict = {}

for i in new_list:

key = i[0]

value = i[1:]

new_dict.update({key: list(value)})

con.commit()

cur.close()

con.close()

return new_dict