Çósql²éѯÓï¾ä
t_a{
id ,
name,
age,
pid, ¶ÔÓ¦t_b(id)
}
t_b{
id£¬
ywlx£¬
}
±¾ÈËÏëÓÃ
ÕâÖÖÀàÐ͵IJéѯ
String sql = "select name,age,ywlx from t_a where 1=1";
String sql+="(ÆäËûµÄÌõ¼þ²¹³ä)"; --ÆäËûËùÐèµÄÌõ¼þ¼ÓÔÚÕâÐÐÀïÃæ£¬
ÉÏÃæµÄ"select name,age,ywlx from t_a where 1=1";Óï¾ä¹Ì¶¨£¬
ÊÔÎÊÓÐûÓÐʲôºÃµÄ°ì·¨À´´¦Àí£¿£¿£¿£¿
¼±£¡£¡£¡ ÔÚÏߵȡ£¡£¡£¡£¡£
лл£¡£¡£¡
String sql+="(ÆäËûµÄÌõ¼þ²¹³ä)"; --ÆäËûËùÐèµÄÌõ¼þ¼ÓÔÚÕâÐÐÀïÃæ£¬
String sql+="and Ìõ¼þÓï¾ä"; --²»¾ÍOK?
ywlxÕâ¸ö×Ö¶ÎËû»á±¨ ÕÒ²»µ½ µÄ ÎÒµÚÒ»ÌõsqlÓï¾äÀïÃæ¾Ífrom t_aѽ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
ÓÐûÓÐÆäËûºÃµÄ·½·¨
Çë½Ì~£¡£¡£¡£¡
String sql = "select name,age,ywlx from t_a where 1=1";
String sql+="(ÆäËûµÄÌõ¼þ²¹³ä)"; --ÆäËûËùÐèµÄÌõ¼þ¼ÓÔÚÕâÐÐÀïÃæ£¬
ÉÏÃæµÄ"select name,age,ywlx from t_a where 1=1";Óï¾ä¹Ì¶¨£¬
ÄÇÄã¿ÉÒÔÕâÑù×Óд:
SQL code:
String sql = "select name,age,ywlx
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
´ó¼ÒºÃsqlÓï¾äÖеļÈÓÖÎÊÌâÔõô´¦Àí°¡£¬±ÈÈç²éѯ¼ÈÑ¡ÔñÁËÊý¾Ý¿âÓÖÑ¡ÔñÁ˲Ù×÷ϵͳµÄѧÉúÐÕÃû
ÊÇ·Ö±ð²éѯȻºóºÏ²¢Âð£¿
End_rbody_60302787//-->
¸Ã»Ø¸´ÓÚ2009-10-10 11:14:51±»°æÖ÷ɾ³ý
¶ÔÎÒÓÐÓ ......
SQL code:
exec sp_decrypt1 'EL_SP_AdminComment' ÎÒÏ뽫ִÐеĽá¹û´æÔÚÒ»¸ö±äÁ¿ÖÐ
==
ÒýÓÃ
SQL codeexec sp_decrypt1'EL_SP_AdminComment' ÎÒÏ뽫ִÐеĽá¹û´æÔÚÒ»¸ö±äÁ¿ÖÐ
·Å ......