Python基于Pymssql模块实现连接SQL Server数据库的方法
发布时间:2020-12-20 12:57:10 所属栏目:Python 来源:网络整理
导读:首先,安装 pymssql第三方库 pip install pymssql 其次,导入pymssql库 最后们就可以连接数据库了 import pymssqlserver = " 10.10.9.110 " user = " sa " password = " 123456 " database = " QXdatabase " startTime = ‘ 2019-07-23 15:24 ‘ endTime =
首先,安装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:最大连接数 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |