#coding=utf-8
import os,psycopg2
import _mssql
import pymssql
from DBUtils.PooledDB import PooledDB
hosts="192.168.1.32"
users="test"
passwords="12345"
dbnames="testdb"
ms_hosts="192.168.1.20"
ms_users="sa"
ms_passwords="sa"
ms_databases="ABS0323"
def initDatabase(filename,conn):
fs=open(filename,"r")
sql=fs.read()
cursor=conn.cursor()
cursor.execute(sql)
conn.commit()
cursor.close()
conn.close()
fs.close()
print "ok"
def ExportFromMs():
conn=pymssql.connect(host=ms_hosts,user=ms_users,password=ms_passwords,database=ms_databases)
cursor=conn.cursor()
lst_result=[]
try:
cursor.execute("SELECT PSP_ID,PSP_NAME,PSP_DTS_ID,PSP_GND_ID,
python DBUtils数据连接池与ms sql配合用法
最新推荐文章于 2021-01-13 05:55:38 发布