获取更新的条数cursor.rowcount

 判断update语句执行是否有更新到

python cx_Oracle

...省略...cx_Oracle...

upsql = "UPDATE C_GSMC_SPIDER t SET t.AQC_ID = :AQC_ID WHERE t.GSMC = :GSMC"
self.cursor.prepare(upsql)
self.cursor.execute(None, {'AQC_ID': item['AQC_ID'], 'GSMC': item['GSMC']})
self.connect.commit()

# cursor.rowcount 更新的条数
if not self.cursor.rowcount:
    print('不存在则新增')
    # 新增
    insql = "INSERT INTO C_GSMC_SPIDER (GSMC,AQC_ID) VALUES ('%s','%s')" % (item['GSMC'], item['AQC_ID'])
    self.cursor.execute(insql)
    self.connect.commit()
    print('插入成功')
else:
    print('更新成功')