注册 登录
编程论坛 → J2EE论坛

[求助]无效的游标状态 这个错误是在没回事啊

terry_vicky 发布于 2007-01-15 08:32， 1363 次点击
我在页面删除了一条记录然后就报这个错误了，这个错误怎么解决啊

java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 无效的游标状态
sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3908)
sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5702)
sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:356)
sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:413)
org.apache.jsp.document.vdoc_jsp._jspService(vdoc_jsp.java:173)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802
5 回复
#2
terry_vicky2007-01-15 09:04

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="exesql" class="arkeco.document.exesql" />
<jsp:useBean id="checkright" class="arkeco.document.pv_checkright" />
<jsp:useBean id="PublicBean" class="arkeco.mypublic.Pub_Function" />
<%
String userid=(String)session.getValue("userid");
int i;

String sql,sql_i,sql_f,sql_r,sql_y;
ResultSet rs,rs_f,rs_r,rs_y;

String[] fcno_r=new String[30];
String[] fcno_w=new String[30];

if (userid==null)
{

%>
<jsp:forward page="../calendar/login.jsp?url=../document/vdoc.jsp"/>
<%
}
%>
<html>
<head>
<title>文档信息管理</title>
<style type="text/css">
<!--
td { font-size: 9pt}
p { line-height: 12pt}
-->
</style>
</head>
<body>
<center>

<br>
<TABLE width="90%" cellpadding="0" cellspacing="0">
<TR>
<TD colspan="4" align="center"><font size="2"><b>查看文档</b></font></td>
</TR>
</table>
<br>
<hr noshade size="1" width="90%" align="center">
<%
fcno_r=checkright.ckright_r(userid);

if (fcno_r[0].equals("no"))
{
%>
<br>
<br>
<table>
<tr>
<td>您没有执行该操作的权限</td>
<td><a href="javascript:history.back()">返回</a></td>
</tr>
</table>
<%
}
else
{
%>
<TABLE width="90%" cellpadding="0" cellspacing="0">
<tr bgcolor="#fffacd">
<td><b>文档查询、管理</b></td>
</tr>
</table>
<TABLE width="90%" cellpadding="0" cellspacing="0">
<FORM METHOD="POST" name="searchform" action="vsearch.jsp">
<TR>
<TD height="30">文档类型：</td>
<td><select name="fileclass"><option value="-1">所有</option>
<%
i=0;
while (fcno_r[i] != null)
{
out.print("okok");
out.print(fcno_r[i]);
sql="select fileclass from tab_fileclass where fileclassno='"+fcno_r[i]+"'";
rs=exesql.execute(sql);
rs.next();
String fcname=rs.getString("fileclass");
%>
<option value="<%=fcno_r[i]%>"><%=fcname%></option>
<%
i++;
}
%>
</select>
</td>
<td>事务类型：</td>
<td><select name="matter"><option value="-1">所有</option>

<%@ include file="matter.jsp" %>
</select>
</td>
</TR>
<TR>
<td height="30">客户：</td>
<td><select name="customer"><option value="-1">所有</option>

<%@ include file="customer.jsp" %>
</select>
</td>
<td>供应商：</td>
<td><select name="supply"><option value="-1">所有</option>

<%@ include file="supply.jsp" %>
</select>
</td>
</TR>
<TR>
<td height="30">关键字：</td>
<td colspan="3"><input name="keyword" size="50" type="text"></td>
</TR>
<TR height="30">
<td colspan="4" align="center">
<INPUT TYPE="submit" size="4" value="GO!">
</td>

</TR>
</FORM>
</table>
<%
}
%>
</center>

</body>
</html>



这个是我JSP的代码，请大家帮我看看，急啊
#3
千里冰封2007-01-15 09:33
应该把你的bean的代码拿出来看看
#4
smoon2007-01-15 13:40
while (fcno_r[i] != null)
{
out.print("okok");
out.print(fcno_r[i]);
sql="select fileclass from tab_fileclass where fileclassno='"+fcno_r[i]+"'";
rs=exesql.execute(sql);
rs.next();
 String fcname=rs.getString("fileclass");
%>
<option value="<%=fcno_r[i]%>"><%=fcname%></option>
<%
i++;
}
%> 会不会是你的数据库里没东西拉你还在读呀？。。。。。乱说的呀。。。。。不知道对不
#5
千里冰封2007-01-15 13:53
楼上看得真仔细
#6
terry_vicky2007-01-15 14:27

我的数据库里还有3条记录，我删了一条就不好用，在把删的那条记录给加上去了就好用了，，这什么怎么回事啊，
1
©2025, BC-CN.NET
电脑版