#执行存储过程 connectionStr = db.createDBConnection() cnxn = pyodbc.connect(connectionStr) cursor = cnxn.cursor() user=('caogao','www.caogao.com',11,1) param1_value = 'caogao_1' cursor.execute("{CALL proc_UpdateUserName(?)}", (param1_value)) #使用事务提交到数据库 print(cursor.rowcount) cursor.commit() cursor.close() cnxn.commit() db.closeDBConnection(cnxn)
# 执行多表联查查询
query = "SELECT column1, column2 FROM table1 INNER JOIN table2 ON table1.id = table2.id"
cursor.execute(query)
# 获取查询结果
result = cursor.fetchall()
# 执行视图查询
query = "SELECT * FROM view_name"
cursor.execute(query)
# 获取查询结果
result = cursor.fetchall()