JavaÒì³£´¦Àí
ÁùÖÖÒì³£´¦ÀíµÄªϰ
Äã¾õµÃ×Ô¼ºÊÇÒ»¸öJavaר¼ÒÂð£¿ÊÇ·ñ¿Ï¶¨×Ô¼ºÒÑ¾È«ÃæÕÆÎÕÁËJavaµÄÒì³£´¦Àí»úÖÆ£¿ÔÚÏÂÃæÕâ¶Î´úÂëÖУ¬ÄãÄܹ»Ñ¸ËÙÕÒ³öÒì³£´¦ÀíµÄÁù¸öÎÊÌâÂð£¿
Java´úÂë
OutputStreamWriter out = ...
java.sql.Connection conn = ...
try { //²¶»ñÒì³£
¡¡Statement stat = conn.createStatement();
¡¡ResultSet rs = stat.executeQuery(
¡¡¡¡"select uid, name from user");
¡¡while (rs.next())
¡¡{
¡¡¡¡out.println("ID£º" + rs.getString("uid") // ¢Ê
¡¡¡¡¡¡"£¬ÐÕÃû£º" + rs.getString("name"));
¡¡}
¡¡conn.close();
¡¡out.close();
}
catch(Exception ex) { //Òì³£´¦Àí
¡¡ex.printStackTrace();
}
OutputStreamWriter out = ...
java.sql.Connection conn = ...
try { //²¶»ñÒì³£
¡¡Statement stat = conn.createStatement();
¡¡ResultSet rs = stat.executeQuery(
¡¡¡¡"select uid, name from user");
¡¡while (rs.next())
¡¡{
¡¡¡¡out.println("ID£º" + rs.getString("uid") // ¢Ê
¡¡¡¡¡¡"£¬ÐÕÃû£º" + rs.getString("name"));
¡¡}
¡¡conn.close();
¡¡out.close();
}
catch(Exception ex) { //Òì³£´¦Àí
¡¡ex.printStackTrace();
}
×÷Ϊһ¸öJava³ÌÐòÔ±£¬ÄãÖÁÉÙÓ¦¸ÃÄܹ»ÕÒ³öÁ½¸öÎÊÌâ¡£µ«ÊÇ£¬Èç¹ûÄã²»ÄÜÕÒ³öÈ«²¿Áù¸öÎÊÌ⣬Çë¼ÌÐøÔĶÁ±¾ÎÄ¡£
¡¡¡¡±¾ÎÄÌÖÂ۵IJ»ÊÇJavaÒì³£´¦ÀíµÄÒ»°ãÐÔÔÔò£¬ÒòΪÕâЩÔÔòÒѾ±»´ó¶àÊý
Ïà¹ØÎĵµ£º
java byteÓëchar»¥×ªÔÀí-ת
Ò»¡¢×Ö½ÚºÍunicode
JavaÄÚºËÊÇunicodeµÄ£¬¾ÍÁ¬classÎļþÒ²ÊÇ£¬µ«ÊǺܶàýÌ壬°üÀ¨Îļþ/Á÷µÄ±£´æ·½Ê½ÊÇʹÓÃ×Ö½ÚÁ÷µÄ¡£Òò´ËJavaÒª¶ÔÕâЩ×Ö½ÚÁ÷¾ÐÐת»¯¡£ charÊÇunicodeµÄ£¬¶øbyteÊÇ×Ö½Ú¡£JavaÖÐ byte/char»¥×ªµÄº¯ÊýÔÚsun.ioµÄ°üÖмäÓС£ÆäÖÐByteToCharConverterÀàÊÇÖе÷¶È£¬¿ÉÒÔÓÃÀ´¸æËßÄ㣬 ......
ʲôÊÇÁ÷£º
Á÷ÊÇÒ»¸ö³éÏóµÄ¸ÅÄî¡£µ±Java³ÌÐòÐèÒª´ÓÊý¾ÝÔ´¶ÁÈ¡Êý¾Ýʱ£¬»á¿ªÆôÒ»¸öµ½Êý¾ÝÔ´µÄÁ÷¡£Êý¾ÝÔ´¿ÉÒÔÊÇÎļþ£¬ÄÚ´æ»òÕßÍøÂçµÈ¡£Í¬Ñù£¬µ±³ÌÐòÐèÒªÊä³öÊý¾Ýµ½Ä¿µÄµØÊ±Ò²Ò»Ñù»á¿ªÆôÒ»¸öÁ÷£¬Êý¾ÝÄ¿µÄµØÒ²¿ÉÒÔÊÇÎļþ¡¢ÄÚ´æ»òÕßÍøÂçµÈ¡£Á÷µÄ´´½¨ÊÇΪÁ˸ü·½±ãµØ´¦ÀíÊý¾ÝµÄÊäÈëÊä³ö¡£
Á÷·ÖΪ×Ö½ÚÁ÷ºÍ×Ö·ûÁ÷¡£×Ö½ÚÁ÷Ò²³ÆÎªÔÊ ......
ºÜ¶àÅóÓÑÔÚJava¿ª·¢ÖУ¬Ê¹ÓÃOracleÊý¾Ý¿âµÄʱºò£¬¾³£»áÅöµ½ÓÐORA-01000: maximum open cursors exceeded.µÄ´íÎó¡£
ʵ¼ÊÉÏ£¬Õâ¸ö´íÎóµÄÔÒò£¬Ö÷Òª»¹ÊÇ´úÂëÎÊÌâÒýÆðµÄ¡£
ora-01000: maximum open cursors exceeded.
±íʾÒѾ´ïµ½Ò»¸ö½ø³Ì´ò¿ªµÄ×î´óÓαêÊý¡£
ÕâÑùµÄ´íÎóºÜÈÝÒ׳öÏÖÔÚJava´úÂëÖеÄÖ÷ÒªÔÒòÊÇ£ºJava´úÂëÔÚÖ´ ......
ÕæÊDzÑÀ¢°¡, ѧÁËÔõô¾Ã java, ÏÖÔÚ²ÅÖªµÀ java µÄ»ù±¾Êý¾ÝÀàÐÍÊDz»´æÔÚÓзûºÅºÍÎÞ·ûºÅÕâÖÖ¶«Î÷µÄ. ƽʱ¶¼Ã»Óиã×Ö½ÚºÍλ֮ÀàµÄÔËËã, ËùÒÔµ¹ÊÇûÓÐ×¢Òâµ½Õâ¸ö·½ÃæÄØ.
JAVAÖеĻù±¾Êý¾ÝÀàÐͲ»´æÔÚÎÞ·ûºÅµÄ£¬ËüÃǵÄȡֵ·¶Î§Êǹ̶¨µÄ£¬²»»áËæ×Å»úÆ÷Ó²¼þ»·¾³»òÕß²Ù×÷ϵͳµÄ¸Ä±ä¶ø¸Ä±ä¡£(Õâ¾ä³µÄ)
Java¼òµ¥Êý¾ÝÀàÐÍ
......
doGet()ºÍdoPost()
JspÒ³ÃæµÄform±êÇ©ÀïµÄmethodÊôÐÔΪgetʱµ÷ÓÃdoget(0,
Ϊpostʱµ÷ÓÃdoPost()
Jsp
JspÒýÇæ(Tomcat)ÏȽ«jspÎļþת»»Îªservlet£¬È»ºóµ÷ÓÃJava±àÒëÆ÷javac.exe¶Ô
......