<p>您应该创建一个用于验证登录详细信息的函数。这是如何验证登录详细信息的,它应该位于函数内部:</p>
<pre><code> try:
username = input("your username")
password = input("your password")
conn = (your connection code);
result = conn.execute("SELECT * FROM yourTable WHERE usernameColumnOfYourTable = ? AND passwordColumnOFyourTable = ?", (username, password))
print("connected to database")
if (len(result.fetchall()) > 0):
print("user found")
else:
print("user not found")
except Exception as err:
print("couldn't connect")
print("General error :: ", err)
</code></pre>
<p>注:?是pyodbc模块的参数标记,如果使用mysql连接器,请替换?用%s签名</p>
<p>但是,如果您使用的是散列(salt)密码,则格式会有所不同</p>
<p>将此逻辑应用于代码:</p>
<pre><code> def login():
connection = (establish your database connection here)
login_username = input("Please enter your username or email: ")
login_password = input("Please enter your password: ")
result = connection.execute("SELECT username FROM users WHERE username = ? AND password = ?",(login_username, login_password) )"
if (len(result.fetchall()) > 0):
print("Logged in successfully")
else:
print("Login failed, wrong username or password")
</code></pre>