在這里，我開發(fā)了我的 Jquery 代碼 我的 jquery 代碼<html> <head> <script type="text/javascript" src="js/jquery-1.11.1.min.js"></script> </head> <body> <script> $(document).ready(function(){ $("button").click(function(){ $.ajax({ type: 'GET', url: "3.cfc?method=test", success: function(data){ document.getElementById("demo").innerHTML = data } }); }); }); </script> <div id="demo"> <button type="button" id="texts">GET college details by jquery</button> <p id="urlPage"></p> <div> </body></html>這里我的coldfusion組件代碼 我的cfc代碼<cffunction name="test" access="remote" returnformat="JSON" returntype="query"> <cfquery name="jsresult" datasource="student" result="result" > SELECT * FROM clg </cfquery> <cfreturn jsresult></cffunction>最后我得到了這個(gè)輸出 我的輸出{"COLUMNS":["COLLEGENO","COLLEGENAME","DEPT"],"DATA":[[1,"nec","cse"],[2,"kamaraj","mech"],[3,"voc","arts"],[4,"srm","It"],[5,"mitrah","cse"],[6,"mitrah","cse"],[7,"candy","it"],[8,"",""],[9,"fx","eee"],[10,"svs","eee"]]}
如何在coldfusion中通過(guò)JQuery循環(huán)和顯示表中的SQL數(shù)據(jù)
茅侃侃
2022-01-13 15:37:34
