需下載LIB: http://pymssql.sourceforge.net/ 環境: python 2.6 mssql 2008 import httplib from string import split import pymssql exchangeURL = "somebank.com.tw" exchangePage = "/exchange/IP003.zh-TW.htm" sqlAddr = "192.168.1.200" sqlAcc = "test" sqlPasswd = "test" sqlDBName = "test" sqlH = "insert into exchangeRate(eR, userrID) values('" sqlT = " ',12)" currency = "TWD" conn = httplib.HTTPConnection(exchangeURL,80) conn.request("GET",exchangePage) reader = conn.getresponse() pageContext = reader.read() conn.close() indess = pageContext.find(currency) pageContext = pageContext[indess:(indess+500)] exchange = split(split(pageContext,">")[5]," conn.close() sql = sqlH + exchange + sqlT cx = pymssql.connect(host=sqlAddr, user=sqlAcc, password=sqlPasswd, database=sqlDBName) cur = cx.cursor() cur.execute(sql) cx.commit() cur.close()