如何用tkinter做一个连接数据库的小程序
时间: 2024-01-29 15:04:29 浏览: 27
可以按照以下步骤使用tkinter创建一个连接数据库的小程序:
1. 导入tkinter和sqlite3库
```python
import tkinter as tk
import sqlite3
```
2. 创建一个tkinter窗口
```python
root = tk.Tk()
root.title("连接数据库")
```
3. 创建输入框和标签用于输入数据库名称和表名
```python
db_name_label = tk.Label(root, text="数据库名称:")
db_name_label.grid(row=0, column=0)
db_name_entry = tk.Entry(root)
db_name_entry.grid(row=0, column=1)
table_name_label = tk.Label(root, text="表名:")
table_name_label.grid(row=1, column=0)
table_name_entry = tk.Entry(root)
table_name_entry.grid(row=1, column=1)
```
4. 创建一个函数用于连接数据库
```python
def connect_database():
db_name = db_name_entry.get()
table_name = table_name_entry.get()
conn = sqlite3.connect(db_name)
cursor = conn.cursor()
cursor.execute(f"SELECT * FROM {table_name}")
rows = cursor.fetchall()
for row in rows:
print(row)
conn.close()
```
5. 创建一个按钮用于连接数据库
```python
connect_button = tk.Button(root, text="连接数据库", command=connect_database)
connect_button.grid(row=2, column=1)
```
6. 运行tkinter窗口
```python
root.mainloop()
```
完整代码示例:
```python
import tkinter as tk
import sqlite3
root = tk.Tk()
root.title("连接数据库")
db_name_label = tk.Label(root, text="数据库名称:")
db_name_label.grid(row=0, column=0)
db_name_entry = tk.Entry(root)
db_name_entry.grid(row=0, column=1)
table_name_label = tk.Label(root, text="表名:")
table_name_label.grid(row=1, column=0)
table_name_entry = tk.Entry(root)
table_name_entry.grid(row=1, column=1)
def connect_database():
db_name = db_name_entry.get()
table_name = table_name_entry.get()
conn = sqlite3.connect(db_name)
cursor = conn.cursor()
cursor.execute(f"SELECT * FROM {table_name}")
rows = cursor.fetchall()
for row in rows:
print(row)
conn.close()
connect_button = tk.Button(root, text="连接数据库", command=connect_database)
connect_button.grid(row=2, column=1)
root.mainloop()
```