日期:2014-05-16 浏览次数:21039 次
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="Microsoft Theme" content="loosegst 011, default">
<meta name="Microsoft Border" content="tl, default">
</head>
<body>
<form name="form1" method="post" action="exam7.asp">
请输入删除的学生学号:
<input type="text" name="id">
<input type="submit" name="Submit" value="提交">
</form>
</body>
</html>
<body>
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("fpdb/lianxi1.mdb")
%>
<%
temp=Request.Form("id")
exec="delete * from lianxibiao1 where 学号 = 'temp' "
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<%response.write "删除成功!"%>
</body>