将access中的一行删除,原代码为:
将access中的一行删除,原代码为:
String no=(String)session.getAttribute("no");String driverName="sun.jdbc.odbc.JdbcOdbcDriver";String url="jdbc:odbc:DStest";Class.forName(driverName).newInstance();Connection conn=DriverManager.getConnection(url,"","");Statement stmt=conn.createStatement();String sql="delete from student where stuno="+request.getParameter("id");stmt.executeUpdate(sql);response.sendRedirect("showing.jsp");stmt.close();conn.close();%>
提示为:标准表达式中数据类型不匹配。
org.apache.jasper.JasperException: An exception occurred processing JSP page /delete.jsp at line 20
17: Connection conn=DriverManager.getConnection(url,"","");18: Statement stmt=conn.createStatement();19: String sql="delete from student where stuno="+request.getParameter("id");20: stmt.executeUpdate(sql);21: response.sendRedirect("showing.jsp");22: stmt.close();23: conn.close(); 请问怎么解决!还有怎么对其进行修改!完整的,解决必追加奖励!
展开