linux python测试连接mssql安装是否成功需要reetds支持
相关安装详见:
linux下连接MSSQL相关freetds安装
u/8/archives/2012/171.html
linux java相关\mysql\tomcat\jdk 安装个人总结
u/8/archives/2012/169.html
linux 开发工具相关安装
u/8/archives/2012/170.html
测试
import _mssql, pymssql
from DBUtils.PooledDB import PooledDB
connection = pymssql.connect(host="IP:1433",user="sa",password="xx",database="xx")
cursor = connection.cursor()
name='时间'
age='23'
sql ='''insert into testdb1(name,age) values('%s','%s')'''%(name,age)
print sql
cursor.execute(sql)
connection.commit()
connection.close()
相关安装详见:
linux下连接MSSQL相关freetds安装
u/8/archives/2012/171.html
linux java相关\mysql\tomcat\jdk 安装个人总结
u/8/archives/2012/169.html
linux 开发工具相关安装
u/8/archives/2012/170.html
测试
import _mssql, pymssql
from DBUtils.PooledDB import PooledDB
connection = pymssql.connect(host="IP:1433",user="sa",password="xx",database="xx")
cursor = connection.cursor()
name='时间'
age='23'
sql ='''insert into testdb1(name,age) values('%s','%s')'''%(name,age)
print sql
cursor.execute(sql)
connection.commit()
connection.close()