中文字幕一区二区人妻电影,亚洲av无码一区二区乱子伦as ,亚洲精品无码永久在线观看,亚洲成aⅴ人片久青草影院按摩,亚洲黑人巨大videos

上一篇：ADO 添加記錄 下一篇：ADO 刪除記錄

ADO 更新記錄

我們可使用 SQL 的 UPDATE 來更新數(shù)據(jù)庫表中的某條記錄。?

更新數(shù)據(jù)庫表中的記錄

我們希望更新 Northwind 數(shù)據(jù)中 Customers 表的某條記錄。首先我們需要創(chuàng)建一個表格，來列出 Customers 中的所有記錄。

<html>
<body>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open "SELECT * FROM customers",conn
%>

<h2>List Database</h2>
<table border="1" width="100%">
<tr>
<%
for each x in rs.Fields
??response.write("<th>" & ucase(x.name) & "</th>")
next
%>
</tr>
<% do until rs.EOF %>
<tr>
<form method="post" action="demo_update.asp">
<%
for each x in rs.Fields
??if lcase(x.name)="customerid" then%>
????<td>
????<input type="submit" name="customerID" value="<%=x.value%>">
????</td>
??<%else%>
????<td><%Response.Write(x.value)%></td>
??<%end if
next
%>
</form>
<%rs.MoveNext%>
</tr>
<%
loop
conn.close
%>
</table>

</body>
</html>

如果用戶點擊 "customerID" 列中的按鈕，會打開一個新文件 "demo_update.asp"。此文件包含了創(chuàng)建輸入域的源代碼，這些輸入域基于數(shù)據(jù)庫中記錄的字段，同時也含有一個保存修改的"更新按鈕"：

<html>
<body>

<h2>Update Record</h2>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"

cid=Request.Form("customerID")

if Request.form("companyname")="" then
??set rs=Server.CreateObject("ADODB.Recordset")
??rs.open "SELECT * FROM customers WHERE customerID='" & cid & "'",conn
??%>
??<form method="post" action="demo_update.asp">
??<table>
??<%for each x in rs.Fields%>
??<tr>
??<td><%=x.name%></td>
??<td><input name="<%=x.name%>" value="<%=x.value%>"></td>
??<%next%>
??</tr>
??</table>
??<br><br>
??<input type="submit" value="Update record">
??</form>
<%
else
??sql="UPDATE customers SET "
??sql=sql & "companyname='" & Request.Form("companyname") & "',"
??sql=sql & "contactname='" & Request.Form("contactname") & "',"
??sql=sql & "address='" & Request.Form("address") & "',"
??sql=sql & "city='" & Request.Form("city") & "',"
??sql=sql & "postalcode='" & Request.Form("postalcode") & "',"
??sql=sql & "country='" & Request.Form("country") & "'"
??sql=sql & " WHERE customerID='" & cid & "'"
??on error resume next
??conn.Execute sql
??if err<>0 then
????response.write("No update permissions!")
??else
????response.write("Record " & cid & " was updated!")
??end if
end if
conn.close
%>

</body>
</html>
上一篇：ADO 添加記錄 下一篇：ADO 刪除記錄