Question

[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'gradeid=' 中。

org.apache.jasper.JasperException: An exception occurred processing JSP page /1/admingradedelete.jsp at line 8

5: String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\Java\\Tomcat 6.0\\webapps\\ROOT\\1\\student.mdb";
6: Connection conn=DriverManager.getConnection(url,"","");
7: Statement state=conn.createStatement();
8: int n=state.executeUpdate("delete from grade where gradeid="+gradeid);
9: state.close();
10: conn.close();
11: response.sendRedirect("admingrade.jsp");

Answer 1

gradeid不存在。