|
数据库记录的表格显示，编辑与更新 |
作者： 发布时间：2005-03-12 来源：
|
<html><head>
<title>authoredit.asp</title>
</head><body bgcolor="#FFFFFF">
<%
' My ASP program that given an AU_ID, allows editing a record
myDSN="DSN=Student;uid=student;pwd=magic"
set conntemp=server.createobject("adodb.connection")
conntemp.open myDSN
form_ID=request.querystring("which")
sqltemp="select * from authors "
sqltemp=sqltemp & " where AU_ID=" & form_id
set rstemp=conntemp.execute(sqltemp)
form_auID=rstemp("AU_ID")
form_author=rstemp("Author")
form_year_born=rstemp("Year_Born")
rstemp.close
set rstemp=nothing
conntemp.close
set conntemp=nothing
%>
<body>
<form name="myauthor" action="authoreditrespond.asp" method="POST">
<input type="hidden" name="id" value="<%=form_auid%>">
<p>Author ID: <%=form_auid%></p>
<p> Author Name:
<input type="TEXT" name="name" value="<%=form_author%>"></p>
<p> Year Born:
<input type="TEXT" name="year" value="<%=form_year_born%>"></p>
<p> <input type="SUBMIT"> </p>
</form> |
| |
|
|
|
