功能介绍：
查询数据库表数据，提取数据并显示
main.py（执行文件）
#coding:gbk
__author__ = 'Hito'
import querySmscode
import wx
class MyFrame( wx.Frame ):
def __init__( self):
wx.Frame.__init__(self,None,-1, 'SMSCODE',(-1,-1),wx.Size(350,300))
code=querySmscode.querySmscode()
panel = wx.Panel(self,-1)
smsCodeBox = wx.BoxSizer( wx.HORIZONTAL )
head=wx.StaticText(panel, 1,"Phone\t\tSmscode",(120,10),(200, -1), wx.ALIGN_CENTER)
self.content=wx.TextCtrl(panel, 2,code,(120,35),(300, -1), style = wx.TE_MULTILINE|wx.TE_READONLY)
self.Refresh = wx.Button(panel,3,u"查询")
wx.EVT_BUTTON(self,3,self.show_Smscode)
sizer = wx.FlexGridSizer(rows=3,cols=1, hgap=6, vgap=6)
sizer.AddMany([(head,0,wx.ALIGN_CENTER), (self.content,0,wx.ALIGN_CENTER),(self.Refresh,0,wx.ALIGN_CENTER)])
smsCodeBox.Add(sizer, proportion=1, flag=wx.ALL|wx.EXPAND, border=15)
panel.SetSizer(smsCodeBox)
self.Center()
def show_Smscode(self,event):
self.Refresh.SetLabel(u"查询中...")
code=querySmscode.querySmscode()
self.content.SetValue(code)
self.Refresh.SetLabel(u"查询")
if __name__ == "__main__":
app = wx.App()
frame = MyFrame()
frame.Show()
app.MainLoop()
querySmscode.py
#coding:gbk__author__ = 'yanghaitao'import pymssqlimport ConfigParser,oscf = ConfigParser.ConfigParser()cf.read('./smscode.ini')HOST=cf.get("DB_CONFIG","host")DATABASE=cf.get("DB_CONFIG","database")USER=cf.get("DB_CONFIG","user")PASSWORD=cf.get("DB_CONFIG","password")def querySmscode(n=20): result='' count=0 sql='SELECT TOP %d * FROM SMScode ORDER BY Id DESC '%n result_list=getData(sql) for i in range(n): if str(result_list[i][3]) != 'None' and count<10 and len(str(result_list[i][3])) == 4: count=count+1 result=result + str(result_list[i][1])+'\t'+str(result_list[i][3])+'\t'+str(result_list[i][2])[0:19]+'\n' return result
def getData(sql): #执行数据库查询函数 conn=pymssql.connect(host=HOST,user=USER,password=PASSWORD,database=DATABASE,charset="UTF-8") cou=conn.cursor() cou.execute(sql) result = cou.fetchall() conn.commit() conn.close() return result
smscode.ini（数据库配置文件，具体的读写操作，可参考http://www.cnblogs.com/hito/p/4651647.html）
[DB_CONFIG] host = XXX.XXX.X.X database = 数据库名 user = 账号 password = 密码