//創建ajax請求對象var xmlHttp;function createXMLHttpRequest(){  if(window.ActiveXObject){      xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");  }  else if(window.XMLHttpRequest){      xmlHttp = new XMLHttpRequest();  }}/** * 表單提交 */function submit(){  //發送請求  var searchContent = $id("search_input").value;//查找內容  createXMLHttpRequest();  try{    xmlHttp.onreadystatechange = handleStateChange;    xmlHttp.open("GET", "/MyMap/QueryMapServlet?searchName="+searchContent, true);    xmlHttp.send(null);    }catch(exception){    alert("您要訪問的資源不存在!");    }  $("sideToggleRight").attr("checked","checked");//無作用}//處理結果function handleStateChange(){  if(xmlHttp.readyState == 4){    if (xmlHttp.status == 200 || xmlHttp.status == 0){      var t = xmlHttp.responseText;        jsonobj = eval('('+t+')');    }  }}

//oracle數據庫查詢的結果:Class.forName("oracle.jdbc.driver.OracleDriver");conn = DriverManager.getConnection(url, "dio", "123");stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);rs = stmt.executeQuery("SELECT * FROM GEO where ST like '%"+searchName+"%'");ResultSetMetaData metaData = rs.getMetaData();rs.beforeFirst();//將指針移到最開始的位置int columnCount = metaData.getColumnCount(); //列數 JSONArray array = new JSONArray();  while (rs.next()) {   JSONObject jsonObj = new JSONObject();    //輸出數據    for (int i = 1; i <= columnCount; i++) {     String columnName = metaData.getColumnLabel(i);     String value = rs.getString(columnName);     jsonObj.put(columnName, value);    }     array.put(jsonObj);    }   System.out.println(array);   response.getWriter().print(array);}