json导入mysql_json导入数据库

///

///显示视图///

///

publicActionResult AAA()

{returnView();

}///

///显示方法///

///

[HttpGet]public stringA()

{

HttpClient client= newHttpClient();var aaa = client.GetStringAsync("https://www.layui.com/test/table/demo1.json");var bbb =aaa.Result;var json = JsonConvert.DeserializeObject(bbb);var data =json.data;for (int i = 0; i < data.Count(); i++)

{string sql = "INSERT INTO [dbo].[KuaYu]([id],[username],[email],[sex],[city],[sign],[experience],[ip],[logins],[joinTime]) VALUES(@id,@username,@email,@sex,@city,@sign,@experience,@ip,@logins,@joinTime)";

SqlParameter[] pa= newSqlParameter[]

{new SqlParameter("@id",data[i].id),new SqlParameter("@username",data[i].username),new SqlParameter("@email",data[i].email),new SqlParameter("@sex",data[i].sex),new SqlParameter("@city",data[i].city),new SqlParameter("@sign",data[i].sign),new SqlParameter("@experience",data[i].experience),new SqlParameter("@ip",data[i].ip),new SqlParameter("@logins",data[i].logins),new SqlParameter("@joinTime",data[i].joinTime),

};int count =DBHelper.ZSG(sql, pa);

}returnbbb;

}///

///添加///

///

///

[HttpPost]public string AA(Listlist)

{for (int i = 0; i < list.Count(); i++)

{

Table2 t=list[i];string sql = "INSERT INTO [dbo].[KuaYu]([id],[username],[email],[sex],[city],[sign],[experience],[ip],[logins],[joinTime]) VALUES(@id,@username,@email,@sex,@city,@sign,@experience,@ip,@logins,@joinTime)";

SqlParameter[] pa= newSqlParameter[]

{new SqlParameter("@id",t.id),new SqlParameter("@username",t.username),new SqlParameter("@email",t.email),new SqlParameter("@sex",t.sex),new SqlParameter("@city",t.city),new SqlParameter("@sign",t.sign),new SqlParameter("@experience",t.experience),new SqlParameter("@ip",t.ip),new SqlParameter("@logins",t.logins),new SqlParameter("@joinTime",t.joinTime),

};int count =DBHelper.ZSG(sql, pa);

}var data = new{

a= 200,

b= "添加成功"};var json =JsonConvert.SerializeObject(data);returnjson;

}