pysozluk.JPG
Bu da python versiyonu.Calismasi icin mysqldb modulunun yuklu olmasi gerekiyor.
Ben kendi makinemde turkce karakter problemi yasadim.Deneyen varsa sorun olup olmadigini bildirirse sevinirim.
Kod:
# -*- coding: windows-1254 -*-
import MySQLdb
from Tkinter import *
# Kelime arayici fonksiyon
def ara():
global imlec,e1
aranan = e1.get()
imlec.execute("SELECT * FROM sozluk_tr2en WHERE sozluk_tr2en_kelime = '"+ aranan +"' UNION SELECT * FROM sozluk_en2tr WHERE sozluk_en2tr_kelime = '"+aranan+"' ")
anlam = str(imlec.fetchall()).split("'")[3]
if anlam:
sonuc.delete(1.0,10.0)
sonuc.insert(INSERT,anlam)
else:
sonuc.delete(1.0,10.0)
sonuc.insert(INSERT,"bulunamadi")
try:
# mySQL baglantisi
db = MySQLdb.connect("localhost", "root", "", "sozluk")
imlec = db.cursor()
# Turkce encoding icin
imlec.execute("SET NAMES 'latin5'")
imlec.execute("SET CHARACTER SET latin5")
imlec.execute("SET COLLATION_CONNECTION = 'latin5_turkish_ci'")
except:
print 'mysql baglantisi yok'
sys.exit()
# Tkinter on the fly!
root = Tk()
root.title(' PySozluk ')
Label(root, text="Kelime").grid(row=0,column=1)
b = Button(root, text="Bul", width=25, command=ara).grid(row=2,column=1)
e1 = Entry(root,width=25)
e1.grid(row=1, column=1)
sonuc = Text(root,width=25,height=10)
sonuc.grid(row=3,column=1)
root.mainloop()
Bookmarks