jsp¹ØÓÚ±í¸ñɾ³ýÒ»ÐеÄÎÊÌâ
Ô´´úÂëÈçÏ£º
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*"%>
<%
String bookId="";
String sql = "";
try{
bookId = request.getParameter("bookId");
Connection con;
Statement stmt;
Class.forName("com.mysql.jdbc.Driver");
//×¢²áMySQLÇý¶¯³ÌÐò
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//ÓÃÊʵ±µÄÇý¶¯³ÌÐòÁ¬½Óµ½Êý¾Ý¿â
String dbUrl = "jdbc:mysql://localhost:3306/bookdb?useUnicode=true&characterEncoding=GB2312";
String dbUser="dbuser";
String dbPwd="1234";
//½¨Á¢Êý¾Ý¿âÁ¬½Ó
con = java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
stmt = con.createStatement();
sql="DELETE from books WHERE id="+ bookID;
stmt.executeUpdate(sql);
stmt.close();
con.close();
response.sendRedirect("list.jsp");
}catch(Exception e){
session.setAttribute(&q
Ïà¹ØÎÊ´ð£º
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
Óм¸ÖÖÓû§£¬ÆäȨÏÞ²»Í¬¡£Ö»ÓÐÌØ¶¨È¨ÏÞµÄÓû§²ÅÄܽøÐÐÏàÓ¦²Ù×÷¡£ÎÒÏëÔÚjspÒ³ÃæÀï½øÐÐÕâ¸öÉèÖÃ
<input type="submit" value="ÐÞ¸Ä"/> ,ÎÒÏëÈÃÖ»ÓÐÌØ¶¨È¨ÏÞµÄÓû§²ÅÄܰ´Õâ¸ö°´Å¥£¬·ñÔò±¨ ......
Óм¸¸öÎÊÌâÂé·³Çë½ÌÒ»ÏÂ
¶÷£¬ÎÊÌâ±È½Ï¶à£¬Õæ²»ºÃÒâ˼À²
1.jsp¿ª·¢×öÒ³ÃæÏÔʾµÄʱºò£¬ÄÇЩ°´Å¥£¬ÁÐ±í£¬²éѯ¿ò£¬¶àtab±êÇ©µÈµÈÕâЩÏÔʾµÄÓ¦¸Ã½Ð×ö¿Ø¼þµÄ¶«Î÷£¬ÊÇ·ñÓпªÔ´µÄ×é¼þ¿ÉÒÔÄÃÀ´ÓÃÄØ£¿Õâ¸öÎÒ²»ÊǺÜÊìϤ£¬ ......
ÒªÓÃjspÖÆ×÷Ò»¸ö¶¯Ì¬¼à¿ØÒ³Ã棬ȫ²¿µÄÊý¾Ý¶¼´æÔÚÊý¾Ý¿âÀҲ¾ÍÊÇÎÒÕâ¸öÒ³ÃæÒªÄÜʵʱ¶ÁÈ¡Êý¾Ý¿âµÄÐÅÏ¢£¬ÇëÎʸ÷λ´óÏÀÓÐʲôºÃÌáÒé°¡£¿
ÓÐûÄÄλ´ó¸ç¸øµãºÃµÄÌáÒé°¡£¬Ð¡µÜ¶àлÁË~~
ÓÃajax°É£¬ÊµÊ±µÄ¼à¿Ø¡£
崃 ......