- 论坛徽章:
- 0
|
小小实例- # coding=utf-8
- import sqlite3 as db
- try:
- from Tkinter import *
- from tkMessageBox import *
- MODE = True
- except ImportError:
- MODE = False
-
- con = None
- def get_cars(ui_demo=True):
- try:
- con = db.connect(':memory:')
- cur = con.cursor()
- cur.execute("CREATE TABLE car(id INT, name TEXT)")
- cars = [u"兰博',基尼",u"马萨'拉蒂",u"法布雷加斯"]
- for i in range(len(cars)):
- cur.execute("INSERT INTO car VALUES(?,?)",(i,cars[i]))
- cur.execute("SELECT * FROM car")
- data = cur.fetchall()
- msg = ""
- for each in data:
- msg = msg + "id={0}, name={1} \n"\
- .format(each[0], each[1].encode('utf-8'))
- if ui_demo:
- showinfo(u"汽车",msg)
- else:
- print msg
-
- except db.Error as e:
- print e
- finally:
- if con:
- con.close()
- if MODE:
- root = Tk()
- root.title("sqlite")
- root.geometry("200x50")
- Button(root, text="汽车", command=lambda:get_cars(MODE)).pack()
- root.mainloop()
- else:
- get_cars(MODE)
复制代码 |
|