抱歉,如果这看起来太简单了,但刚刚开始编码,似乎找不出问题是什么。我已经用用户输入的变量替换了硬编码的值,数据正在保存到数据库中,但我似乎无法将其显示出来。我的cur.execute选择行有误吗?
import sqlite3
conn = sqlite3.connect("OS_Employee.db")
with conn:
cur = conn.cursor()
try:
ID = input("Please enter your Employee ID: ")
FirstName = input("Please enter your First Name: ")
LastName= input("Please enter your Last Name: ")
Email = input("Please enter your Employee Email: ")
Password = input("Please enter your Desired Password: ")
cur.execute ("""INSERT INTO Employee VALUES (?, ?, ?, ?, ?)""",
(ID, FirstName, LastName, Email, Password))
cur.execute("SELECT EmployeeID FROM Employee WHERE (EmployeeID = ?", (ID, ))
results = cur.fetchall()
print(results)
except:
print("Connection Failed")enter code here
如果缩进看起来很奇怪,它只出现在stackoverflow上,因为我知道如何让它正确粘贴,在实际代码中没有缩进错误。谢谢!
发布于 2018-10-17 03:33:26
尝试替换您的线路:
cur.execute("SELECT EmployeeID FROM Employee WHERE (EmployeeID = ?", (ID, ))
通过以下方式:
cur.execute("SELECT EmployeeID FROM Employee WHERE EmployeeID = ?", (ID, ))
看起来您的括号不匹配。
https://stackoverflow.com/questions/52842761
复制相似问题