在python环境下,往mysql数据库批量写入数据,commit语句必备
database='cms0422' #需要操作的数据库
db = pymysql.connect(
host='127.0.0.1',
user='root',
password='test123456',
db=database,
charset='gbk',
port= 3306,
cursorclass=pymysql.cursors.DictCursor,
)
cur = db.cursor() #生成读取“指针”
kk=0
for key in data_turb:
for tur in data_turb[key]:
print(tur)
if tur.find('/WS/WT') !=-1:
ii=tur.find('/WS/WT')+6
print(ii,tur[ii:-1])
posi="GB,GEN,MB,NAC,OC"
sql='INSERT INTO '+'wind_infor' +' (wind_name,turbine_name,turbine_posi) VALUES ("'+ key +'","'+ tur[ii:-1] +'", "' + posi +'");' #生成sql语句
print(sql)
cur.execute(sql) #执行sql语句
db.commit() # 数据表内容有更新,必须使用到该语句
kk +=1
print("记录插入成功。",kk)
cur.close()
db.close()