如何在PreparedStatement中使用变量进行SQL查询？

将employeeID的值从先前的Servlet传递到当前的Servlet。

Replace id:1243 with placeHolder:  ? .

然后设置它的值

ps.setInt(1,"value that you got from previous servlet");

更改为PersonalInfoOutput.java：

HttpSession session = request.getSession(false); if(session != null) {      String employeeid = (String)session.getAttribute("employeeid");  }

至 ：

HttpSession session = request.getSession(false); String employeeid=""; if(session != null) {      employeeid = (String)session.getAttribute("employeeid");  }