ajax查询数据库，服务器传回json字符串，js解析json

("departmentID"); DataBaseHandle dataBaseHandle=new DataBaseHandle("commonUser", "common", "jdbc:mysql://127.0.0.1:3306/firstwebsite"); String SQL="select * from speciality where departmentID=‘"+departmentID+"‘"; String json="{‘specialities‘:["; response.setContentType("text/html; charset=utf-8"); response.setCharacterEncoding("UTF-8"); try { ResultSet rs=dataBaseHandle.exeuteSQL(SQL); while(rs.next()) { json=json+"{‘"+"specialityID‘:‘"+rs.getString(1)+"‘,"+"‘SPname‘:‘"+rs.getString(2)+"‘},"; System.out.println(rs.getString(1)+rs.getString(2)); } json=json.substring(0,json.length()-1); json=json+"]}"; PrintWriter pwriter=response.getWriter(); pwriter.print(json); rs.close(); dataBaseHandle.closeResourse(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }

js解析json，获得返回的内容

   function updateSpeciality(str)
        {
            var xmlhttp;
            if (str=="")
            {
                alert("请选择非空的值!");
                return;
            }
            if (window.XMLHttpRequest)
            {// code for IE7+, Firefox, Chrome, Opera, Safari
                xmlhttp=new XMLHttpRequest();
            }
            else
            {// code for IE6, IE5
                xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
            }
            xmlhttp.onreadystatechange=function()
            {
                if (xmlhttp.readyState==4 && xmlhttp.status==200)
                {
                    var dataObj=eval("("+xmlhttp.responseText+")");//转换为json对象

                    for(var o in dataObj.specialities)
                    {
                        alert(dataObj.specialities[o].specialityID);
                        alert(dataObj.specialities[o].SPname);

                    }


                }
            }
            xmlhttp.open("GET","/First/servlet/GetMessage?departmentID="+str,true);
            xmlhttp.send();

        }

版权声明：本文为博主原创文章，未经博主允许不得转载。

ajax查询数据库，服务器传回json字符串，js解析json

标签：ajax   服务器   json   js