sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6Ã룬ȥµôÈÎÒâÒ»Ìõ¼þºó£¬ÈçÏ£º
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 '
Õâ¸öÖ´ÐÐʱ¼ä0.015Ãë¡£
×¢£ºÉÏÃæµÄSQLÓï¾äÊÇhibernate×Ô¶¯Éú³ÉµÄ¡£
ÔÙ¿´¿´ÕâÑùÒ»¸öSQL,×Ô¼ºÐ´µÄ¡£²éѯ½á¹ûÓëµÚÒ»¾äSQLÍêÈ«Ò»Ñù¡£µ«²éѯʱ¼äÏà¹ØÉõÔ¶¡£
select * from fx_returnbookchecklist where returnid='00025.S0000001' and bookid='164'
Õâ¸öÖ»Ðè0.031Ãë¡£
Çë´ó¼Ò°ïæ·ÖÎöÕâÊÇʲôÔÒòµ¼Öµģ¿£¿ÊDz»ÊÇhibernate?
returnbookchecklist ±íÓжàÉټǼ£¿
Âú×ãÌõ¼þreturnid='00025.S0000001' and bookid='164'ÓжàÉټǼ£¿
returnbookchecklistÓÐÊý¾Ý70¶àÍò£¬Âú×ãÌõ¼þreturnid='00025.S0000001' and bookid='164'ÓÐ1Ìõ¼Ç¼£¬Õâ¸öÎÊÌâÒѽâ¾ö£¬¿Õ¸ñÔì³É£¬µ«ÊÇеÄÒ»¸öÎÊÌâÓÖ³öÀ´ÁË¡£
select b.returnid
from fx_returnbookchecklist b
where b.returnid='00025.S0000001'
ÕâÑùÒ»¸öSQL²éѯËÙ¶È0.047Ã룬
select b.scale
from fx_returnbookchecklist b
where b.returnid='00025.S0000001'
ÏÖÔÚÖ»ÊDzéÁËÏàͬ±íÖÐÁíÒ»¸ö×Ö¶ÎscaleÖ´ÐÐʱ¼ä2.578Ã룬±¾ÒÔΪÊÇË÷ÒýµÄÔÒò£¬ÓÖ×öÁËÒ»¸ö²âÊÔÈ¡Âú×ãÌõ¼þÐеÄÖ÷¼üÖµ
select b.id
from fx_returnbookchecklist b
where b.returnid='00025.S0000001'
ͬÑùÖ´ÐÐÁË2.641Ãë¡£Ö»ÓÐÒ»¸ö×Ö¶ÎËüµÄ²éѯËÙ¶ÁºÜ¿ì¡£ÆäËû¶¼ºÜÂý¡£
select b.scale,b.netamo
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
°²×°ÁËOracle 10g£¬Ä¬ÈÏ°²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......