技术资料 > ASP技术 > 客户端相关 : 数据库记录的表格显示，编辑与更新

数据库记录的表格显示，编辑与更新

March 25,2004

<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>