我有用 tkinter、python 編寫的小應用程序。我想通過單擊 tkinter 中的按鈕來選擇 txt 文件并自動將其發(fā)送到我的 SQL 數(shù)據(jù)庫。此刻，我有負責從我的光盤中選擇一個文件并在控制臺中打印我的 txt 文件的功能：def OpenFile(): name = askopenfilename(initialdir="", filetypes =(("Text File", "*.txt"),("All Files","*.*")), title = "Choose a file." ) print(name) #Using try in case user types in unknown file or closes without choosing a file. try: with open(name,'r') as UseFile: print(UseFile.read()) except: print("No file exists")負責發(fā)送到 SQL 的函數(shù)看起來是這樣的（txt 文件插入函數(shù)內(nèi)部）：def Tabela(): with open("pom1.txt") as infile: for line in infile: data = line.split("\t") print(data) query = ("INSERT INTO Pomiary_Obwod_90(Pomiar_x, Pomiar_y, Pomiar_z) VALUES" "(" + data[1] + ", " + data[2] + ", " + data[3] + ");") cursor.execute(query, data) con.commit() return有誰知道我可以做些什么來連接這兩個功能？這個想法是從函數(shù) OpenFile() 中選擇 txt 文件，然后應用程序應自動將其發(fā)送到數(shù)據(jù)庫。
1 回答
拉丁的傳說
TA貢獻1789條經(jīng)驗 獲得超8個贊
將Tabela文件作為參數(shù)而不是硬編碼pom1.txt，并Tabela(UseFile)從OpenFile().
此外，由于您cursor.execute()使用參數(shù)調(diào)用，因此不應連接datainto的元素query，只需在查詢中放置占位符。
def OpenFile():
name = askopenfilename(initialdir="",
filetypes =(("Text File", "*.txt"),("All Files","*.*")),
title = "Choose a file."
)
print(name)
#Using try in case user types in unknown file or closes without choosing a file.
try:
with open(name,'r') as UseFile:
Tabela(UseFile)
except:
print("No file exists")
def Tabela(infile):
for line in infile:
data = line.strip().split("\t")
print(data)
query = ("INSERT INTO Pomiary_Obwod_90(Pomiar_x, Pomiar_y, Pomiar_z) VALUES (%s, %s, %s)")
cursor.execute(query, data)
con.commit()
return
添加回答
舉報
0/150
提交
取消