access sql语句问题

来源:百度知道 编辑:UC知道 时间:2024/06/26 02:05:32
<!--#include file="safe.asp"-->
<!--#include file="md5.asp"-->
<%
dim db
set db=server.createobject("adodb.connection")
db.open "dbq="&server.mappath("l#e#a#vemessage.mdb")&";driver={microsoft access driver (*.mdb)}"
dim rs
set rs=server.createobject("adodb.recordset")
dim strsql,admin_name,admin_password,new_password
admin_name=trim(request.form("admin_name"))
admin_name=md5(admin_name,32)
admin_password=trim(request.form("admin_password"))
admin_password=md5(admin_password,32)
new_password=trim(request.form("new_password"))
new_password=md5(new_password,32)
strsql="update useradmin set adminpassword='" & new_password & "' where adminname='" & admin_name & "' and adminpassword='" & admin_password & "'"
rs.open strsql,db,1,3
i

<!--#include file="safe.asp"-->
<!--#include file="md5.asp"-->
<%
dim db
set db=server.createobject("adodb.connection")
db.open "dbq="&server.mappath("l#e#a#vemessage.mdb")&";driver={microsoft access driver (*.mdb)}"
dim rs
set rs=server.createobject("adodb.recordset")
dim strsql,admin_name,admin_password,new_password
admin_name=trim(request.form("admin_name"))
admin_name=md5(admin_name,32)
admin_password=trim(request.form("admin_password"))
admin_password=md5(admin_password,32)
new_password=trim(request.form("new_password"))
new_password=md5(new_password,32)
strsql="select * from useradmin where adminname='" & admin_name & "' and adminpassword='" & admin_password & "'"
rs.open strsql,db,1,3
if rs.eof and rs.bof then
r