37,719
社区成员
发帖
与我相关
我的任务
分享
import pymssql
class CONN_MSSQL:
def __init__(self,host,user,password,db):
self.host=host
self.user=user
self.password=password
self.db=db
def connect_mssql(self):
self.conn=pymssql.connect(host=self.host,user=self.user,password=self.password,database=self.db)
cur=self.conn.cursor()
return cur
def exec_mssql(self,sql):
cur=self.connect_mssql()
cur.execute(sql)
reline=cur.fetchall()
self.conn.close()
return reline
def main():
conn=CONN_MSSQL(host='localhost\MSSQLSERVER1',user='sa',password='abcd.1234',db='KPItest')
ab=conn.exec_mssql('''declare @msg bit,
@CURSOR_R CURSOR,
@ID varchar(155),
@FID varchar(155),
@FuserID varchar(155),
@FProjectID varchar(155),
@KPI_01 varchar(155),
@Score_01 varchar(155),
@KPI_02 varchar(155),
@Score_02 varchar(155),
@KPI_03 varchar(155),
@Score_03 varchar(155),
@KPI_04 varchar(155),
@Score_04 varchar(155),
@KPI_05 varchar(155),
@Score_05 varchar(155),
@KPI_06 varchar(155),
@Score_06 varchar(155),
@KPI_07 varchar(155),
@Score_07 varchar(155),
@KPI_08 varchar(155),
@Score_08 varchar(155),
@KPI_09 varchar(155),
@Score_09 varchar(155),
@KPI_10 varchar(155),
@Score_10 varchar(155),
@KPI_11 varchar(155),
@Score_11 varchar(155),
@KPI_12 varchar(155),
@Score_12 varchar(155);exec KPI_Total_PROC_TEST null,null,null,null,null,@msg output,@CURSOR_R output;
fetch next from CURSOR_To into @ID,@Fid,@FuserID,@FProjectID,@KPI_01,@Score_01,@KPI_02,@Score_02,
@KPI_03,@Score_03,@KPI_04,@Score_04,@KPI_05,@Score_05,@KPI_06,@Score_06,@KPI_07,@Score_07,@KPI_08,@Score_08,
@KPI_09,@Score_09,@KPI_10,@Score_10,@KPI_11,@Score_11,@KPI_12,@Score_12
while @@FETCH_STATUS=0
begin
select @ID,@Fid,@FuserID,@FProjectID,@KPI_01,@Score_01,@KPI_02,@Score_02,
@KPI_03,@Score_03,@KPI_04,@Score_04,@KPI_05,@Score_05,@KPI_06,@Score_06,@KPI_07,@Score_07,@KPI_08,@Score_08,
@KPI_09,@Score_09,@KPI_10,@Score_10,@KPI_11,@Score_11,@KPI_12,@Score_12
fetch next from CURSOR_To into @ID,@Fid,@FuserID,@FProjectID,@KPI_01,@Score_01,@KPI_02,@Score_02,
@KPI_03,@Score_03,@KPI_04,@Score_04,@KPI_05,@Score_05,@KPI_06,@Score_06,@KPI_07,@Score_07,@KPI_08,@Score_08,
@KPI_09,@Score_09,@KPI_10,@Score_10,@KPI_11,@Score_11,@KPI_12,@Score_12
end
close CURSOR_To
deallocate CURSOR_To''')
for i in ab:
print(i)
if __name__ == '__main__':
main()