首先,安装pymssql第三方库
pip install pymssql
其次,导入pymssql库
最后们就可以连接数据库了
import pymssql server = "10.10.9.110" user = "sa" password = "123456" database = "QXdatabase" startTime = '2019-07-23 15:24' endTime = '2019-07-23 15:25' db = pymssql.connect(server, user, password, database,charset = 'utf8') cursor = db.cursor() # 判断时间段内是否有数据缺失和ID的sql语句 id_sql = "SELECT EquipID,count(*) as nums from FSK_BJ_PLC where EquipID = 10001 and CreateDate > '" + startTime + "' and CreateDate <= '" + endTime + "' GROUP BY EquipID" cursor.execute(id_sql) row = cursor.fetchall() print row print len(row) print type(row) db.close()
connect的参数:
user:用户名
password:密码
trusted:布尔值,指定是否使用windows身份认证登陆
host :主机名
database:数据库
timeout:查询超时
login_timeout:登陆超时
charset:数据库的字符集
as_dict:布尔值,指定返回值是字典还是元组
max_conn:最大连接数