asp 刪除數據庫記錄入門教程

　　asp教程 刪除數據庫教程記錄入門教程
<script>
 function check()
 {
  if(confirm(確認刪除))
  {
   //操作
  }
 }
</script>
<table width="" border="">
  <tr>
    <td width="">a</td>
    <td width="">b</td>
  </tr>
  <tr>
    <td>wwwliannet </td>
    <td><a href="?id=" onClick="check();">刪除</a></td>
  </tr>
</table>
<?
//asp 刪除數據庫記錄入門教程
  SiteDb ="Database/mdbmdb"
  Set Conn = ServerCreateObject("AdodbConnection")
  ConnStr="Provider=MicrosoftJetOLEDB;Data Source=" & ServerMapPath(SiteDB)
  ConnOpen ConnStr
  Set Rs=ServerCreateobject("AdodbRecordSet")
 
  Dim sql
  sql ="delete from test where id="&requestquery("id")
  if rsexecute( sql ) then
   responsewrite("刪除成功")
  else
   responsewrite("刪除失敗")
  end if
 

From:http://tw.wingwit.com/Article/program/net/201311/14242.html