lt
/
data_fusion


			
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
							<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>测试页面</title>
    <script src="http://libs.baidu.com/jquery/2.0.0/jquery.min.js"></script>
</head>
<body>
    <tr>

            <div>
                <input type="text" style="width:300px; height:50px" name="str" value="select * from doctors limit 0,10;" />

            <td>
                <input  value="测试" type="button" onclick="dd()"/>
            </td>
        </div>

    </tr>
    <tr>

        <div id="jsontext">


        </div>
    </tr>
</body>
<script >
    function dd() {
        var str;
        //返回值
        var returnjs;
        //获取输入框sql语句
       str= "str="+$(" input[ name='str' ] ").val();
        alert(str);
        $.ajax({
            url: "/view/executeSql2/",
            type: "get",
            data: str,
            dataType:'json',
            success: function (result) {
                //returnjs= JSON.parse(result);
                var htmK="<table><thead><tr>";
                var htmV="<tr>";
                var item=result;
                var fla=true;
              // console.log(item);
               for(var i=0,l=item.length;i<l;i++){
                   //key 横向
                    if (fla) {
                        for(var key in item[i]){
                                htmK+="<th>" + key + "</th>";
                             // console.log(key+':'+item[i][key]);
                            // htm+=key+':'+item[i][key]+"<br/>"
                        }
                       // htm+="<br/><br/><br/><br/>";
                       htmK+="</tr></thead><tbody>";
                        fla=false;
                    }
                    //V拼接
                   for(var key in item[i]){
                        // if(!item[i]) {
                        //    console.log(key+':'+item[i]);
                        // }
                      if (item[i][key]==null || item[i][key]==""|| item[i][key] == "undefined" || item[i][key] == undefined || item[i][key] == "null" )  {
                          htmV+="<th>空</th>";
                       htmV += "<th>"+item[i][key]+"</th>";
                      }else{
                          htmV += "<th>"+item[i][key]+"</th>";
                      }
                       // console.log(key+':'+item[i][key]);
                       // htm+=key+':'+item[i][key]+"<br/>"
                   }
                   htmV+="</tr><tr>";
               }
                 $("#jsontext").append(htmK + htmV);
                // $("#jsontext").append(htmV);
            }
        })
    }
</script>
</html>