MYSQL语句错误

[开始就不要推那个]

严重: Servlet.service() for servlet [jsp] in context with path [/UserManger] threw exception [An exception occurred processing JSP page /delet.jsp at line 22

19: Connection con=dbHelper.getConnection();
20: PreparedStatement pst=con.prepareStatement(delectStr);
21:
22: pst.execute();
23: %>
<%
String strEmpNo=request.getParameter("empon");
System.out.print(strEmpNo);
String delectStr="delect from empon where empon=?";
DBHelper dbHelper=new DBHelper();
Connection con=dbHelper.getConnection();
PreparedStatement pst=con.prepareStatement(delectStr);
pst.setInt(1, Integer.parseInt(strEmpNo));
pst.execute();
%>
</body>
</html>

麻烦各位， 不会MYSQL

[tony4geek]

String delectStr="delect from empon where empon=1";

[XxiaoxiaoL]

引用 1 楼 rui888 的回复:

String delectStr="delect from empon where empon=1";

+1，你语句都写错了

[开始就不要推那个]

String delectStr="delete from empon where empon=?"; 严重: Servlet.service() for servlet [jsp] in context with path [/UserManger] threw exception [An exception occurred processing JSP page /delet.jsp at line 22 19: Connection con=dbHelper.getConnection(); 20: PreparedStatement pst=con.prepareStatement(delectStr); 21: 22: pst.execute(); 23: %> 24: </body> 25: </html>

[自由自在_Yu]

delect delete

[开始就不要推那个]

谢谢你们， 我爱你们。

[SanHydra]

delete单词都能拼错……