js获取国家行政区域划分数据

//http://www.mca.gov.cn/article/sj/xzqh/2020/
var st = document.createElement("script");
st.setAttribute("type", "text/javascript");
st.setAttribute("src", "https://cdn.bootcdn.net/ajax/libs/jquery/3.6.0/jquery.min.js");
document.body.insertBefore(st, document.body.firstChild);
var s = "";
var carr = [0,0];
$("table > tbody > tr[height=19]").each(function(i,o) {
  var code = $(o).children("td:eq(1)").text();
  var val = $(o).children("td:eq(2)").text();
  var ts = code + "-" + val.replace(/[\s]*([\u4e00-\u9fa5]+)$/, "$1") + "-";
  if (/^[\u4e00-\u9fa5]+$/.test(val)) {
    ts += 0 + "-1";
    carr[0] = code;
    carr[1] = 0;
  } else if (/^[\s]{1}[\u4e00-\u9fa5]+$/.test(val)) {
    ts += carr[0] + "-2";;
    carr[1] = code;
  } else if (/^[\s]{3}[\u4e00-\u9fa5]+$/.test(val)) {
    var p = 0;
    var l;
    for (var i = (carr.length - 1); i >= 0; i--) {
      if (carr[i] == "0") continue;
      p = carr[i];
      l = i + 2;
      break;
    }
    ts += p + "-" + l;
  }
  if (s.length > 0) s += "\r\n";
  s += ts;
});
//编码-名称-父级编号-级别
console.log(s);

替换正则

^([^-]+)-([^-]+)-([^-]+)-(\d+)$

insert into cms_area\(area_code,area_name,parent_code,area_level\) values\($1,'$2',$3,$4\);