SQL Server對數(shù)據(jù)進(jìn)行刪除，把頁面的信息從數(shù)據(jù)庫刪除。

     <table border=1px  style="width:500px;height:200px;text-align:center;margin: 0 auto">      <tr style="background:red">          <td>編號</td>           <td>書名</td>            <td>價(jià)格</td>             <td>喜愛度</td>              <td>作者</td>              <td>刪除</td>              <td>修改</td>        </tr>          <%           //引用連接數(shù)據(jù)庫方法         sqlServer sq=new sqlServer();           //得到數(shù)據(jù)庫連接          Connection con = sq.getConnection();           //編寫sql語句          String sql="select * from Dog";                       //得到數(shù)據(jù)庫對象操作           Statement st=con.createStatement();            // 得到查詢的結(jié)果            ResultSet rs = st.executeQuery(sql);      while(rs.next()){                       %> <tr>             <td> <%out.PRint(rs.getInt(1) + "/t"); %></td>                                        <td> <%out.print(rs.getString(2) + "/t"); %></td>                                        <td> <%out.print(rs.getInt(3) + "/t"); %></td>                                      <td> <%out.print(rs.getInt(4)+"%" + "/t"); %></td>                               <td> <%out.println(rs.getString(5)+ "/t"); %></td>                          <td> <a href="Delect.jsp?id=<%out.print(rs.getInt(1) + "/t"); %>">刪除</a></td>             <td> <a href="Update.jsp?id=<%out.print(rs.getInt(1) + "/t"); %>">修改</a></td>              </tr><%           }                          //釋放資源          sq.ShiFang(rs,st,con);             %>                    </table>

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%@page import="jdbc.sqlServer"%><%@page import="java.sql.Connection"%><%@page import="java.sql.PreparedStatement"%><%String id = request.getParameter("id");id = new String(id.getBytes("ISO-8859-1"),"utf-8");   //引用連接數(shù)據(jù)庫方法  sqlServer sq=new sqlServer();    //得到數(shù)據(jù)庫連接   Connection con = sq.getConnection();    //編寫sql語句 String sql="delete  from  Dog  where id=" + id + "";      //得到數(shù)據(jù)庫操作對象  PreparedStatement st =con.prepareStatement(sql);     // 得到查詢的結(jié)果if(st.executeUpdate()>0){%>     <script type="text/Javascript">    alert("刪除成功");        location="showLog.jsp";    </script>    <%          }else{                    %>       <script type="text/javascript">            alert("刪除失敗");                        location="showLog.jsp";        </script>   <%                       } %>