【python 3.6】python读取json数据存入MySQL（一）

link之家

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

不拘小节的吐司 · Windows - Microsoft Q&A· 2 年前 ·

微醺的硬币 · Django request.user ...· 2 年前 ·

想出家的海龟 · OpenHtmlToPdf.netcore ...· 2 年前 ·

威武的茴香 · Troubleshooting ...· 2 年前 ·

小眼睛的椅子 · C++ ...· 2 年前 ·

# 创建表头 sql = " CREATE TABLE daxue (code VARCHAR(32),charge VARCHAR(100),level VARCHAR(100),name VARCHAR(100),remark VARCHAR(100),prov VARCHAR(100)); " cur.execute(sql) # 执行上述sql命令 a = open(r " D:\alldata.json " , " r " ,encoding= ' UTF-8 ' ) out = a.read() tmp = json.dumps(out) tmp = json.loads(out) num = len(tmp) i = 0 while i < num: code = tmp[i][ ' code ' ] charge = tmp[i][ ' charge ' ] level = tmp[i][ ' level ' ] name = tmp[i][ ' name ' ] remark = tmp[i][ ' remark ' ] prov = tmp[i][ ' prov ' ] value = [code,charge,level,name,remark,prov] sql_insert = " insert into daxue (code,charge,level,name,remark,prov) values ( " + " ' " +code+ " ' " + " , " + " ' " +charge+ " ' " + " , " + " ' " +level+ " ' " + " , " + " ' " +name+ " ' " + " , " + " ' " +remark+ " ' " + " , " + " ' " +prov+ " ' " + " ); " # sql_insert =("insert into daxue (code,charge,level,name,remark,prov) values (%s,%s,%s,%s,%s,%s);",value) # sql_insert = sql_insert.encode("utf8") print (sql_insert) cur.execute(sql_insert) # 执行上述sql命令 i = i+1 # print(num) conn.commit() conn.close()

执行后效果

推荐文章

不拘小节的吐司 · Windows - Microsoft Q&A

2 年前

微醺的硬币 · Django request.user returning None - Stack Overflow

2 年前

想出家的海龟 · OpenHtmlToPdf.netcore not working on linux - Microsoft Q&A

2 年前

威武的茴香 · Troubleshooting connection pooling (J2C) problems in WebSphere Application Server

2 年前

小眼睛的椅子 · C++ 十进制数转二进制字符串_51CTO博客_c++ 十进制转二进制

2 年前