<script language="JavaScript">
function GetResult(str)
{
/*
*--------------- GetResult(str) -----------------
* GetResult(str)
* 功能:通过XMLHTTP发送请求,返回结果.
* 参数:str,字符串,发送条件.
* 实例:GetResult(document.all.userid.value);
* author:wanghr100(灰豆宝宝.net)
* update:2004-5-27 19:02
*--------------- GetResult(str) -----------------
*/
var oBao = new ActiveXObject("Microsoft.XMLHTTP");
//var oBao = new ActiveXObject("Msxml2.XMLHTTP");
oBao.open("POST","server.jsp?sel="+str,false);
oBao.send();
//服务器端处理返回的是经过escape编码的字符串.
//通过XMLHTTP返回数据,开始构建Select.
BuildSel(unescape(oBao.responseText),document.all.sel2)
}
function BuildSel(str,sel)
{
/*
*--------------- BuildSel(str,sel) -----------------
* BuildSel(str,sel)
* 功能:通过str构建Select.
* 参数:str,字符串,由服务端返回的.有特定结构"字符串1,字符串2,字符串3"
* 参数:sel,要构建的Select
* 实例:BuildSel(unescape(oBao.responseText),document.all.sel2)
* author:wanghr100(灰豆宝宝.net)
* update:2004-5-27 19:02
*--------------- BuildSel(str,sel) -----------------
*/
//先清空原来的数据.
sel.options.length=0;
var arrstr = new Array();
arrstr = str.split(",");
//开始构建新的Select.
for(var i=0;i<arrstr.length;i++)
{
sel.options[sel.options.length]=new Option(arrstr[i],arrstr[i])
}
}
</script>
<select name="sel" onChange="GetResult(this.value)">
<option value="">请选择
<option value="福建省">福建省
<option value="湖北省">湖北省
<option value="辽宁省">辽宁省
</select>
<select name="sel2" size="10" multiple>
</select>
第二个页面:server.jsp
<%@ page contentType="text/html; charset=GBK" import="java.sql.*,javax.naming.*,javax.sql.*"%>
<%
String[] arrResult = new String[1000];
java.sql.Connection con=null;
DataSource ds = null;
Statement statement;
//try{
Context ctx = new InitialContext();
String jndi_name="java:/oracle_yepghr";
ds = (DataSource)ctx.lookup(jndi_name);
con=ds.getConnection();
statement=con.createStatement();
String sql="select * from static_tsw";
ResultSet rs=statement.executeQuery(sql);
int i=0;
while(rs.next())
{
arrResult[i] = rs.getString(1);
out.println(rs.getString(1)+"fdsfs");
i++;
}
%>
运行后选择第一个select,怎么看不到表里的信息,看到的是一些http的信息,请问是那里的错误?
