ż±È½Ï²Ë£¬ÏëÎÊÏÂOracleÆóÒµ¹ÜÀíÆ÷ÖÐÔõÑù²éѯÊý¾Ý°¡£¿
ÎÒÔõôֻÄÜ¿´µ½±íµÄÐÅÏ¢£¬¿´²»µ½¾ßÌåÊý¾ÝÄÇ£¿×¢£ºÅ¼ÖªµÀÔõôÓÃSQLÓï¾ä²é£¬ËùÒÔÇëÖ±½Ó¸æËßÎÒÔõôÔÚÆóÒµ¹ÜÀíÆ÷Öп´µ½Êý¾Ý¡£Ð»Ð»¸÷λ°ïæ¡£
ÆóÒµ¹ÜÀíÆ÷ûÓвéѯÊý¾ÝµÄµØ·½ ½¨Òé×°Ò»¸öPL/SQL DEVELOPER»òÕßTOAD£¬ºÜºÃÓà µ±È»,sqlplusÒ²²»´í ÔÚEMÀïÑ¡ÖÐÄ¿±ê±í£¬ÓҲࡰ²Ù×÷¡±À¸µÄÏÂÀ¿òÀÓС°²é¿´Êý¾Ý¡±Ñ¡ÏѡÔñÖ®£¬È»ºóµ¥»÷¡°¿ªÊ¼¡±°´Å¥£¬¼´¿É¿´¼û±íÄÚ¾ßÌåÊý¾Ý¡£ ѧϰÁË Ôڲ鿴Êý¾ÝµÄͬʱ£¬Ò²¿ÉÊÇÉè¼Æ²éѯϸ½Ú£¬¼´¹ýÂËÌõ¼þ¡£°´ÕÕÒ³ÃæÌáʾÀ´×ö¡£ÒýÓà ÎÒÔõôֻÄÜ¿´µ½±íµÄÐÅÏ¢£¬¿´²»µ½¾ßÌåÊý¾ÝÄÇ£¿×¢£ºÅ¼ÖªµÀÔõôÓÃSQLÓï¾ä²é£¬ËùÒÔÇëÖ±½Ó¸æËßÎÒÔõôÔÚÆóÒµ¹ÜÀíÆ÷Öп´µ½Êý¾Ý¡£Ð»Ð»¸÷λ°ïæ¡£ oracleÀïÃæÃ»ÓÐÆóÒµ¹ÜÀíÆ÷°É£¬ÄãÔÚplsqlÀïÃæ¿ÉÒÔÓÃsql²éѯÓï¾ä¿´µ½µÄ¡£ »òÕßÔÙsqlplusÒ²¿ÉÒÔ¿´µ½µÄ¡£ 2Â¥µÄ£¬Ê×ÏȸÐлÄãµÄ»Ø´ð¡£²»¹ýÎÒûÕÒµ½Å¶¡£ÎÒÓõÄÊÇ9I¡£ ¶÷£¬ÎÒÒÔΪÄãÖ¸µÄÊÇ10g¡£ 9iÔÚ±íÉϵãÓÒ¼ü£¬ºÃÏóÓиöʲô¡°ä¯ÀÀĿ¼ÄÚÈÝ¡±Ê²Ã´µÄÑ¡Ïî¡£ºÜ¾Ã²»ÓÃ9iÒÔ¼°ORACLEÆóÒµ¹ÜÀíÆ÷ÁË£¬Ó¡ÏóÄ£ºý¡£Äã×ÐϸÕÒÕÒÓÒ¼ü²Ëµ¥¡£ 9iµÄÕâ¸öÕæÃ»ÓС£¡£¡£ ÎÞÂÛ9i»¹ÊÇ10g£¬ÆóÒµ¹ÜÀíÆ÷Àï¶¼¿ÉÒÔÖ±½Óä¯ÀÀ±íÊý¾Ý¡£ ²»ÖªµÀÊDz»ÊÇÎÒÌ«±¿ÁË£¬Ã»ÓÐÕÒµ½¡£ Ī·ÇÕæµÄûÓÐÂ𣿠ºÇºÇ£¬ÎÒÔø¾ÓÃËü²é¿´¹ý±íÊý¾Ý¡£¸æËßÎÒQ£¬Ô¶³ÌÐÖú£¬³ý·ÇÄã½øµÄ²»ÊÇÆóÒµ¹ÜÀíÆ÷¡£ 9iÔÚÆóÒµ¹ÜÀíÖÐÓÒ¼ü±íÃû³Æ£¬Óиö¡°±íÊý¾Ý±à¼Æ÷¡±ÀïÃæÓжÔÓ¦µÄÊý¾Ý~~~ ллsuiziguo£¬tianyihuyidao30£¬ÔÚÄãÃǵİïÖúÏÂÎÒÖÕÓÚÕÒµ½ÁË£¬ÔÚ9IÀïÓ¦¸ÃÊÇÓÒ¼ü²é¿´¡¢±à¼Ä¿Â¼¡£
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......