添加链接
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()

执行后效果