数据库记录的表格显示,编辑与更新
发表时间:2024-06-14 来源:明辉站整理相关软件相关文章人气:
[摘要]<html><head> <title>authoredit.asp</title> </head><body bgcolor="#FFFFFF"> <% ' My ASP program t...
<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> (出处:热点网络)