#I wrote a simple python program that creates a database with sqlite3 and a GUI with Tkinter. #It won't be useful except as reference for me.
from Tkinter import *
import sqlite3
def makedatabase():
conn=sqlite3.connect('mydb.db')
cur=conn.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS atable(name string, phone string)")
cur.execute("INSERT INTO atable VALUES('Stephany','123-1234')")
thedata=cur.execute("SELECT * FROM atable")
for line in thedata:
print line[0]
print line[1]
root=Tk()
btn=Button(root,text="Run ",command=makedatabase)
btn.pack()
root.mainloop()
This is a personal record of my python programming experiences. It will allow me to see how I am progressing as I learn a new language.
Subscribe to:
Post Comments (Atom)
Followers
Blog Archive
- June (1)
- March (3)
- February (1)
- July (3)
- May (1)
- April (1)
- March (1)
- January (1)
- December (1)
- November (4)
- July (3)
- May (2)
- April (1)
- March (6)
- February (2)
- December (1)
- November (1)
- September (3)
- August (3)
- July (1)
- March (3)
- January (1)
- December (5)
- November (2)
- October (1)
- September (2)
- August (1)
- July (4)
- May (3)
- February (1)
- January (1)
- December (1)
- November (2)
- October (2)
- September (9)
- August (2)
- May (1)
- April (1)
- March (6)
- February (5)
- January (3)
- August (2)
No comments:
Post a Comment