Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ASP ·ÃÎÊsqlÓï¾ä³ö´í Õû¸öÍøÕ¾¿¨ËÀ - Web ¿ª·¢ / ASP

iis 6µÄ°æ±¾£¬ÀýÈç²ÎÊý´«µÝ ³ö´í sql=¡°select * from tb where id=¡±

È»ºó¾Í»áÒ»Ö±¼ÓÔØ£¬ÆäËûÒ³ÃæÒ²·ÃÎʲ»ÁË£¬Õû¸öÍøÕ¾¾ÍºÃÏñ¿¨×¡ÁË

ÔõÑù´¦ÀíʹËû²»¿¨×¡
sqlÓï¾äÖÐµÄ Êý¾Ý¿â ÄÜ·ÃÎÊÂð£¿

Ã÷ÏÔÊÇsqlÓï¾äд´íÁËÂð£¡Äã²»»á°ÑsqlÓï¾äдѭ»·ÀïÁ˰ɣ¿

responseÏ¿´¿´Ã´¡£¡£Óï¾äûÎÊÌâ°¡¡£

YÓ﷨д¶Ôû

sql=¡°select * from tb where id=¡±
=============
ÄãÕâ¸öID=ºóÃæÃ»ÓУ¬ÏµÍ³Ó¦¸ÃĬÈÏΪÊǿգ¬ÄÇôËû¾ÍÏñÊÇÒ»¸öËÀÑ­»·Ò»Ñù

Õâôд¡£¡£¡£¡£²»ËÀ²Å½Ð¹ÖÊ¡£¡£¡£

ÏÈÅжϲÎÊý

Òò¸ÃÊÇÑ­»·Ò»Ö±ÔÚ¼ÌÐø°Ñ£¬¿ÉÄÜÉÙÁËrs.movenextÖ®Àà

Ä¿±ê²»Ã÷È·µ±È»ÒªËÀ£¬ÄãÏëÏëÄãÉÏÁË1¸öÔ°࣬ȥ¶Ô¹«Ë¾Ö÷¹Ü˵£º¡°·¢ÎÒÕâ¸öÔ¹¤×Ê=¡±£¬±ðÈË·¢Äã10¿éÄã²»ËÀ£¿

ÓÐÒâ˼...
ÒýÓÃ
Ä¿±ê²»Ã÷È·µ±È»ÒªËÀ£¬ÄãÏëÏëÄãÉÏÁË1¸öÔ°࣬ȥ¶Ô¹«Ë¾Ö÷¹Ü˵£º¡°·¢ÎÒÕâ¸öÔ¹¤×Ê=¡±£¬±ðÈË·¢Äã10¿éÄã²»ËÀ£¿


¼Ó¸ötry catch °É

ÏÈÅжϲÎÊýÊÇ·ñ·ûºÏÂï¡£
idΪÊý×ÖÐ굀 ÅжÏif not isnumeric(id) then id = 0
idΪ×Ö·ûÐ굀 ¾ÍÅжÏÊÇ·ñΪ¿Õ

id=¡± 
Ïȶ¨Òåô£¿

Óï¾äÊÇ·ñдÍêÓ´£¡whereºóÃæµÄidûÓÐÖµ£¬ÄܼÌÐøÏÂÈ¥Âð£¿

response.write sqlÓï¾ä
Response.End

ÏÈÈ¡µÃidµÄÖµ£¬Èç
id=request("id")
sql=¡°select * from tb where id="&id


ÎÊÌâû³öÔÚÕâÀï°É£¬¸ÕÈÈÐÐÁËһϣ¬Óï¾ä»á³ö´í

¡°select * from tb where id=¡± ÒýºÅÊÇÖÐÎĵġ£¡£¡£¡£¡£

ÎÒµÄÒâ˼´ó¼Ò¶¼Ã»Ã÷°×£¬ÎÒÏëÊÇÔÚsqlÓï¾ä³ö´íµÄʱºòiis±¨¸ö´íÎ󣬶ø²»ÏÝÈëËÀÑ­»·

ÊDz»ÊÇûÕâ¸ö


Ïà¹ØÎÊ´ð£º

ÇóÒ»¸öÔÚÏß²âÊÔϵͳ aspµÄ - Web ¿ª·¢ / ASP

http://www.zgjhjy.com/Test/PrimaryTest/Index.aspx
¾ÍÊÇÀàËÆÒÔÉϵÄÔÚÏß²âÊÔϵͳ£¬ÐèÒªÓÐÒ»¸öºǫ́µÄ£¬ÓïÑÔÊÇaspµÄ£¬Êý¾Ý¿âÊÇaccessµÄ£¬»¹ÐèÒªÄÜÔÚºǫ́¶ÔÐÅÏ¢½øÐÐÌíɾ¸Ä²éµÄ¡£Ð»Ð»¸÷λÁË¡£¡£¡£
³ÌÐòÕæµÄºÜ¶à£¬²»Öª ......

¶¯Ì¬È¡µÃaspÀà³ÉÔ±

ÓÐÒ»¸öÀà
class adc
{
dim a,b,c
}
ÈçºÎÔÚÁíÍâÒ»¸öÀàÖÐÈ¡µÃÀà³ÉÔ±¼°³ÉÔ±¸öÊý
class getmenber
{
dim menbers()
function getmenbers(resclass)
'resΪһδ֪Àà
'getmenber ......

asp µ÷ÓÃjavaдµÄwebservice - Web ¿ª·¢ / ASP

ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
  <part name="bstrPnrNO" type="s:string" /> 
  <part name ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ