#查询操作
with closing(pymssql.connect(host='.',user='sa',password='123456',database='gamedatas')) as conn :
cur = conn.cursor()
#SELECT 长连接查询操作(逐条方式获取数据)
sql = "select * from user"
cur.execute(sql)
for i in range(cur.rowcount):
print cur.fetchone()
#SELECT 短链接查询操作(一次查询将所有数据取出)
sql = "select * from user"
cur.execute(sql)
print cur.fetchall()
#INSERT
sql = "INSERT INTO user(name)VAlUES(%s)"
uuidstr = str(uuid.uuid1())
cur.execute(sql,(uuidstr,))
conn.commit()
print cur._result
#Update
vl = '张三'
sql = 'update name set title = %s where id=1'
cur.execute(sql,(vl,))
conn.commit()
#参数化查询
sql = "select * from pcontent where id=%d"
cur.execute(sql,(1,))
print cur.fetchall()
# 调用存储过程SP_GetALLContent 无参数
sql = "Exec SP_GetALLContent"
cur.execute(sql)
print cur.fetchall()
# 调用存储过程SP_GetContentByID 有参数的
sql = "Exec SP_GetContentByID %d"
cur.execute(sql,(3,))
print cur.fetchall()
原创文章,转载请注明来源:http://www.gamedatas.com
永久链接:http://www.gamedatas.com/archives/131
转载于:https://blog.51cto.com/gamedatas/1441651