function updateList1() { var username=XMLHttpReq.responseXML.getElementsByTagName("f_username"); //加上f_ var list = document.getElementsByTagName("*").f_username; for(var i=0;i<country.length;i++){ list.add(new Option(username[i].firstChild.data,username[i].firstChild.data)); } function updateList2() { var userNO=XMLHttpReq.responseXML.getElementsByTagName("f_userNO"); //加上f_ var list = document.getElementsByTagName("*").f_userNO; for(var i=0;i<city.length;i++){ list.add(new Option(userNO[i].firstChild.data,userNO[i].firstChild.data)); }
var username=XMLHttpReq.responseXML.getElementsByTagName("f_username"); //加上f_
var list = document.getElementsByTagName("*").f_username;
for(var i=0;i<country.length;i++){
list.add(new Option(username[i].firstChild.data,username[i].firstChild.data)); } function updateList2() {
var userNO=XMLHttpReq.responseXML.getElementsByTagName("f_userNO"); //加上f_
var list = document.getElementsByTagName("*").f_userNO;
for(var i=0;i<city.length;i++){
list.add(new Option(userNO[i].firstChild.data,userNO[i].firstChild.data)); }
这个是到action文件内取xml生成文件的结果。我贴出来[code=javascript<%@ page contentType="text/html; charset=UTF-8" import="java.util.*,java.sql.*,public_v.* " %>
<%
String Depart=request.getParameter("Depart");
String username = request.getParameter("username");
Statement st = null;
ResultSet rs = null;
List usernamelist = new ArrayList();
List userNOlist = new ArrayList(); try{
Class.forName(driver);
} catch(java.lang.ClassNotFoundException e) {
e.printStackTrace();
} try {
Connection conn = DBManager.connToDB();
st=conn.createStatement();
if(username != null)
{
rs=st.executeQuery("SELECT f_xm FROM t_yg where f_jg='"+CThanding.CurrScode(Depart)+"'");
while (rs.next())
{
usernamelist.add(rs.getString(1));
}
}
if(userNO != null)
{
rs=st.executeQuery("SELECT f_ygh FROM t_yg where f_xm='"+username+"'");
while (rs.next())
{
userNOlist.add(rs.getString(1));
}
}
rs.close();
st.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
response.setContentType("text/xml; charset=UTF-8");
response.setHeader("Cache-Control", "no-cache");
out.println("<response>");
for(int i=0;i<usernamelist.size();i++)
{
out.println("<username>" + usernamelist.get(i).toString() + "</username>");
}
for(int i=0;i<userNOlist.size();i++)
{
out.println("<userNO>" + userNOlist.get(i).toString() + "</userNO>");
}
out.println("</response>");
out.close();
%>][/code]
<%
String Depart=request.getParameter("Depart");
String username = request.getParameter("username");
Statement st = null;
ResultSet rs = null;
List usernamelist = new ArrayList();
List userNOlist = new ArrayList(); try{
Class.forName(driver);
} catch(java.lang.ClassNotFoundException e) {
e.printStackTrace();
} try {
Connection conn = DBManager.connToDB();
st=conn.createStatement();
if(username != null)
{
rs=st.executeQuery("SELECT f_xm FROM t_yg where f_jg='"+CThanding.CurrScode(Depart)+"'");
while (rs.next())
{
usernamelist.add(rs.getString(1));
}
}
if(userNO != null)
{
rs=st.executeQuery("SELECT f_ygh FROM t_yg where f_xm='"+username+"'");
while (rs.next())
{
userNOlist.add(rs.getString(1));
}
}
rs.close();
st.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
response.setContentType("text/xml; charset=UTF-8");
response.setHeader("Cache-Control", "no-cache");
out.println("<response>");
for(int i=0;i<usernamelist.size();i++)
{
out.println("<username>" + usernamelist.get(i).toString() + "</username>");
}
for(int i=0;i<userNOlist.size();i++)
{
out.println("<userNO>" + userNOlist.get(i).toString() + "</userNO>");
}
out.println("</response>");
out.close();
%>