Microsoft][ODBC SQL Server Driver]无效的描述符索引

大侠好：小弟求教啊：程序如下：
<%-- 
    Document   : index
    Created on : 2008-7-10, 10:40:29
    Author     : Administrator
--%><%@page contentType="text/html" pageEncoding="UTF-8" import="java.sql.*,java.io.*"%>
<%@include file="include.jsp"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd"><html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>登录……</title>
    </head>
    <body>
        <% 
            String username = request.getParameter("username");
            String password = request.getParameter("password");
            try {
                Class.forName(className);
            } catch (ClassNotFoundException e) {
                e.toString();
            }
            conn = DriverManager.getConnection(url, user, pwd);
            stmt = conn.createStatement();
            String isCorrect = "select * from tb_user where username='"+username+"' and password='"+password+"' "; 
            rs = stmt.executeQuery(isCorrect);
                 
            if (!rs.next()) {                         
                response.sendRedirect("login.html");
                rs.close();
                stmt.close();
                conn.close();
            } else if (rs.getString("isCheck").equals("0")) {                 session.setAttribute("username",rs.getString("username"));
                session.setAttribute("password",rs.getString("password"));
                session.setAttribute("isCheck",rs.getString("isCheck"));
                try {
                    stmt.executeUpdate("update tb_user set isCheck=" + 1 + "where username='" + username + "'");
                    stmt.close();
                    conn.close();
                    rs.close();
                } catch (Exception e) {
                    e.printStackTrace();
                }
                response.sendRedirect("index.html");
            } else {                                                 //找到记录，且投过票
                response.sendRedirect("watch.jsp");
                stmt.close();
                conn.close();
                rs.close();
            }
        %>
    </body>
</html>
说明：数据库中有表tb_user有四个字段：id（int）,username（varcher),password(varcher),isCheck(varcher)
先经过html文件提交后，出现下错误：
javax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.login_jsp._jspService(login_jsp.java:147)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)

解决方案 »

  1.   

    此回复为自动发出,仅用于显示而已，并无任何其他特殊作用
    楼主【qunqun886】截止到2008-07-20 14:13:09的历史汇总数据(不包括此帖)：
    发帖的总数量:1                        发帖的总分数:20                       每贴平均分数:20                       
    回帖的总数量:0                        得分贴总数量:0                        回帖的得分率:0%                       
    结贴的总数量:1                        结贴的总分数:20                       
    无满意结贴数:0                        无满意结贴分:0                        
    未结的帖子数:0                        未结的总分数:0                        
    结贴的百分比:100.00%               结分的百分比:100.00%                  
    无满意结贴率:0.00  %               无满意结分率:0.00  %                  
    敬礼!
      

  2.   

     stmt.executeUpdate("update tb_user set isCheck=1 where username='" + username + "'"); 
      

  3.   

    ("update tb_user set isCheck=" + 1 + "where username='" + username + "'")这句where 前加一个空格,不然旧成了1where 
      

  4.   

    桥接？问题很多，改用纯jdbc的驱动吧。
      

  5.   

    set isCheck='" + 1 + "'