import pyodbc import numpy as np import datetime as dt import time def db_start(): cn = pyodbc.connect("DRIVER={SQL Server};server=xxxxxxx;UID=sa;PWD=yyyy;DATABASE=zzzz;") cur = cn.cursor() return ( cn, cur ) def db_end(cn, cur): cn.commit() cur.close() cn.close() return #=========================================== # ここからプログラムスタート test_id=1 cn, cur = db_start() sql = """ SELECT * FROM test WHERE test_id=%s """ % (test_id) cur.execute(sql) rows = cur.fetchall()