出现java.sql.SQLException: Parameter index out of range (1 > number of parameters,

2015-09-08 08:10:22 5.2k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

vscode+latex+bib文献管理下载vscode 安装插件`` 在setting.json中配置在.tex文件中编写论文内容，然后左侧TEX侧边栏中编译，如下图所示，中文用xelatex，英文用pdflatex；编译成功后，就可以查看pdf版本的论文了，我一般在浏览器显示。涉及到文献编译：XXX.bib中存储文献管理内容；XXX.tex是文章内容，使用xelatex编译后会生成XXX.aux，ctrl+⋅ctrl+·ctrl+⋅打开命令行窗口，输入bibtex XXX（可以对aux文件进行编译，不需要加后缀），然后再xelatex. 阅读详情

本人是个菜鸟，想问下，我想在HTML中添加一条记录到数据库t_emp中，然后出现这个错误，这个参数出错在哪？百度弄不出。怎么改才行呢？

package web;



import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;



import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class AddEmpServlet extends HttpServlet {

	public void service(HttpServletRequest request, HttpServletResponse response)

			throws ServletException, IOException {

        request.setCharacterEncoding("utf-8");

		response.setContentType("text/html;charset=utf-8");//设置内容输出类型

		PrintWriter out = response.getWriter();//获取输出流对象

		//以下三行代码功能是获取HTML表单提交的数据

		String name =request.getParameter("name");

		double salary=Double.valueOf(request.getParameter("salary"));

		int age=Integer.valueOf(request.getParameter("age"));

		Connection conn=null;

		PreparedStatement stat=null;

		try{

			Class.forName("com.mysql.jdbc.Driver");

			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/t_emp","root","admin");

			stat=conn.prepareStatement("insert into t_emp values (name,salary,age) ;");

			stat.setString(1, name);

			stat.setDouble(2, salary);

			stat.setInt(3, age);

			stat.executeUpdate();

			out.println("添加成功");	

		}catch(Exception e){

			e.printStackTrace();

			out.println("系统繁忙，请稍后再试");		

		}finally{

			if(stat!=null){

				try{stat.close();

			}catch(SQLException e){

				e.printStackTrace();

			}			

		}

			if(conn!=null){

				try{

					conn.close();				

				}catch(SQLException e){

				e.printStackTrace();

				}

			}	

	}

	}

}

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).



	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)

	at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2715)

	at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:3546)

	at web.AddEmpServlet.service(AddEmpServlet.java:42)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)



	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)



	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)

	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)

	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)

	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)

	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

	at java.lang.Thread.run(Thread.java:745)

...全文

Win11大版本更新失败：系统保留分区空间不足的终极解决方案本文针对Windows 11大版本更新时遇到的“系统保留分区空间不足”错误，提供了详细的诊断与解决方案。核心问题在于EFI系统分区（ESP）空间过小，导致更新失败。文章重点介绍了使用傲梅分区助手等第三方工具安全扩展EFI分区的完整步骤，并提供了手动清理、使用安装介质修复等替代方案，帮助用户彻底解决更新障碍，顺利完成Win11升级。阅读详情

bnna8356586

Web 开发 81,108 成员 341,721 内容

+ 关注 + 加入社区

切换为时间正序

简筱诺 2019-04-26

打赏
举报

我也有同样的问题，是关于更新数据的，我的主键也是自动生成的，这个要如何处理才可以成功修改数据呢？下面是我的代码，麻烦哪个大神帮忙看看，谢谢~ package com.ysl.servlet; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; /** * Servlet implementation class UpdateServlet */ @WebServlet("/UpdateServlet") public class UpdateServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=utf-8"); PrintWriter out = response.getWriter(); HttpSession session = request.getSession(); Integer userId = (Integer) session.getAttribute("userId");//从session获得userId //获得用户信息 String userName = request.getParameter("userName"); String userPwd = request.getParameter("userPwd"); String userEmail = request.getParameter("userEmail"); String userTel = request.getParameter("userTel"); Connection con = null; PreparedStatement pstmt = null; try { Class.forName("com.mysql.jdbc.Driver"); //加载驱动程序 con = DriverManager.getConnection("jdbc:mysql://localhost:3306/tests?useUnicode =true&characterEncoding = gbk", "root", ""); //连接数据库 String sql = "update user set userName= ? , userPwd= ? , userEmail= ? , userTel= ? where userId= ? "; pstmt = con.prepareStatement(sql); //建立预处理对象 pstmt.setString(1, userName); //设置参数值，用户号为2。 pstmt.setString(2, userPwd); //设置参数值，用户号为2。 pstmt.setString(3, userEmail); pstmt.setString(4, userTel); pstmt.setInt(5, userId); int rs = pstmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } finally { try { pstmt.close(); } catch (Exception e) { } try { con.close(); } catch (Exception e) { } } } /** * @see HttpServlet#HttpServlet() */ public UpdateServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub //response.getWriter().append("Served at: ").append(request.getContextPath()); processRequest(request, response); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub //doGet(request, response); processRequest(request, response); } }