<%
id = Request("id")
newpassword = Request("password")
newpasswordtemp = Request("passwordtemp")
If newpassword <> newpasswordtemp Then
Response.Write "<center>對不起,新密碼與新密碼確認不同.請重試!</center>"
Response.End
End If
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("userinfo.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
Set rs = Server.CreateObject("ADODB.Recordset")
sql="update userinfo set 密碼='" & newpassword & "' where id="&id
rs.Open sql, conn, adOpenDynamic, adLockPessimistic
%>
[1]