jsp连库问题
为什么我用GROUP BY 或DISTINCT会出现javax.servlet.ServletException: [Microsoft][ODBC Driver Manager] Invalid cursor state
错误
原文如下:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%@page import = "com.china.pro.labor.ISOtoGb2312"%>
<html>
<head>
<title>选择部门</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css/laobao1.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#087B86">
<jsp:useBean id="db" scope="page" class="com.china.pro.labor.dbBean"/>
<%ISOtoGb2312 i = new ISOtoGb2312();%>
<%
String id = request.getParameter("id");
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:labor";
String username = "";
String password = "";
String sql = "select distinct department from userInfo";
java.sql.ResultSet Rst;
%>
<jsp:setProperty name="db" property="driver" value="<%=driver%>"/>
<jsp:setProperty name="db" property="url" value="<%=url%>"/>
<jsp:setProperty name="db" property="username" value="<%=username%>"/>
<jsp:setProperty name="db" property="password" value="<%=password%>"/>
<jsp:setProperty name="db" property="sql" value="<%=sql%>"/>
<TABLE WIDTH=759 BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
<TR>
<TD> <table width="503" height="508" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><TABLE WIDTH=503 BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD> <IMG SRC="images/bumen_01_01.gif" WIDTH=503 HEIGHT=80 ALT=""></TD>
</TR>
<TR>
<TD> <table width="503" height="367" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" background="images/bumen_01_02-bg.gif">
<table width="503" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="55"> </td>
<td width="448"><table width="442" border="0" cellspacing="1" class="text-lang">
<%
Rst = db.query();
//Rst.next();
while(Rst.next()){
String department = Rst.getString("department");
%>
<tr>
<td width="420" bgcolor="#FF9900" class="text"><A HREF="<%=id%>?department=<%=department%>">
<%out.print(department);%>
</A></td>
</tr>
<%}%>
</table> </td>
</tr>
</table>
</td>
</tr>
</table></TD>
</TR>
<TR>
<TD> <IMG SRC="images/bumen_01_03.gif" WIDTH=503 HEIGHT=61 ALT=""></TD>
</TR>
</TABLE></td>
</tr>
</table></TD>
<TD> <IMG SRC="images/bumen_02.gif" WIDTH=256 HEIGHT=508 ALT=""></TD>
</TR>
</TABLE>
</body>
</html>