Python 类 SQLite3 请求返回对象 [英] Python Class SQLite3 request returns object

问题描述

我有一个数据库，我想在其中创建一个名为 Employee 的类，只提供 empid 并从数据库中获取其余部分.

I have a database where I want to make a class called Employee, giving only the empid and getting the rest from a database.

    def__init__(self, empid):
    conn = sqlite3.connect("employee.db")
    cur = conn.cursor()
    self.empid = empid
    self.name = cur.execute("SELECT name FROM employees WHERE empid = " + str(empid))
    self.bday = cur.execute("SELECT bday FROM employees WHERE empid = " + str(empid))

只有它不返回值，而是在我打印时返回一个对象.

Only it does not return the values, rather an object when I print it.

<sqlite3.Cursor object at 0x104687c00> <sqlite3.Cursor object at 0x104687c00>

我该如何解决这个问题?

How do I resolve this?

推荐答案

正确.执行查询后调用fetchone

cur.execute("SELECT name FROM employees WHERE empid = ?", (empid,))
self.name = cur.fetchone()[0]
cur.execute("SELECT bday FROM employees WHERE empid = ?",(empid,))
self.bday = cur.fetchone()[0]

但实际上，这样更好

cur.execute("SELECT name, bday FROM employees WHERE empid = ?", (empid,))
self,name, self.bday = cur.fetchone()

这篇关于Python 类 SQLite3 请求返回对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！