81,092
社区成员
发帖
与我相关
我的任务
分享
public static String getSecondSelect(String id) {
StringBuffer sb = new StringBuffer();
Sql_data sd = new Sql_data();
String sql = "select id,username from T_USERwhere id='"
+ id + "'";
ResultSet rs = sd.queryDB(sql);
sb
.append("<?xml version=\"1.0\" encoding=\"gb2312\" standalone=\"yes\" ?>\n");
sb.append("<selects>\n");
sb.append("<select><value>0000</value><text>请选择</text></select>\n");
try {
while (rs.next()) {
String id= rs.getString("id");
String username= rs.getString("username");
sb.append("<select><value>" + id.trim() + "</value><text>"
+ username.trim() + "</text></select>\n");
}
} catch (SQLException e) {
loger.error(e.toString());
} finally {
sd.close();
}
sb.append("</selects>");
return sb.toString();
}
<SCRIPT type="text/javascript">
var req;
function Change_Select()
{
var zhi=1;//变量
var url="select.jsp?id="+escape(zhi);
if(window.XMLHttpRequest)
{
req=new XMLHttpRequest();
}else if(window.ActiveXObject)
{
req=new ActiveXObject("Microsoft.XMLHTTP");
}
if(req)
{
req.open("GET",url,true);
req.onreadystatechange=callback;
req.send(null);
}
}
function callback()
{
if(req.readyState == 4)
{
if(req.status == 200)
{
parseMessage();
}else{
alert("Not able to retrieve description"+req.statusText);
}
}
}
function parseMessage()
{
var xmlDoc=req.responseXML.documentElement;
var xSel=xmlDoc.getElementsByTagName('select');
var select_root=document.getElementById('temp');//下拉框名称
select_root.options.length=0;
for(var i=0;i<xSel.length;i++)
{
var xValue=xSel[i].childNodes[0].firstChild.nodeValue;
var xText=xSel[i].childNodes[1].firstChild.nodeValue;
var option=new Option(xText,xValue);
try{
select_root.add(option);
}catch(e){
}
}
}
</SCRIPT>