将json文件导入mysql_Json导入数据库

AAA

var data;

$(function () {

$.ajax({

url: '/Home/A',

data: 'get',

dataType: 'json',

success: function (res) {

data = res.data;

$.each(res.data, function (i, r) {

var tr = '

'

+ '

' + this.id + ''

+ '

' + this.username + ''

+ '

' + r.email + ''

+ '

' + r.sex + ''

+ '

' + r.city + ''

+ '

' + r.sign + ''

+ '

' + r.experience + ''

+ '

' + r.ip + ''

+ '

' + r.logins + ''

+ '

' + r.joinTime + ''

+ '

';

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

})

}

})

})

function Add(data) {

alert(data);

$.ajax({

url: "/Home/Add",

type: "post",

dataType: "json",

data: { list: data },

success: function (res) {

}

})

}

//function Tianjia() {

// //var id = document.getElementById('1').innerHTML;

// //var username = document.getElementById('2').innerHTML;

// //var email = document.getElementById('3').innerHTML;

// //var sex = document.getElementById('4').innerHTML;

// //var city = document.getElementById('5').innerHTML;

// //var sign = document.getElementById('6').innerHTML;

// //var experience = document.getElementById('7').innerHTML;

// //var ip = document.getElementById('8').innerHTML;

// //var logins = document.getElementById('9').innerHTML;

// //var joinTime = document.getElementById('10').innerHTML;

// //$.ajax({

// // url: "/Home/Add",

// // type: "post",

// // dataType: "json",

// // data: { id: id, username: username, email: email, sex: sex, city: city, sign: sign, experience: experience, ip: ip, logins: logins, joinTime: joinTime },

// // success: function (data) {

// // if (data > 0) {

// // alert('1');

// // }

// // }

// //})

//}

ID

用户名

邮箱

性别

城市

签名

积分

IP

登入次数

加入时间

public ActionResult AAA()

{

return View();

}

[HttpGet]

public string A()

{

HttpClient client = new HttpClient();

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 = new SqlParameter[]

{

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);

}

return bbb;

}

[HttpPost]

public string Add(List list)

{

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

{

Stock k = 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 = new SqlParameter[]

{

new SqlParameter("@id",k.id),

new SqlParameter("@username",k.username),

new SqlParameter("@email",k.email),

new SqlParameter("@sex",k.sex),

new SqlParameter("@city",k.city),

new SqlParameter("@sign",k.sign),

new SqlParameter("@experience",k.experience),

new SqlParameter("@ip",k.ip),

new SqlParameter("@logins",k.logins),

new SqlParameter("@joinTime",k.joinTime),

};

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

}

var data = new

{

a = 200,

b = "添加成功"

};

var json = JsonConvert.SerializeObject(data);

return json;

}