#coding=gbk

#pip install pymssql

import pymssql

host = "localhost"

user = "sa"

password = "123654"

port = 1433

database = "test"

charset = "utf8"

#获取数据库连接

def GetConn():

conn = pymssql.connect(host=host,user=user,password=password,database=database,port=port,charset=charset)

return conn

#执行简单查询

def Query(sql):

conn = GetConn()

cursor = conn.cursor(as_dict = True)

cursor.execute(sql)

result = cursor.fetchall()

cursor.close()

conn.close()

return result

#执行带参数的查询

def QueryWithParms(sql,parms):

conn = GetConn()

cursor = conn.cursor(as_dict = True)

cursor.execute(sql,parms)

result = cursor.fetchall()

cursor.close()

conn.close()

return result

#执行简单SQL

def ExecSQL(sql):

conn = GetConn()

cursor = conn.cursor()

cursor.execute(sql)

conn.commit()

cursor.close()

conn.close()

return cursor.rowcount

#执行带参数的SQL

def ExecSQLWithParms(sql,parms):

conn = GetConn()

cursor = conn.cursor()

cursor.execute(sql,parms)

conn.commit()

cursor.close()

conn.close()

return cursor.rowcount

#执行多参数的SQL

def ExecSQLMany(sql,parms):

conn = GetConn()

cursor = conn.cursor()

cursor.executemany(sql,parms)

conn.commit()

cursor.close()

conn.close()

return cursor.rowcount

#调用事例

# import SQLHelper

# import datetime

#执行简单查询和带参数的查询

# result = SQLHelper.Query("select * from t1 where id = 2")

# result = SQLHelper.Query("select * from t1 where name like '%李%'")

# result = SQLHelper.QueryWithParms("select * from t1 where name like %s",'%李%')

# result = SQLHelper.QueryWithParms("select * from t1 where id = %s",2)

# result = SQLHelper.QueryWithParms("select * from t1 where id in (%s,%s,%s,%s)",(2,3,4,5))

# for row in result:

#     print(row["id"])

#     print(row["name"])

#     print(datetime.datetime.strftime(row["addtime"],"%F %T"),"\n")

#执行简单SQL

# row = SQLHelper.ExecSQL("insert into t1(name,addtime) values('李红','2018-09-18')")

# print(row)

#执行带参数的SQL

# parms = ('韩梅梅','2018-09-18')

# row = SQLHelper.ExecSQLWithParms("insert into t1(name,addtime) values(%s,%s)",parms)

# print(row)

#执行多参数的SQL

# parms = (('雷锋','2018-09-18'),('小丁','2018-09-19'),('小胡','2018-09-20'))

# row = SQLHelper.ExecSQLMany("insert into t1(name,addtime) values(%s,%s)",parms)

# print(row)

源码下载：SQLHelper.zip