AJAX联动下拉框.doc

AJAX联动下拉框JSP： Double Combo - Ajax In Action function FillTerritory(oElem,oTarget) var strValue = oElem.optionsoElem.selectedIndex.value; var url = DoubleComboXML; var strParams = q= + strValue + &f= + oT + &e= + oT; var loader1 = new net.ContentLoader(url,FillDropDown,null,POST,strParams); function FillDropDown() var xmlDoc = this.req.responseXML.documentElement; var xSel = xmlDoc.getElementsByTagName(selectElement)0; var strFName = xSel.childNodes0.firstChild.nodeValue; var strEName = xSel.childNodes1.firstChild.nodeValue; var objDDL = document.formsstrFName.elementsstrEName; objDDL.options.length = 0; var xRows = xmlDoc.getElementsByTagName(entry); for(i=0;ixRows.length;i+) var theText = xRowsi.childNodes0.firstChild.nodeValue; var theValue = xRowsi.childNodes1.firstChild.nodeValue; var option = new Option(theText,theValue); objDDL.options.add(option,objDDL.options.length); 企业 智投家 大智慧 部门 a b c d JAVA：package common;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import biz.mnguserBiz;import biz.impl.mnguserBizImpl;import entity.TbMngCptdept;public class DoubleComboXML extends HttpServlet public DoubleComboXML() super(); System.out.println(servlet:DoubleComboXML); public void destroy() super.destroy(); / Just puts destroy string in log / Put your code here private void process(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException response.setContentType(text/xml;charset=utf-8); PrintWriter out = response.getWriter(); String strQuery = request.getParameter(q); String strForm = request.getParameter(f); String strElem = request.getParameter(e); Connection connection = null; PreparedStatement pstm = null; ResultSet rs = null; try Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver); connection = DriverManager.getConnection(jdbc:microsoft:sqlserver:/51:1433;databasename=ztj_base,sa, sa); pstm = connection.prepareStatement(select * from tb_mng_cptdept where superior_corporation= + Integer.valueOf(strQuery); rs = pstm.executeQuery(); catch (ClassNotFoundException e) / TODO Auto-generated catch block e.printStackTrace(); catch (Exception e) / TODO Auto-generated catch block e.printStackTrace(); StringBuffer strXML = new StringBuffer(); strXML.append(); strXML.append(); strXML.append(); strXML.append( + strForm + ); strXML.append( + strElem + ); strXML.append(); try if (!rs.wasNull() strXML.append(); strXML.append(部门); strXML.append(-1); strXML.append(); while (rs.next() strXML.append(); strXML.append( + rs.getString(cptdept_name) + ); strXML.append( + rs.getInt(cptdept_id) + ); strXML.append(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); strXML.append(); out.write(strXML.toString(); out.close(); public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException process(request, response); public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException process(request, response); public void init() throws ServletException / Put your