language: Python (python 2.7.3)
date: 394 days 8 hours ago
link:
visibility: public 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

#!/usr/bin/python
# -*- coding: utf-8 -*-
from Tkinter import *
import MySQLdb
 
def tran():
    first = Tk()
    label1 = Label(first, text='From')
    label1.pack()
    box1 = Entry(first)
    box1.pack()
    label2 = Label(first, text='To')
    label2.pack()
    box2 = Entry(first)
    box2.pack()
    label3 = Label(first, text='Amt')
    label3.pack()
    box3 = Entry(first)
    box3.pack()
    Button1 = Button(first, text='Next', command=func3).pack()
 
def func3():
    conn = MySQLdb.connect(host='localhost', user='root', passwd='natty'
                           , db='dbms')
    cursor = conn.cursor()
    From = int(box1.get().strip())
    To = int(box2.get().strip())
    Amt = int(box3.get().strip())
    cursor.execute('select bal from account where acc=' + str(From) + ''
                   )
    a = cursor.fetchone()
    fromval = int(a[0])
    cursor.execute('select bal from account where acc=' + str(To) + '')
    b = cursor.fetchone()
    toval = int(b[0])
    fromval = fromval - Amt
    toval = toval + Amt
    cursor.execute('update account set bal=' + str(fromval)
                   + ' where acc=' + str(From) + '')
    cursor.execute('update account set bal=' + str(toval)
                   + ' where acc=' + str(To) + '')
    cursor.close()
    conn.close()
 
master = Tk()
Button3 = Button(master, text='Transaction', command=tran).pack()
mainloop()