擅长:python、mysql、java
<pre><code>from easygui import *
import mysql.connector
TITLE = "Enter logon information"
conn = ""
table = ""
def Login():
global conn
conn = mysql.connector.connect(host='localhost',user='pi',password='1234',db='mydb')
cursor = conn.cursor()
msg = "Enter logon information"
title = "Login"
fieldNames = ["Usercode","Password"]
fieldValues = []
fieldValues = multpasswordbox(msg,title,fieldNames)
usercode, password = fieldValues[0], fieldValues[1]
sql = "SELECT * FROM `data` WHERE usercode = %s AND password = %s"
cursor.execute(sql,(usercode,password))
results = cursor.fetchall()
Login()
</code></pre>