Çó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 table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ
ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......
# Student(S#,Sname,Sage,Ssex) ѧÉú±í
# Course(C#,Cname,T#) ¿Î³Ì±í
# SC(S#,C#,score) ³É¼¨±í
# Teacher(T#,Tname) ½Ìʦ±í
ÇóÒ»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Óï¾äÖеļÈÓÖÎÊÌâÔõô´¦Àí°¡£¬±ÈÈç²éѯ¼ÈÑ¡ÔñÁËÊý¾Ý¿âÓÖÑ¡ÔñÁ˲Ù×÷ϵͳµÄѧÉúÐÕÃû
ÊÇ·Ö±ð²éѯȻºóºÏ²¢Âð£¿
End_rbody_60302787//-->
¸Ã»Ø¸´ÓÚ2009-10-10 11:14:51±»°æÖ÷ɾ³ý
¶ÔÎÒÓÐÓ ......