js基础小练习-处理数组

       如果以后写页面要这样拼串，我会疯掉，真的！！！

 已知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','男','武汉')

    <script>
        var arr = ["userName=admin", "password=123456", "sex=男", "address=武汉"];
        var arr1 = [];
        var arr2 = [];
        var arr3 = [];
        var newArr = '';
        for (i in arr) {
            arr1 = arr[i].split('='); 
//['userName', 'admin']  ['password', '123456'] ['sex', '男']   ['address', '武汉']
            arr2 = arr1[0].split("'");
 //['userName'] ['password'] ['sex'] ['address']
            arr3 = arr1[1]; 
//admin 123456 男 武汉
            newArr += (arr2.toString() + "='" + arr3 + "',");
        }
        document.write(`<p>update from table  (${newArr.substr(0,newArr.length-1)})</p>`);
        // （2） insert table(userName,password,sex,address) values('admin','123456','男','武汉')
        var str1 = '';
        var str2 = '';
        var arr4 = [];
        var arr5 = [];
        var arr6 = [];
        for (j in arr) {
            arr4 = arr[j].split('=');
 //['userName', 'admin']  ['password', '123456'] ['sex', '男']   ['address', '武汉']
            arr5 = arr4[0] //.split("'");
//userName password sex address
            arr6 = arr4[1]; 
//admin 123456 男 武汉
            //console.log(arr6);
            str1 += (arr5.toString() + ',');
            //console.log(str1);
            str2 += ("'" + arr6.toString() + "'" + ',');
            //console.log(str2);
        }
        document.write(`<p>insert table  (${str1.substr(0,str1.length-1)}) values (${str2.substr(0,str2.length-1)})</p>`);
    </script>

运行结果如图：