此回复为自动发出,仅用于显示而已,并无任何其他特殊作用
楼主【mengxin123】截止到2008-06-27 19:36:36的历史汇总数据(不包括此帖):
发帖数:10 发帖分:330
结贴数:9 结贴分:280
未结数:1 未结分:50
结贴率:90.00 % 结分率:84.85 %
值得尊敬
楼主【mengxin123】截止到2008-06-27 19:36:36的历史汇总数据(不包括此帖):
发帖数:10 发帖分:330
结贴数:9 结贴分:280
未结数:1 未结分:50
结贴率:90.00 % 结分率:84.85 %
值得尊敬
function choosetype2(obj,yddd){//fgs换个别的名字如obj
var t1;
var t2;
var i,ii;
t1=obj.value;
t2=yddd.value;
yddd.length=1;
发表于:2008-06-27 19:36:36 楼主 运行时提示错误 Line:20
Char:1
Code:0
Error:缺少对象 查看源代码
第20行是
t1=fgs.value; HTML code
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.lang.*,java.sql.*,java.text.*,java.io.*"%>
<jsp:useBean scope="page" id="ExecuteWay" class="dfbz.ExecuteWay" />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>电费报账明细查询</title>
<style>
body{background:#E8FBFF;}
</style>
<script language = "JavaScript">
type2s=new Object();
<%
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
Connection con = java.sql.DriverManager.getConnection("jdbc:jtds:sqlserver://134.206.9.7:1433/dfbz", "sa", "glxtsjk");
String str1="select * from yddd";
ResultSet rs1=ExecuteWay.exeSqlQuery(str1);
while(rs1.next()){
str1="select * from yddd where fgs='"+rs1.getString("name")+"'";
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs2=stmt.executeQuery(str1);
if(rs2.next()){
rs2.last();
int rowcount=rs2.getRow();
String sz="type2s['"+rs1.getString("name")+"']=new Array(";
for(int k=1;k<=rowcount;k++){
rs2.absolute(k);
if(k<rowcount){
sz+="'"+rs2.getString("name")+"',";
}else {
sz+="'"+rs2.getString("name")+"');";
}
}
out.println(sz);
}
}
%>
function choosetype2(fgs,yddd){
var t1;
var t2;
var i,ii;
t1=fgs.value;
t2=yddd.value;
yddd.length=1;
if(t1=='0') return;
if(typeof(type2s[t1])=='undefined') return;
for(i=0; i<type2s[t1].length; i++)
{
ii = i+1;
yddd.options[ii] = new Option();
yddd.options[ii].text = type2s[t1][i];
yddd.options[ii].value = type2s[t1][i];
}}
</script>
</head><body><select name="fgs" id="fgs" onchange="choosetype2(this, document.getElementById('yddd'))">//注意单引号'yddd'
同意。
也可以改成外面单引号里面用引号。
<select name="fgs" id="fgs" onchange='choosetype2(this, document.getElementById("yddd"))'>