2018.1.31 : mysql 导入表数据时 要注意 表中是否有id 为0 的字段,在运行sql 文件时,sql默认会把id为0的数据自动放在最后,而不是 把0 这个字段按原表储存.
14:58 ajax 提交 多次点击重复提交数据问题.
jsp 页存json 转字符串
var all_commodity_info={};
var commodity_info_list = new Array();
if ($("input[name=commodityId]").length >0) {
for (var i = 0; i < $("input[name=commodityId]").length; i++) {
var commodity_info={};
commodity_info.commodityId = $("input[name=commodityId]")[i].value;
commodity_info.commodityNum = $("input[name=nums]")[i].value;
commodity_info.commodityMoney = $("input[name=money]")[i].value;
commodity_info_list[i]=commodity_info;
}
all_commodity_info.commodityInfoList = commodity_info_list;
}
$.ajax({
url: "${path}/xxxxx.do",
data: {
xxxx: txxxx,
xxx: xxxxx,
xxx: JSON.stringify(xxx)//json 转字符串
},
async: false,
dataType: "json",
type: 'POST',
success: function (data) {
if (data.code === "0") {
window.location.href = "xxxx.do?xxx=" + xxx;
}else {
$("#add").attr("style", "display:block;");
}
alert(data.msg);
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
$("#add").attr("style", "display:block;");
alert("系统异常', '系统异常,请稍后再试");
}
});
如果想用windows.location.href = "/xxx.do?xxx="+xxx;
这种方式传参并且传的参数是自己拼接的json数据
(1).需要把json数据编码处理"encodeURIComponent()"
(2).需要把json转为json字符串JSON.stringify();
(3).完成之后的路径
windows.location.href = "/xxx.do?xxx="+encodeURIComponent(JSON.stringify(xxx));