linkmssql_active.py

使用python连接mssql数据库的例程

#!/usr/bin/env python
# -*- coding: utf-8 -*-
import _mssql
from pylab import *
mssql=_mssql.connect('172.18.23.102','user','user')
mssql.select_db('elementinfo')
StartTime=raw_input('Enter start time:(like 2007041600)')
StopTime=raw_input('Enter stop time:(like 2007041600)')
StationId=raw_input('Enter Station ID:(54517)')

query="EXEC sp_tables; SELECT SurfaceTemp FROM tabTimeData WHERE (ObservTimes <= "+StopTime+")AND (ObservTimes >="+StartTime+") and (StationNum = "+StationId+");"

for x in range(1):
    if mssql.query(query):
        header=mssql.fetch_array()
        l = [ i[0] for i in header[1][2] ]
        
    else:
        print mssql.errmsg()
        print mssql.stdmsg()
    y=list()
    for x in l:
        y.append(float(x)/10)
    print y        
plot(y)
show()