NetBeans产生java.sql.SQLException: Parameter index out of range (4 > number of parameters, which is 0)

NetBeans 运行如下代码后报错:java.sql.SQLException: Parameter index out of range (4 > number of parameters, which is 0). 孩子跪求大佬解释并帮看一下!!

孩子最近在学习web,想连接my sql,无奈一直报错…

package ConditionalQueryServlet;


import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * @author Administrator
 */
@WebServlet(name = "ConditionalQueryServlet", urlPatterns = {"/ConditionalQueryServlet"})
public class ConditionalQueryServlet extends HttpServlet {


    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
                response.setContentType("text/html;charset=UTF-8"); 
        //获取用户提交的code        
                String code = request.getParameter("code");
        //连接数据库用到的对象
                Connection conn = null;
                PreparedStatement prst = null;
                ResultSet rs = null;
        
        //连接数据库用到的参数信息
                String url = "jdbc:mysql://localhost:3306/examinationroomdatabase?useSSL=false&zeroDateTimeBehavior=convertToNull&serverTimezone=UTC";
                String driver = "com.mysql.jdbc.Driver";
                String user = "root";
                String password = "mysql1234";
        
        
                String sql = "SELECT ROOMNAME , ROOMNUMBER , ROOMADDRESS FROM examinationroomdatabase.examinationroom WHERE ROOMNUMBER = +code+ ";
           try (PrintWriter out = response.getWriter()) {
            /* TODO output your page here. You may use following sample code. */
                Class.forName(driver);//载入JDBC驱动程序
                conn = DriverManager.getConnection(url,user,password);//通过驱动管理器建立连接
                
                prst = conn.prepareStatement(sql);//通过连接对象创建语句对象
                prst.setString(4, code);
                rs = prst.executeQuery();//通过语句对象向服务器发送SQL语句,完成业务逻辑。
            
                out.println("<table>");
                    while(rs.next()){
                        out.println("<tr>");
                            out.println("<td>" + rs.getString("ROOMNAME") +  "</td>");
                            out.println("<td>" + rs.getInt("ROOMNUMBER") +  "</td>");
                            out.println("<td>" + rs.getString("ROOMADDRESS")+ "</td>");
                        out.println("</tr>");
                    }
                out.println("</table>");
            } catch (ClassNotFoundException | SQLException ex) {
            Logger.getLogger(ConditionalQueryServlet.class.getName()).log(Level.SEVERE, null, ex);
        }finally{
            if (  rs != null){
              try{
                  rs.close();
            }   catch(SQLException ex) {
                Logger.getLogger(ConditionalQueryServlet.class.getName()).log(Level.SEVERE, null, ex);}
            }
                if ( prst != null){
                     try{
                         prst.close();
                    }   catch(SQLException ex){
                        Logger.getLogger(ConditionalQueryServlet.class.getName()).log(Level.SEVERE, null, ex);
            }
                if (  conn != null){
                     try{
                         conn.close();
                    }   catch(SQLException ex) {
                        Logger.getLogger(ConditionalQueryServlet.class.getName()).log(Level.SEVERE, null, ex);}
            }
        }
        }}
       

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}

运行结果如下:
呜呜
在这里插入图片描述
在这里插入图片描述
跪求大佬解决一下!!!完全不知道问题在哪啊呜呜呜…

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
java.sql.SQLException: Parameter index out of range (7 > number of parameters, which is 5)是一个SQL异常,表示参数索引超出了范围。根据引用的解释,这个错误通常发生在设置参数的过程中,可能是由于没有正确匹配对应的问号或者插入了多余的值导致参数越界。 在这个特定的错误中,给定的参数索引是7,而实际上只有5个参数可用。这意味着你的SQL语句中有7个问号用于参数绑定,但你只提供了5个值。 要解决这个问题,你需要检查你的SQL语句和参数的数量是否匹配。确保你在SQL语句中使用的问号数量与你提供的值的数量一致。如果你的SQL语句中有多余的问号,你需要删除它们。如果你缺少了参数值,你需要提供缺少的值来与每个问号匹配。 总结起来,要解决这个异常,你需要检查你的SQL语句和参数的数量,确保它们匹配,并提供正确数量的参数值以满足每个问号的要求。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [netbeans 报错java.sql.SQLException: Parameter index out of range (4 number of parameters, which ...](https://blog.csdn.net/m0_56664196/article/details/129643117)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] - *2* *3* [java.sql.SQLException: Parameter index out of range (5 number of parameters, which is 4).](https://blog.csdn.net/T_Y_F_/article/details/127124313)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值