xml 导入 mysql_XML导入数据库

JSONP——XML

省英文市未知列1未知列2天气未知列3未知列4状态

$(function () {

$.ajax({

url: "/Home/XmlShi",

dataType: "json",

success: function (d) {

for (var i = 0; i < d.china.city.length; i++) {

var tr = "

"

+ "

" + d.china.city[i]["@@quName"] + ""

+ "

" + d.china.city[i]["@@pyName"] + ""

+ "

" + d.china.city[i]["@@cityname"] + ""

+ "

" + d.china.city[i]["@@state1"] + ""

+ "

" + d.china.city[i]["@@state2"] + ""

+ "

" + d.china.city[i]["@@stateDetailed"] + ""

+ "

" + d.china.city[i]["@@tem1"] + ""

+ "

" + d.china.city[i]["@@tem2"] + ""

+ "

" + d.china.city[i]["@@windState"] + ""

+ "

";

$("#tb").append(tr);

}

}

})

})

public ActionResult Xml()

{

return View();

}

[HttpGet]

public string XmlShi(Model m)

{

string ConnString = ConfigurationManager.ConnectionStrings["DapperDemo"].ConnectionString;

var url = "http://flash.weather.com.cn/wmaps/xml/china.xml?spm=a2c4e.10696291.0.0.5c5019a4nz9oyZ&file=china.xml";

XmlDocument doc = new XmlDocument();//创建XML操作对象

doc.Load(@url);//加载xml文件的路径

//doc.DocumentElement 是获取XML的根节点

XmlNodeList UserNodes = doc.DocumentElement.ChildNodes;//获取根节点下的子节点,注意是集合，所以返回的是所有子节点

foreach (var item in UserNodes)

{

Model m1 = new Model();

//读取每一个子节点下面的属性值

XmlElement userEle = (XmlElement)item;//将类型强制转换为XmlElement

m1.quName = userEle.GetAttribute("quName");

//XmlNode userNameNode = userEle.SelectSingleNode("UserName");

//uname = userNameNode.InnerText;

m1.pyName = userEle.GetAttribute("pyName");

m1.cityname = userEle.GetAttribute("cityname");

m1.state1 = userEle.GetAttribute("state1");

m1.state2 = userEle.GetAttribute("state2");

m1.stateDetailed = userEle.GetAttribute("stateDetailed");

m1.tem1 = userEle.GetAttribute("tem1");

m1.tem2 = userEle.GetAttribute("tem2");

m1.windState = userEle.GetAttribute("windState");

XmlAdd(m1);

}

string json = JsonConvert.SerializeXmlNode(doc["china"]);

return json;

}

[HttpPost]

public int XmlAdd(Model m)

{

string sql = $"insert into XMLTable values('{m.quName}','{m.pyName}','{m.cityname}','{m.state1}','{m.state2}','{m.stateDetailed}','{m.tem1}','{m.tem2}','{m.windState}')";

SqlConnection connection = SqlConnectionFactory.Connection;

return connection.Execute(sql);

}