连接一个表没问题,连接另一个却出现异常"Invalid Descriptor Index"?
imcjw 2004-12-02 06:05:05 将连接<a href="test.jsp?idnum=<%=rs1.getString("IDnum")%>&&id=<%=rs.getString("jobid")%>"
target=_blank>放在从一个表中取得的数据 <%=rs.getString("name")%>没问题,但放在从另一个表取得的数据<%=rs1.getString("name")%>却出现异常,IDnum和jobid分别为两个表的,异常内容如下:
javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
........
什么问题呢????代码如下:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
int idnum = 0;
int id=0;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:bssite";
String user="sa";
String password="123456";
Connection conn1= DriverManager.getConnection(url,user,password);
Statement stmt1=conn1.createStatement();
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from jobview");
ResultSet rs1=stmt1.executeQuery("select * from job ");
%>
<HTML><HEAD><TITLE></TITLE></head>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<center>
<BODY >
<FORM>
<TABLE >
<TR height=357>
<TD>所属区域 </TD>
<TD>姓名</TD>
<TD>职位名称</TD>
</TR>
<%
int i=0;
while(rs1.next()&& rs.next()){
%>
<TR >
<TD><%=rs.getString("area")%></TD>
<TD> <a href="test.jsp?idnum=<%=rs1.getString("IDnum")%>&&id=<%=rs.getString("jobid")%>" target=_blank><%=rs1.getString("name")%></a></TD>
//问题所在处!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
<TD> <%=rs.getString("name")%> </TD> //另个表,连接<A> </A>放在没问题
</TR>
<% i++;
}
rs1.close();
rs.close();
stmt1.close();
conn1.close();
stmt.close();
conn.close();%>
</TABLE>
</FORM>
</BODY></center></HTML>