ASPÅжϵÄÎÊÌâ,ÓôÃÆÁË!Åжϲ»³öÀ´!
HTML code:
dim jf
set conn=server.createobject("adodb.connection")
connstr="Driver={Sql Server};Server="&Sqlip&";Database="&Sqldb&";Uid="&SqlUid&";Pwd="&SqlPwd&";"
conn.Open connstr
Set RS=Conn.Execute("SELECT sum(cs) as ok from aaa WHERE (bbb='abc')")
jf=rs("ok")
if jf="" then
response.write"<script>alert('ÄãûÓзÖÊý!');history.go(-1);</Script>"
response.end
End If
µ±¼Ç¼Àïabc²»´æÔÚʱ
ºÍÓ¦¸ÃÊǿյİ¡!
ÎÒÕâ¸öÔõôÅжϲ»³öÀ´°¡!
if jf=null then
ÊÔ¹ýÁË!²»ÐÐ!
if jf=0 then
if jf=0 then ?
if isnull(jf) then ?
if isempty(jf) then ?
if isnull(jf) then
ÊÔÊÔ
ÏÈ trim ºóÔÙÅжϡ£
sum(cs)
³öÀ´µÄÊÇ0²»ÊÇnull
if jf="" then
¸ÄΪ
if jf=o then
if IsNull(jf) then
Ïà¹ØÎÊ´ð£º
aspÐéÄâÖ÷»úʵÏÖα¾²Ì¬µÄ·½·¨£º
1¡¢ ÖØÐ´url²ÎÊý
Step1: ½¨Á¢Ç°Ì¨Îļþindex.asp£¬ÐÞ¸Äurl²ÎÊýÐÎʽ¡£ÓÉÓÚ¶ÁÈ¡Êý¾Ý¿âÖеļǼ²»ÊÇרÌâµÄÖØµã£¬¹ÊÖ±½Ó¸ø³ö:
<!--#include file="config.asp" -->
&l ......
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
´ó¼ÒºÃ!ÎÒÊÇÒ»¸öѧÉú,ÏÖÔÚÊÇѧASPµÄ²»ÖªµÀÔõô»ØÊÂ,ÎÒ×Ô¼ºÊÇÓÃCMS×ö¹ýÍøÕ¾ ´úÂëÒ²ÄÜ¿´¶®Ò»µã ÏÖÔÚÏëÂò±¾Êé,Ïë·¨Óкܶà,¾ÍÊÇÏëÂòASPµÄ ÓÖ¿´µ½´ó¼Ò˵ASPÒÔºóûÓÐNETǰ¾°ºÃ,ÎÒÓÖÏëÔÙÈ¥Âò±¾ASP.NETµÄ ÎÒÖªµÀÓÐÕâÑùµÄÏë·¨ ......
¹ØÓÚasp.net md5 32λ¼ÓÃܽâÃÜ
ÓÐûÓÐÈË¿ÉÒÔд¸öÀà¡£
²¢Ïêϸ½âÊÍһϣ¬±¾È˺ܲ»Àí½â32λmd5
C# code:
public string md5(string str,int code)
2{
3 if(code==16) //16λMD5¼ÓÃÜ£¨È¡32λ¼ÓÃܵÄ9~25× ......
ÄÄÀïÓÐÃâ·ÑµÄASP.NET¿Õ¼ä£¿£¿Á·ÊÖÓÃµÄ Ð»Ð»
5944µÄ¿Õ¼äÊÇÆ×Ó£¬×Ô¼ºËÑÒ»ÏÂÊÔÊÔ£¬Ãâ·ÑµÄÓУ¬Ò»°ã¶¼ÊÇÈýÌìÊÔÓã¬Ò»¹ýÄã¾ÍÒª½»·ÑÁË
ÒýÓÃ
5944µÄ¿Õ¼äÊÇÆ×Ó£¬×Ô¼ºËÑÒ»ÏÂÊÔÊÔ£¬Ãâ·ÑµÄÓУ¬Ò»°ã¶¼ÊÇÈýÌìÊÔÓã¬Ò»¹ýÄ ......