JSON数据转成html表格

来源：互联网发布：软件咨询服务编辑：程序博客网时间：2024/05/17 21:46
<!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>    <script type="text/javascript" src="http://cj.cbcie.com/js/jquery-1.6.min.js"></script>    <title></title></head><body>    <div id="tabdiv">        <table id="tabinfo">            <tr>                <td>金属</td>                <td>class</td>                <td>tableAttr</td>                <td>tableAuditId</td>                <td>tableAuditTime</td>                <td>tableAuditType</td>                <td>tableCountrys</td>                <td>tableDataUpdId</td>                <td>tableDataUpdTime</td>                <td>tableDesc</td>                <td>tableId</td>                <td>tableIfCountry</td>                <td>tableIfDataChart</td>                <td>tableIfImg</td>                <td>tableIfShow</td>                <td>tableItemType</td>                <td>tableName</td>                <td>tableNameCn</td>                <td>tableNum</td>                <td>tableProducts</td>                <td>tableProject</td>                <td>tableProvinceId</td>                <td>tableRows</td>                <td>tableSort</td>                <td>tableTableId</td>                <td>tableType</td>                <td>tableUnit</td>                <td>tableUserId</td>                <td>tableXTwo</td>                <td>tableXTwoCn</td>                <td>tableYTwo</td>                <td>tableYTwoCn</td>            </tr>        </table>    </div>    <script src="1.js"></script>    <script src="2.js"></script>    <script type="text/javascript">var c1 = [{"class": "com.asianmetal.model.datacenter.MetalTable","tableAttr": 1,"tableAuditId": 0,"tableAuditTime": "","tableAuditType": 2,"tableCountrys": "44","tableDataUpdId": 0,"tableDataUpdTime": "","tableDesc": "共计21家 其中3家（隆盛祥、丰瑞、赣州华星）今年生产氢氟酸；内蒙古聚龙未投产；其余16家直接联系获得所有数据，多氟多通过第三方获得及平均库存获得。","tableId": 2463,"tableIfCountry": 0,"tableIfDataChart": 0,"tableIfImg": 4,"tableIfShow": 1,"tableItemType": 15,"tableName": "China's aluminum fluoride producers' total number statistics by province by month","tableNameCn": "中国氟化铝生产商公司总量分省份月度统计","tableNum": "Quantity","tableProducts": "4,357","tableProject": "Producer","tableProvinceId": "22,23,18,24,15,25,16,12,10,1,5,-1","tableRows": 12,"tableSort": 0,"tableTableId": 276,"tableType": 2,"tableUnit": 8,"tableUserId": "","tableXTwo": "","tableXTwoCn": "","tableYTwo": "","tableYTwoCn": ""},{"class": "com.asianmetal.model.datacenter.MetalTable","tableAttr": 1,"tableAuditId": 0,"tableAuditTime": "","tableAuditType": 2,"tableCountrys": "44","tableDataUpdId": 0,"tableDataUpdTime": "","tableDesc": "共计21家 其中3家（隆盛祥、丰瑞、赣州华星）今年生产氢氟酸；内蒙古聚龙未投产；其余16家直接联系获得所有数据，多氟多通过第三方获得及平均库存获得。","tableId": 2449,"tableIfCountry": 0,"tableIfDataChart": 1,"tableIfImg": 4,"tableIfShow": 1,"tableItemType": 1,"tableName": "China's aluminum fluoride producers' production capacity statistics by province by month","tableNameCn": "中国氟化铝生产商产能分省份月度统计","tableNum": "Quantity","tableProducts": "4,357","tableProject": "Producer","tableProvinceId": "18,15,25,12,5,0,-1","tableRows": 7,"tableSort": 0,"tableTableId": 276,"tableType": 2,"tableUnit": 2,"tableUserId": "","tableXTwo": "","tableXTwoCn": "","tableYTwo": "","tableYTwoCn": ""}]        var tabname = new Array("class", "tableAttr", "tableAuditId", "tableAuditTime", "tableAuditType", "tableCountrys", "tableDataUpdId", "tableDataUpdTime", "tableDesc", "tableId", "tableIfCountry", "tableIfDataChart", "tableIfImg", "tableIfShow", "tableItemType", "tableName", "tableNameCn", "tableNum", "tableProducts", "tableProject", "tableProvinceId", "tableRows", "tableSort", "tableTableId", "tableType", "tableUnit", "tableUserId", "tableXTwo", "tableXTwoCn", "tableYTwo", "tableYTwoCn");        function showPriceDesc(c,metal) {            //$(".tabinfo").remove();            for (var i = 0; i < c.length; i++) {                var showHtml = "<tr>";                showHtml += '<td>' + metal + '</td>';                for (var j = 0; j < tabname.length; j++) {                    if (c[i].hasOwnProperty(tabname[j]))                        showHtml += '<td>' + c[i][tabname[j]] + '</td>';                    else                        showHtml += '<td> </td>';                }                showHtml += "</tr>";                $("#tabinfo").append(showHtml);            }        }        showPriceDesc(c1, "铝");        //showPriceDesc(c2, "铜");    </script></body></html>
阅读全文
0 0