onnection("jdbc:mysql://localhost:3307/school","root","ylx"); Statement stmt = con.createStatement();
String sql="update book set bookname='"+bookname+"',author='"+author+"',price="+price+" where id="+id;
int i=stmt.executeUpdate(sql); if(i==1) {
out.println("");
response.setHeader("refresh","1;url=index.jsp");
}
stmt.close(); con.close(); %>
Del.jsp
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" pageEnconding="gb2312"%>
<%
request.setCharacterEncoding("gb2312"); Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3307/school","root","ylx"); Statement stmt = con.createStatement(); String id=request.getParameter("id");
int i=stmt.executeUpdate("delete from book where id="+id); if(i==1) {
out.println("");
response.setHeader("refresh","1;url=index.jsp"); } else{
out.println("");
response.setHeader("refresh","1;url=index.jsp"); }
con.close(); stmt.close(); %>
Error.jsp
<%@ page language="java" isErrorPage="true" pageEncoding="gb2312"%>
错误信息为
<%=exception.getMessage()%>
<%=exception.toString()%>