编辑和删除
删除和编辑的代码怎么写啊
2007-06-18 14:14
2007-06-18 14:27
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver(*.mdb)};dbp="&server.mappath("show.mdb")"
name=request.form("name")
age=request.form("age")
sex=request.form("sex")
province=request.form("province")
tel=request.form("tel")
remark=request.form("remark")
exec="insert into info(name,age,sex,province,tel,remark)values
('"+name+","+age+",'"+sex+"','"+province+"','"+tel+"','"+remark+"')"
conn.execute exec
conn.close
set conn=nothing
respone.write="添加记录成功"
%>
2.adddata.html 用户操作界面
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="add.asp">
<label>name
<input type="text" name="name">
</label>
<p>
<label>age
<input type="text" name="age">
</label>
</p>
<p>
<label>sex
<input type="text" name="sex">
</label>
</p>
<p>
<label>province
<input type="text" name="province">
</label>
</p>
<p>
<label>tel
<input type="text" name="tel">
</label>
</p>
<p>
<label>remark
<input type="text" name="remark">
</label>
</p>
<p>
<label>
<input type="submit" name="Submit" value="确定">
</label>
<label>
<input type="reset" name="Submit2" value="重置">
</label>
<label>
<input type="submit" name="Submit3" value="查看">
</label>
</p>
</form>
</body>
</html>
2007-06-18 14:29
2007-06-18 16:07
2007-06-18 17:46
2007-06-18 18:46
2007-06-18 19:26