python3 连接SQLserver

pymssql 是Python语言用来连接微软 SQL SERVER 数据库的类库，实现了 Python DB API 2.0 。官网介绍。

安装包：

(python34) C:\WINDOWS\system32> pip install  pymssql

Collecting pymssql

  Downloading pymssql-2.1.-cp34-cp34m-win_amd64.whl (371kB)

    % |████████████████████████████████| 378kB 525kB/s

Installing collected packages: pymssql

Successfully installed pymssql-2.1.

(python34) C:\WINDOWS\system32>

(python34) C:\WINDOWS\system32>

(python34) C:\WINDOWS\system32> pip install  pymysql

Collecting pymysql

  Downloading PyMySQL-0.7.-py2.py3-none-any.whl (78kB)

    % |████████████████████████████████| 81kB 155kB/s

Installing collected packages: pymysql

Successfully installed pymysql-0.7.

最简事例：

#!/usr/bin/env python

# encoding: utf-8

"""

@author: 侠之大者kamil

@file: sqlserver.py

@time: 2016/5/31 9:08

"""

import pymssql

conn = pymssql.connect(host="10.x.x.1x2\CRM_MY",user="scxxx",password="xxxx!@#",database="myerp_main_v5",charset="utf8")

cur = conn.cursor()

if not cur:

    raise (NameError,"数据库连接失败")

cur.execute("SELECT top 30 * from p_Customer")

resList = cur.fetchall()#fetchall()是接收全部的返回结果行

conn.close()

print(resList)