好的，我来为您解答这个问题。
首先，您需要下载并安装MySQL数据库，并安装MySQL-connector模块。然后，您可以使用以下代码连接到MySQL数据库：
```python
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="yourdatabase"
)
mycursor = mydb.cursor()
```
接下来，您可以使用以下代码创建admin和sales表：
```python
mycursor.execute("CREATE TABLE admin (id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(255), password VARCHAR(255))")
mycursor.execute("CREATE TABLE sales (id INT AUTO_INCREMENT PRIMARY KEY, time VARCHAR(255), buyer VARCHAR(255), brand VARCHAR(255), model VARCHAR(255), price INT)")
```
然后，您可以使用以下代码查询sales表：
```python
def query_sales(time=None, buyer=None, brand=None, model=None, price=None):
query = "SELECT * FROM sales WHERE 1=1"
if time:
query += " AND time='%s'" % time
if buyer:
query += " AND buyer='%s'" % buyer
if brand:
query += " AND brand='%s'" % brand
if model:
query += " AND model='%s'" % model
if price:
query += " AND price=%d" % price
mycursor.execute(query)
result = mycursor.fetchall()
if not result:
return "查询不到记录"
return result
```
最后，您可以使用以下代码设计一个窗体来查询sales表：
```python
from tkinter import *
def search_sales():
time = time_entry.get()
buyer = buyer_entry.get()
brand = brand_entry.get()
model = model_entry.get()
price = price_entry.get()
result = query_sales(time, buyer, brand, model, price)
result_label.config(text=result)
root = Tk()
Label(root, text="时间：").grid(row=0, column=0)
time_entry = Entry(root)
time_entry.grid(row=0, column=1)
Label(root, text="买家：").grid(row=1, column=0)
buyer_entry = Entry(root)
buyer_entry.grid(row=1, column=1)
Label(root, text="品牌：").grid(row=2, column=0)
brand_entry = Entry(root)
brand_entry.grid(row=2, column=1)
Label(root, text="型号：").grid(row=3, column=0)
model_entry = Entry(root)
model_entry.grid(row=3, column=1)
Label(root, text="价格：").grid(row=4, column=0)
price_entry = Entry(root)
price_entry.grid(row=4, column=1)
Button(root, text="查询", command=search_sales).grid(row=5, column=0)
result_label = Label(root, text="")
result_label.grid(row=6, column=0, columnspan=2)
root.mainloop()
```
这样就完成了设计汽车数据库并查询sales表的过程。
扫一扫
121
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
