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

Çó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


Ïà¹ØÎÊ´ð£º

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

sql ²éѯ

  ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ

ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......

Ò»ÌõsqlÓï¾ä

# Student(S#,Sname,Sage,Ssex) ѧÉú±í   
# Course(C#,Cname,T#) ¿Î³Ì±í   
# SC(S#,C#,score) ³É¼¨±í   
# Teacher(T#,Tname) ½Ìʦ±í   
ÇóÒ»sql:
°Ñ ......

SQLÎÊÌ⣿

[code=select a.fyear,b.fname,sum(a.fendbal) as fendbal,
'1ÔÂ'=case when fperiod=1 then sum(a.fendbal) else 0 end ,
'2ÔÂ'=case when fperiod=2 then sum(a.fendbal) else 0 end ,
& ......

sqlÎÊÌâ

´ó¼ÒºÃsqlÓï¾äÖеļÈÓÖÎÊÌâÔõô´¦Àí°¡£¬±ÈÈç²éѯ¼ÈÑ¡ÔñÁËÊý¾Ý¿âÓÖÑ¡ÔñÁ˲Ù×÷ϵͳµÄѧÉúÐÕÃû
ÊÇ·Ö±ð²éѯȻºóºÏ²¢Âð£¿


End_rbody_60302787//-->
¸Ã»Ø¸´ÓÚ2009-10-10 11:14:51±»°æÖ÷ɾ³ý


¶ÔÎÒÓÐÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ