Çó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°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
Ñ¡³öÊý¾Ý¿âÖÐÈ«²¿µÄ ÒÔ el_ ¿ªÍ·µÄ ´æ´¢¹ý³ÌÃû
ÒÔ¿Õ¸ñ¸ô¿ª
ÒýÓÃ
ÒÔ¿Õ¸ñ¸ô¿ª
SQL code:
declare @s varchar(8000)
select
@s=isnull(@s+' ','')+name
from
sys.objects
where
......