《用ajax实现级联菜单.doc》由会员分享,可在线阅读,更多相关《用ajax实现级联菜单.doc(9页珍藏版)》请在三一文库上搜索。
1、用Ajax实现级联菜单思路:要实现级联菜单,则必须要有触发事件的产生,通过选择省份之后加上onchange()来触发,从而找到相应的市;具体代码如下:Jilian.html代码:function houqu() var url=JiLianJsp.jsp; var xmlHttpRequest = new XMLHttpRequest(); xmlHttpRequest.onreadystatechange=function() if(xmlHttpRequest.readyState=4) var result = xmlHttpRequest.responseText; document.
2、getElementById(mydiv1).innerHTML=result; xmlHttpRequest.open(GET,url,true); xmlHttpRequest.send(null);function ccc(hu) if(hu=1) var xxl=; var url=JiLianJsp1.jsp?kkx=+xxl; var xmlHttpRequest = new XMLHttpRequest(); xmlHttpRequest.onreadystatechange=function() if(xmlHttpRequest.readyState=4) var resul
3、t = xmlHttpRequest.responseText; document.getElementById(mydiv2).innerHTML=result; xmlHttpRequest.open(GET,url,true); xmlHttpRequest.send(null); else if(hu=2) var xxl=document.getElementById(xxxl).value; var url=JiLianJsp1.jsp?kkx=+xxl; var xmlHttpRequest = new XMLHttpRequest(); xmlHttpRequest.onrea
4、dystatechange=function() if(xmlHttpRequest.readyState=4) var result = xmlHttpRequest.responseText; document.getElementById(mydiv2).innerHTML=result; xmlHttpRequest.open(GET,url,true); xmlHttpRequest.send(null); Jilian.jsp代码: % /1.申明数据的驱动; Class.forName(oracle.jdbc.driver.OracleDriver); /2.建立数据库链接Str
5、ing URL=jdbc:oracle:thin:localhost:1521:orcl; String user=scott; String password=tiger; Connection conn=DriverManager.getConnection(URL,user,password);String sql = select PROVINCE_NAME,PROVINCE_ID from PROVINCE;/3.使用conn对象创建一个Statement对象;Statement st = conn.createStatement();/获取结果集;ResultSet rs = st
6、.executeQuery(sql);boolean b=rs.next();/onchange指得是只要发生变化就触发事件的产生; out.println( ); out.print(请选择省份);while(b) String name=rs.getString(PROVINCE_NAME); int id = rs.getInt(PROVINCE_ID); out.println(+name+); b=rs.next(); out.println();rs.close();st.close();conn.close(); %Jilian1.jsp代码: 0) Class.forName(
7、oracle.jdbc.driver.OracleDriver);String URL=jdbc:oracle:thin:localhost:1521:orcl; String user=scott; String password=tiger; Connection conn=DriverManager.getConnection(URL,user,password);String sql = select CITY_NAME from CITY WHERE PROVINCE_ID=+id;Statement st = conn.createStatement();ResultSet rs = st.executeQuery(sql);boolean b=rs.next(); out.println(); out.print(请选择城市);while(b) String name=rs.getString(CITY_NAME); out.println(+name+); b=rs.next(); out.println();rs.close();st.close();conn.close(); else out.println(); out.print(请先选择省份); out.println(); %