我是编程新手,正在尝试理解如何从SQLLite中划出一条信息线,其中唯一的因素恰好是用户名
import sqlite3
conn=sqlite3.connect("customer database.db")
#line 7 and 9 needed to connect sql database in between
#will show the lines of information they want retrieve
cursor=conn.cursor()
#is just necessary step
userlogin=input("please login")
#line of logic does not compute to python but works directly in SQL
sqlgetcus = f"SELECT * FROM Customer WHERE username is "{userlogin}""
cursor.execute(sqlgetcus)
row=cursor.fetchone()
assert row[0]== userlogin
print(row)
无法真正测试其余部分,但我认为这就是问题所在: 你写道:
但你真正想做的是:
相关问题 更多 >
编程相关推荐