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>
}
运行结果如下:
跪求大佬解决一下!!!完全不知道问题在哪啊呜呜呜…