java×öµÄϵͳ¸øÈ˵ÄÓ¡ÏóÊÇʲô£¿Õ¼Äڴ棡˵µÀÕâ¾ä»°¾Í»áÓÐN¶àÈËÕ¾³öÀ´Îªjava±ç»¤£¬²¢¾Ù³öÒ»¶ÑµÄÐÔÄܲâÊÔ±¨¸æÀ´Ö¤Ã÷ÕâÒ»µã¡£Æäʵ´ÓÀíÂÛÉÏÀ´½²java×öµÄϵͳ²¢²»±ÈÆäËûÓïÑÔ¿ª·¢³öÀ´µÄϵͳ¸üÕ¼ÓÃÄڴ棬ÄÇôΪʲôȴÓÐÕâôN¶àÀíÓÉÀ´Ö¤Ã÷ËüȷʵռÄÚ´æÄØ£¿Á½¸ö×Ö£¬ÂªÏ°¡£
£¨1£©±ðÓÃnew Boolean()¡£
Ôںܶೡ¾°ÖÐBooleanÀàÐÍÊDZØÐëµÄ£¬±ÈÈçJDBCÖÐbooleanÀàÐ͵ÄsetÓëget¶¼ÊÇͨ¹ýBoolean·â×°´«µÝµÄ£¬´ó²¿·ÖORMÒ²ÊÇÓÃBooleanÀ´·â×°booleanÀàÐ͵쬱ÈÈ磺
ps.setBoolean("isClosed",new Boolean(true));
ps.setBoolean("isClosed",new Boolean(isClosed));
ps.setBoolean("isClosed",new Boolean(i==3));
ͨ³£ÕâЩϵͳÖй¹ÔìµÄBooleanʵÀýµÄ¸öÊýÊÇÏ൱¶àµÄ£¬ËùÒÔϵͳÖгäÂúÁË´óÁ¿BooleanʵÀýС¶ÔÏó£¬ÕâÊÇÏ൱ÏûºÄÄÚ´æµÄ¡£BooleanÀàʵ¼ÊÉÏÖ»ÒªÁ½¸öʵÀý¾Í¹»ÁË£¬Ò»¸ötrueµÄʵÀý£¬Ò»¸öfalseµÄʵÀý¡£
BooleanÀàÌṩÁ½Á˸ö¾²Ì¬±äÁ¿£º
public static final Boolean TRUE = new Boolean(true);
public static final Boolean FALSE = new Boolean(false);
ÐèÒªµÄʱºòֻҪȡÕâÁ½¸ö±äÁ¿¾Í¿ÉÒÔÁË£¬
±ÈÈ磺
ps.setBoolean("isClosed",Boolean.TRUE);
ÄÇôÏó2¡¢3¾äÄÇÑùÒª¸ù¾ÝÒ»¸öboolean±äÁ ......
ʲôÊÇÁ÷£º
Á÷ÊÇÒ»¸ö³éÏóµÄ¸ÅÄî¡£µ±Java³ÌÐòÐèÒª´ÓÊý¾ÝÔ´¶ÁÈ¡Êý¾Ýʱ£¬»á¿ªÆôÒ»¸öµ½Êý¾ÝÔ´µÄÁ÷¡£Êý¾ÝÔ´¿ÉÒÔÊÇÎļþ£¬ÄÚ´æ»òÕßÍøÂçµÈ¡£Í¬Ñù£¬µ±³ÌÐòÐèÒªÊä³öÊý¾Ýµ½Ä¿µÄµØÊ±Ò²Ò»Ñù»á¿ªÆôÒ»¸öÁ÷£¬Êý¾ÝÄ¿µÄµØÒ²¿ÉÒÔÊÇÎļþ¡¢ÄÚ´æ»òÕßÍøÂçµÈ¡£Á÷µÄ´´½¨ÊÇΪÁ˸ü·½±ãµØ´¦ÀíÊý¾ÝµÄÊäÈëÊä³ö¡£
Á÷·ÖΪ×Ö½ÚÁ÷ºÍ×Ö·ûÁ÷¡£×Ö½ÚÁ÷Ò²³ÆÎªÔʼÊý¾Ý£¬ÐèÒªÓû§¶ÁÈëºó½øÐÐÏàÓ¦µÄ±àÂëת»»¡£¶ø×Ö½ÚÁ÷µÄʵÏÖÊÇ»ùÓÚ×Ô¶¯×ª»»µÄ£¬¶ÁÈ¡Êý¾Ýʱ»á°ÑÊý¾Ý°´ÕÕJVMµÄĬÈϱàÂë×Ô¶¯×ª»»³É×Ö·û¡£
×Ö½ÚÁ÷ÓÉInputStreamºÍOutputStream´¦Àí£¬¶ø×Ö·ûÁ÷ÓÉReaderºÍWriter´¦Àí¡£ReaderºÍWriterÊÇJavaºó¼ÓÈëµÄ´¦ÀíÀ࣬³öÓÚÈÃÊý¾ÝµÄ´¦Àí¸ü·½±ãµÄÄ¿µÄ¡£
×Ö½ÚÁ÷´¦Àí¸ÅÊö£º
¶ÔÓÚ×Ö½ÚÁ÷´¦ÀíµÄÀà¶¼¼Ì³Ð×ÔInputStreamºÍOutputStreamÕâÁ½¸ö³éÏóÀà¡£
InputStreamÌṩµÄ×îÖØÒªµÄ·½·¨ÊÇ£º
Java´úÂë
read();
read(byte[] b) ;
read(byte[] b, int off, int len) ;
read();
read(byte[] b) ;
read(byte[] b, int off, int len) ;
ÓÃÓÚ´ÓÊäÈëÁ÷ÖжÁÈ¡×Ö½Ú¡£
OutputStreamÌṩµÄ×îÖØÒªµÄ·½·¨ÊÇ£º
Java´úÂë
write(int b); &nb ......
ºÜ¶àÅóÓÑÔÚJava¿ª·¢ÖУ¬Ê¹ÓÃOracleÊý¾Ý¿âµÄʱºò£¬¾³£»áÅöµ½ÓÐORA-01000: maximum open cursors exceeded.µÄ´íÎó¡£
ʵ¼ÊÉÏ£¬Õâ¸ö´íÎóµÄÔÒò£¬Ö÷Òª»¹ÊÇ´úÂëÎÊÌâÒýÆðµÄ¡£
ora-01000: maximum open cursors exceeded.
±íʾÒѾ´ïµ½Ò»¸ö½ø³Ì´ò¿ªµÄ×î´óÓαêÊý¡£
ÕâÑùµÄ´íÎóºÜÈÝÒ׳öÏÖÔÚJava´úÂëÖеÄÖ÷ÒªÔÒòÊÇ£ºJava´úÂëÔÚÖ´ÐÐconn.createStatement()ºÍ conn.prepareStatement()µÄʱºò£¬Êµ¼ÊÉ϶¼ÊÇÏ൱ÓëÔÚÊý¾Ý¿âÖдò¿ªÁËÒ»¸öcursor¡£ÓÈÆäÊÇ£¬Èç¹ûÄãµÄ createStatementºÍprepareStatementÊÇÔÚÒ»¸öÑ»·ÀïÃæµÄ»°£¬¾Í»á·Ç³£ÈÝÒ׳öÏÖÕâ¸öÎÊÌâ¡£ÒòΪÓαêÒ»Ö±ÔÚ²»Í£µÄ´ò¿ª£¬¶øÇÒûÓйرա£
Ò»°ãÀ´Ëµ£¬ÎÒÃÇÔÚдJava´úÂëµÄʱºò£¬createStatementºÍprepareStatement¶¼Ó¦¸ÃÒª·ÅÔÚÑ»·ÍâÃæ£¬¶øÇÒʹÓÃÁËÕâЩStatmentºó£¬¼°Ê±¹Ø±Õ¡£×îºÃÊÇÔÚÖ´ÐÐÁËÒ»´ÎexecuteQuery¡¢executeUpdateµÈÖ®ºó£¬Èç¹û²»ÐèҪʹÓýá¹û¼¯£¨ResultSet£©µÄÊý¾Ý£¬¾ÍÂíÉϽ«Statment¹Ø±Õ¡£
¶ÔÓÚ³öÏÖORA-01000´íÎóÕâÖÖÇé¿ö£¬µ¥´¿µÄ¼Ó´óopen_cursors²¢²»ÊǺð취£¬ÄÇÖ»ÊÇÖα겻Öα¾¡£Êµ¼ÊÉÏ£¬´úÂëÖеÄÒþ»¼²¢Ã»Óнâ³ý¡£
¶øÇÒ£¬¾ø´ó²¿·ÖÇé¿öÏ£¬open_cursorsÖ»ÐèÒªÉèÖÃÒ»¸ö±È½ÏСµÄÖµ£¬¾Í×㹻ʹÓÃÁË£¬³ý·ÇÓзdz£ÌرðµÄÒªÇó¡£ ......
ºÜ¶àÅóÓÑÔÚJava¿ª·¢ÖУ¬Ê¹ÓÃOracleÊý¾Ý¿âµÄʱºò£¬¾³£»áÅöµ½ÓÐORA-01000: maximum open cursors exceeded.µÄ´íÎó¡£
ʵ¼ÊÉÏ£¬Õâ¸ö´íÎóµÄÔÒò£¬Ö÷Òª»¹ÊÇ´úÂëÎÊÌâÒýÆðµÄ¡£
ora-01000: maximum open cursors exceeded.
±íʾÒѾ´ïµ½Ò»¸ö½ø³Ì´ò¿ªµÄ×î´óÓαêÊý¡£
ÕâÑùµÄ´íÎóºÜÈÝÒ׳öÏÖÔÚJava´úÂëÖеÄÖ÷ÒªÔÒòÊÇ£ºJava´úÂëÔÚÖ´ÐÐconn.createStatement()ºÍ conn.prepareStatement()µÄʱºò£¬Êµ¼ÊÉ϶¼ÊÇÏ൱ÓëÔÚÊý¾Ý¿âÖдò¿ªÁËÒ»¸öcursor¡£ÓÈÆäÊÇ£¬Èç¹ûÄãµÄ createStatementºÍprepareStatementÊÇÔÚÒ»¸öÑ»·ÀïÃæµÄ»°£¬¾Í»á·Ç³£ÈÝÒ׳öÏÖÕâ¸öÎÊÌâ¡£ÒòΪÓαêÒ»Ö±ÔÚ²»Í£µÄ´ò¿ª£¬¶øÇÒûÓйرա£
Ò»°ãÀ´Ëµ£¬ÎÒÃÇÔÚдJava´úÂëµÄʱºò£¬createStatementºÍprepareStatement¶¼Ó¦¸ÃÒª·ÅÔÚÑ»·ÍâÃæ£¬¶øÇÒʹÓÃÁËÕâЩStatmentºó£¬¼°Ê±¹Ø±Õ¡£×îºÃÊÇÔÚÖ´ÐÐÁËÒ»´ÎexecuteQuery¡¢executeUpdateµÈÖ®ºó£¬Èç¹û²»ÐèҪʹÓýá¹û¼¯£¨ResultSet£©µÄÊý¾Ý£¬¾ÍÂíÉϽ«Statment¹Ø±Õ¡£
¶ÔÓÚ³öÏÖORA-01000´íÎóÕâÖÖÇé¿ö£¬µ¥´¿µÄ¼Ó´óopen_cursors²¢²»ÊǺð취£¬ÄÇÖ»ÊÇÖα겻Öα¾¡£Êµ¼ÊÉÏ£¬´úÂëÖеÄÒþ»¼²¢Ã»Óнâ³ý¡£
¶øÇÒ£¬¾ø´ó²¿·ÖÇé¿öÏ£¬open_cursorsÖ»ÐèÒªÉèÖÃÒ»¸ö±È½ÏСµÄÖµ£¬¾Í×㹻ʹÓÃÁË£¬³ý·ÇÓзdz£ÌرðµÄÒªÇó¡£ ......
1 Èç¹ûÒ»¿éÄÚ´æÇøÓòÄܹ»Öظ´ÀûÓã¬×îºÃ²»ÒªÉêÇëеġ£Õâ¸öÄÚ´æÇøÓòÓпÉÄÜÊÇϵͳµÄÒ»¸öÀ࣬×Ô¼ºµÄÒ»¸öÄÚ²¿ÓÐÊý×éÔªËØ£¬»òÕßÄܹ»·Å´óÁ¿Êý¾ÝµÄ½á¹¹¡£
2 ×îºÃ²»ÒªÔÚÑ»·ÀïÃæÉêÇëÄڴ棬ѻ·Ô½´ó£¬Ô½»µÊ¡£»»¾ä»°Ëµ£¬ÉêÇëÄÚ´æÆµÂʱðÌ«¸ß¡£ºÃ±ÈÒ»¸öÈËÿ¶Ù³ÔÁ½Íë·¹ÕýºÃ£¬ÉíÌåµÄÏû»¯ÏµÍ³¿ÉÒÔ³ÐÊÜ£¬Èç¹ûÈÃËûÒ»¶Ù°ÑÊ®¶ÙµÄ¶¼³Ôµô£¬²»ÕÍËÀ²Å¹Ö£¡
3 ÈÃÿ¸öʵÀý¶ÔÏóµÄÉúÃüÖÜÆÚ¾¡Á¿¶ÌһЩ£¬ÓÈÆäÊÇÄÇЩҪռÓôóÄÚ´æµÄ¡£ÒòΪÀ¬»øÊÕ¼¯Æ÷µÄËã·¨ÓÅÏÈ¿¼ÂÇÄÇЩÉúÃüÖÜÆÚ¶ÌµÄ¡£ºÍ¶àÈÎÎñ²Ù×÷ϵͳµ÷¶È½ø³Ì£¬·ÖÅäcpuµÄÔÀíÀàËÆ¡£
4 ¶ÔÒ»¿é´óµÄÄÚ´æµÄÒýÓòã´Î²»ÒªÅªµÃÌ«¸´ÔÓ£¬À¬»øÊÕ¼¯Æ÷¶ÔÕâÖÖÀàÐ͵ÄÄÚ´æ¿ìÊÕ¼¯ÆðÀ´£¬Ò²ÊDZȽÏÂéľµÄ¡£
5 Ñø³ÉºÃϰ¹ß£¬²»ÓõĶÔÏóÏÔʽÉèÖóÉnull¡£ÔÚÏ£ÍûÊÕ¼¯²ã´Î±È½Ï¸´ÔӵĶÔÏóµÄʱºò£¬ÏȽ«¸Ã¶ÔÏóÄÚ²¿±£´æµÄÆäËûÒýÓö¼ÖÃnullÁË£¬Ð§¹û»áºÃһЩ¡£
6 ×îºóÒ»ÕУ¬Ê¹ÓÃÈõÒýÓã¬ÐéÒýÓᣲ»¹ý£¬Ò»°ã³öÁËÄÚ´æÎÊÌ⣬¶¼ÊÇǰ5Ìõ×öµÃ²»ºÃ£¬ÐèÒªÓõ½6µÄÉÙÖ®ÓÖÉÙ¡£ ......
JavaÓïÑÔµÄÊäÈëÊä³ö¹¦ÄÜÊÇÊ®·ÖÇ¿´ó¶øÁé»îµÄ£¬ÃÀÖв»×ãµÄÊÇ¿´ÉÏÈ¥ÊäÈëÊä³öµÄ´úÂë²¢²»ÊǺܼò½à£¬ÒòΪÄãÍùÍùÐèÒª°ü×°Ðí¶à²»Í¬µÄ¶ÔÏó¡£ÔÚJavaÀà¿âÖУ¬IO²¿·ÖµÄÄÚÈÝÊǺÜÅÓ´óµÄ£¬ÒòΪËüÉæ¼°µÄÁìÓòºÜ¹ã·º:±ê×¼ÊäÈëÊä³ö£¬ÎļþµÄ²Ù×÷£¬ÍøÂçÉϵÄÊý¾ÝÁ÷£¬×Ö·û´®Á÷£¬¶ÔÏóÁ÷£¬zipÎļþÁ÷....±¾ÎĵÄÄ¿µÄÊÇΪ´ó¼Ò×öÒ»¸ö¼òÒªµÄ½éÉÜ¡£
¡¡¡¡Á÷ÊÇÒ»¸öºÜÐÎÏóµÄ¸ÅÄµ±³ÌÐòÐèÒª¶ÁÈ¡Êý¾ÝµÄʱºò£¬¾Í»á¿ªÆôÒ»¸öͨÏòÊý¾ÝÔ´µÄÁ÷£¬Õâ¸öÊý¾ÝÔ´¿ÉÒÔÊÇÎļþ£¬Äڴ棬»òÊÇÍøÂçÁ¬½Ó¡£ÀàËÆµÄ£¬µ±³ÌÐòÐèҪдÈëÊý¾ÝµÄʱºò£¬¾Í»á¿ªÆôÒ»¸öͨÏòÄ¿µÄµØµÄÁ÷¡£ÕâʱºòÄã¾Í¿ÉÒÔÏëÏóÊý¾ÝºÃÏñÔÚÕâÆäÖГÁ÷”¶¯Ò»Ñù£¬ÈçÏÂͼ£º
¡¡¡¡JavaÖеÄÁ÷·ÖΪÁ½ÖÖ£¬Ò»ÖÖÊÇ×Ö½ÚÁ÷£¬ÁíÒ»ÖÖÊÇ×Ö·ûÁ÷£¬·Ö±ðÓÉËĸö³éÏóÀàÀ´±íʾ£¨Ã¿ÖÖÁ÷°üÀ¨ÊäÈëºÍÊä³öÁ½ÖÖËùÒÔÒ»¹²Ëĸö£©:InputStream£¬OutputStream£¬Reader£¬Writer¡£JavaÖÐÆäËû¶àÖÖ¶àÑù±ä»¯µÄÁ÷¾ùÊÇÓÉËüÃÇÅÉÉú³öÀ´µÄ:
¡¡¡¡ÔÚÕâÆäÖÐInputStreamºÍOutputStreamÔÚÔçÆÚµÄJava°æ±¾ÖоÍÒѾ´æÔÚÁË£¬ËüÃÇÊÇ»ùÓÚ×Ö½ÚÁ÷µÄ£¬¶ø»ùÓÚ×Ö·ûÁ÷µÄReaderºÍWriterÊǺóÀ´¼ÓÈë×÷Ϊ²¹³äµÄ¡£ÒÔÉϵIJã´ÎͼÊÇJavaÀà¿âÖеÄÒ»¸ö»ù±¾µÄ²ã´ÎÌåϵ¡£
¡¡¡¡ÔÚÕâËĸö³éÏóÀàÖУ¬InputStreamºÍReader¶¨ÒåÁËÍêÈ«ÏàͬµÄ ......
À¬»øÊÕ¼¯¼¸ºõÊÇÿ¸ö¿ª·¢ÈËÔ±¶¼Ï²°®µÄÒ»¸ö Java™ Æ½Ì¨ÌØÐÔ£¬Ëü¼ò»¯ÁË¿ª·¢£¬Ïû³ýÁËËùÓÐÖÖÀàµÄDZÔÚ´úÂë´íÎ󡣿ɾ¡¹ÜÀ¬»øÊÕ¼¯Ò»°ãÀ´Ëµ¿ÉÒÔÈÃÄúÎÞÐè½øÐÐ×ÊÔ´¹ÜÀí£¬ÓÐʱºòÄú»¹ÊDZØÐë×Ô¼º½øÐÐһЩÄÚÎñ´¦Àí¡£
ÏÔʽµØÊÍ·Å×ÊÔ´
Java ³ÌÐòÖÐʹÓõľø´ó¶àÊý×ÊÔ´¶¼ÊǶÔÏó£¬À¬»øÊÕ¼¯ÔÚÇåÀí¶ÔÏó·½Ãæ×öµÃºÜºÃ¡£Òò´Ë£¬Äú¿ÉÒÔʹÓÃÈÎÒâ¶àµÄ String¡£À¬»øÊÕ¼¯Æ÷×îÖÕÎÞÐèÄúµÄ¸ÉÔ¤¾Í»áËã³öËüÃǺÎʱʧЧ£¬²¢ÊÕ»ØËüÃÇʹÓõÄÄÚ´æ¡£
ÁíÒ»·½Ã棬ÏñÎļþ¾ä±úºÍÌ×½Ó×Ö¾ä±úÕâÀà·ÇÄÚ´æ×ÊÔ´±ØÐëÓɳÌÐòÏÔʽµØÊÍ·Å£¬±ÈÈçʹÓà close()¡¢destroy()¡¢shutdown() »ò release() ÕâÑùµÄ·½·¨À´ÊÍ·Å¡£ÓÐЩÀ࣬±ÈÈçÆ½Ì¨Àà¿âÖеÄÎļþ¾ä±úÁ÷ʵÏÖ£¬ÌṩÖÕ½áÆ÷£¨finalizer£©×÷Ϊ°²È«±£Ö¤£¬ÒԱ㵱À¬»øÊÕ¼¯Æ÷È·¶¨³ÌÐò²»ÔÙʹÓÃ×ÊÔ´¶ø³ÌÐòÈ´ÍüÁËÊÍ·Å×ÊԴʱ£¬ÖÕ½áÆ÷»¹¿ÉÒÔÀ´×öÕâ¸öÊͷʤ×÷¡£µ«ÊǾ¡¹ÜÎļþ¾ä±úÌṩÁËÖÕ½áÆ÷À´ÔÚÄúÍü¼ÇÁËʱΪÄúÊÍ·Å×ÊÔ´£¬×îºÃ»¹ÊÇÔÚʹÓÃÍêÖ®ºóÏÔʽµØÊÍ·Å×ÊÔ´¡£ÕâÑù×ö¿ÉÒÔ¸üÔçµØÊÍ·Å×ÊÔ´£¬½µµÍÁË×ÊÔ´ºÄ¾¡µÄ¿ÉÄÜ¡£
¶ÔÓÚÓÐЩ×ÊÔ´À´Ëµ£¬Ò»Ö±µÈµ½Öսᣨfinalization£©ÊÍ·ÅËüÃÇÊDz»¿ÉÈ¡µÄ¡£¶ÔÓÚÖØÒªµÄ×ÊÔ´£¬±ÈÈçËø»ñÈ¡ºÍÐźÅÁ¿Ðí¿ÉÖ¤£¬Lock »ò Semaphore Ö±µ½ºÜÍí¶¼¿ÉÄܲ»»á±»À¬»øÊÕ¼¯µô¡£¶ÔÓÚÊ ......