java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引.谁能帮忙看一下,急......

[c_fans20]

<%

String uid= codeToString(request.getParameter("txtID"));
String pwd=codeToString(request.getParameter("txtPassWord"));
Connection scon;
ResultSet rs;
Statement state;

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
scon=DriverManager.getConnection("jdbc:odbc:JSPEmployees","sa","");
state=scon.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=state.executeQuery("select UserID ,PassWord from UserInfo");
rs.beforeFirst();
int i=0;
try{
while(rs.next())
{

//out.println(rs.getString("PassWord"));
if( rs.getString("UserID").equals(uid) && rs.getString("PassWord").equals(pwd))
{
i=1;

}
}
out.println(rs.getString("UserID"));
if(i==1)
response.sendRedirect("index.jsp");
else
out.println("登陆失败");
//response.sendRedirect("LoginFalse.jsp");
}catch(Exception e)
{
out.println(e.toString());
}

%>

[baggio727]

你放SQL的三个直连包了么 打sp3补丁了么

[it115]

在JSP页面用RS连接数据库时如果发生这种错误,就是因为RS取值的时候没有按照数据库中字段的顺序.

Microsoft][ODBC SQL Server Driver]无效的描述符索引问题的解决
在jsp对sqlserver数据库进行数据读取的时候，
必须按照表中列名的顺序读取，否则会出现错误