var arr=["userName=admin","password=123456","sex=男","address=武汉"]
转化为:输出结果
(1) update from table(userName='admin',password='123456',sex='男',address='武汉')
(2)insert table(userName,password,sex,address) values('admin','123456','男','武汉')
var qe = [];
var List = [];
var rt = [];
var ry = [];
var aa =[]
var bb=[]
for (k in arr) {
qe.push(arr[k].split("="));
}
for (q in qe) {
for (qq in qe[q]) {
List.push(qe[q][qq]);
}
}
for (w in List) {
console.log(List[w]);
// console.log(w);
if (w % 2 == 0) {
rt.push(List[w] + "=");
} else {
ry.push("'" + List[w] + "'");
}
}
var eee=[];
document.write("<div>update from table(")
for (var i = 0; i < rt.length; i++) {
eee.push(rt[i]+ry[i])
}
document.write(eee)
document.write(")<br><hr></div>")
// **************************
for (cc in List) {
console.log(List[cc]);
// console.log(w);
if (cc % 2 == 0) {
aa.push(List[cc]);
} else {
bb.push(List[cc]);
}
}
document.write("<div>insert table("+aa+") values("+bb+")</div>")