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

¸ß¼¶sqlÓï¾ä²éѯ Çó½â - Java / Java EE

ÈÕÆÚ ÊÇ·ñ
2010-03-09 ÊÇ
2010-03-09 ÊÇ
2010-03-09 ·ñ
2010-03-09 ·ñ
2010-03-10 ÊÇ
2010-03-09 ·ñ
2010-03-09 ·ñ

²éѯ»ØÀ´µÄ½á¹û

ÈÕÆÚ ÊÇ ·ñ
2010-03-09 2 2
2010-03-09 1 2

Ï£ÍûÇ××ÔÊÔÑéºóÔÚ¸øÓÚ´ð¸´...ÖØÒªµÄÊÇÂß¼­...²»ÊÇС¼¼ÇÉ..Thank youÃÇ....
- -

ÈÕÆÚ ÊÇ ·ñ
2010-03-09 2 2
2010-03-09 1 2

¿´²»¶®ÁË

²»Ã÷°×lzµÄÎÊÌâ

×îºó
2010-03-10 ÊÇ
2010-03-09 ·ñ
2010-03-09 ·ñ
Ó¦¸Ã¶¼ÊÇ2010-03-10¾ÍÃ÷°×ÌâÄ¿µÄÒâ˼ÁË

´ó¼Ò¶¼¿´²»Ã÷°×¡£¡£¡£¡£


¿´ÁËÄãÒÔǰµÄÌù×Ó·¢ÏÖÕâ¸öÈËÓÐ벡

ÒýÓÃ
select ÈÕÆÚ£¬
count(case ÊÇ·ñ when 'ÊÇ' THEN ÊÇ·ñ else null end),
count(case ÊÇ·ñ when '·ñ' then ÊÇ·ñ else null end)
from table group by ÈÕÆÚ

lz¿ÉÒÔÉÏÍø²éһϽ»²æ±íÏà¹ØµÄ¶«Î÷£¬ÎÒÖ»ÊÇд¸öʾÀý




Èç¹ûʵÔÚ²»Ðеϰ¿ÉÒÔÓÃ×Ó²éѯ


ÔÚ³ÌÐòÀï´¦Àí²»ÊǸüºÃ  

int sign=´ÓÊý¾Ý¿âµÃµ½µÄÖµ=="ÊÇ"?1:2;


Ïà¹ØÎÊ´ð£º

FCKÉÏ´«Îļþµ½linux·þÎñÆ÷ÎÊÌâ - Java / Java EE

ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£

ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......

HTML±êÇ©µ×²ãµÄʵÏÖÔ­Àí¡¢»úÖÆ - Java / Java SE

ΪʲôHTMLÒÔ¼°Ò»Ð©ÆäËü±êÇ©»áÏÔÊ¾Ò»Ð©ÌØ¶¨±íÏÖÐÎÊ½ÄØ£¿ÈçHTMLÖеĻ»ÐбêÇ©<BR/>ÔڵײãÊÇÔõÑùʵÏÖµÄÄØ£¿ÏÖʵµÄÔ­ÀíÊÇÊ²Ã´ÄØ
È¥W3C¹Ù·½ÍøÕ¾ÉÏ£¬¿´¿´°É£¡ÎÒÏëÒ»¿´Äã¾ÍÃ÷°×ÁË

ÎҲºͱàÒëÔ­ÀíÓйأ¬ä¯ÀÀÆ÷Àï¿É ......

javaÖеÄ×¢½â¿ÉÒÔÓÐÄÄЩ£¿ - Java / Java EE

È磺 @superwaring("unchecked");
Õâ¸öÀïÃæ¶¼¿ÉÒÔÈ¡ÄÄЩֵ°¡£¬»¹ÓÐÀàËÆµÄ @superwaring±êÇ©ÓÐÄÄЩ°¡
ûÓùý¡£¡£

¿´jeeµÄapi
javax.persistenceÀï
@superwaring("unchecked");Ö»ÊǺöÂÔ ......

c/sºÍb/sÖ®¼äÔõôͨѶ. - Java / Web ¿ª·¢

ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾­ÀíʹÓÃ
»¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä,
ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò,
ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾ­Ìá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

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