求，为什么一直显示ps.executeUpdate();报错？

Question

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>

<title>Insert title here</title> <% //获取readU.jsp传递过来的id对象 String id = request.getParameter("id"); //如果id不为空 if(id!=null){ //获取驱动 Class.forName("com.mysql.jdbc.Driver"); //由获得的驱动连接到数据库 Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/users","root","root"); //根据id删除表对应的数据 String sql = "delete * from useri where id=?"; PreparedStatement ps = conn.prepareStatement(sql); ps.setInt(1, Integer.parseInt(id)); ps.executeUpdate(); response.sendRedirect("readU.jsp"); } %>

Answer 1

sql写错了，是delete from,没有 delete * from这种语法