Parameter index out of range (1 > number of parameters, which is 0).求解

Question

本帖最后由 peng13425 于 2011-11-24 12:32:03 编辑

Answer 1

ResultSet rs1 = ps.executeQuery(sql);
         while(rs1.next()){
             if(rs1.next() == true){
                 System.out.println("登陆成功！");
                 display();
             }else{
                 System.out.println("用户名或密码错误！");
             }
把第一句的那个括号里面的SQL去掉，然后把while那个循环去掉，再把true去掉就行了，因为我循环去取值，所以索引越界了
ResultSet rs1 = ps.executeQuery();
         
             if(rs1.next()){
                 System.out.println("登陆成功！");
                 display();
             }else{
                 System.out.println("用户名或密码错误！");
             }