[ÇóÖú]Õâ¸öselect²éѯÔõô²»ÐеÄ?

¡ñ£®ÌÎÌΣ¢¡ï

<%
dim username
dim password
username=request.Form("nametext")
password=request.Form("pwtext")
dim conn
dim rs
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
conn.open "provider=microsoft.jet.oledb.4.0;data source="&server.MapPath("usermanager.mdb")
rs.open "select * from userlogin where username="&username&" and password="&password&"",conn,1,1
if rs.bof=true then
session("statu")="ok"
%>
<script language="vbscript">
alert("µÇ½³É¹¦")
location.href="index.html"
</script>
<% else %>
<script language="vbscript">
alert("²»´æÔÚ´ËÓû§!!!")
location.href="index.html"
</script>
<% end if
conn.close
rs.close
set conn=nothing
set rs=nothing
%>

ÌáʾÊÇ:
Microsoft JET Database Engine ´íÎó '80040e10'
ÖÁÉÙÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ¡£
/asp/login.asp£¬ÐÐ19

·ïǾ¡èõäõÑ

"select * from userlogin where username="&username&" and password="&password&""
usernameºÍpasswordÊÇʲôÀàÐ͵Ä×ֶΣ¿

lianeh

rs.open "select * from userlogin where username='"&username&"' and password='"&password&"'",conn,1,1

¾‰Š}_ƒÌ½Aýˆ

¶¥3Â¥

ÂèÂèÖíµÄÒ»Ìì

¶¥3Â¥

·¢Ö¸µÄÇà´º

ͬ3¥
Â¥Ö÷ÄãҪעÒâ±äÁ¿µÄÊý¾ÝÀàÐͺÍÊý¾Ý¿âÖеÄ×ֶεÄÊý¾ÝÀàÐ͵ĶÔÓ¦¡£¡£

ÎÞÃñ

лÁË!¸÷λÈÈÐĵĸßÊÖÃÇ!!ÎÊÌâÒѽâ¾ö.ÔÚÕâѧÁ˲»ÉٵĶ«Î÷."×öÈ˺ܵ͵÷"ºÜÈÈÐĵÄ.ÎÒµÄÿ¸öÌùËû¶¼ºÃÏñÓлØ.

Rain

ÎÒÏëÎÊÎÊ select * from userlogin where username="&username&" and password="&password&"",conn,1,1

ÕâÌõÓï¾ä£¬Èç¹ûuserlogin±íÖÐÓÐÁ½¸öÓû§ ±ÈÈç a ºÍb

ÓÃaµÄname,bµÄpassword ÕâÑùÊDz»ÊÇÒ²Äܲéѯ³öÀ´ £¿

¤¡Ì°¨¡.ÂD£¿

ͬ־£¬×¢Òâ¹ýÂËѽ¡£¡££¡