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³ÌÐòÐèÒª´ÓÊý¾ÝÔ´¶ÁÈ¡Êý¾Ýʱ£¬»á¿ªÆôÒ»¸öµ½Êý¾ÝÔ´µÄÁ÷¡£Êý¾ÝÔ´¿ÉÒÔÊÇÎļþ£¬ÄÚ´æ»òÕßÍøÂçµÈ¡£Í¬Ñù£¬µ±³ÌÐòÐèÒªÊä³öÊý¾Ýµ½Ä¿µÄµØÊ±Ò²Ò»Ñù»á¿ªÆôÒ»¸öÁ÷£¬Êý¾ÝÄ¿µÄµØÒ²¿ÉÒÔÊÇÎļþ¡¢ÄÚ´æ»òÕßÍøÂçµÈ¡£Á÷µÄ´´½¨ÊÇΪÁ˸ü·½±ãµØ´¦ÀíÊý¾ÝµÄÊäÈëÊä³ö¡£
Á÷·ÖΪ×Ö½ÚÁ÷ºÍ×Ö·ûÁ÷¡£×Ö½ÚÁ÷Ò²³ÆÎªÔÊ ......
ºÜ¶àÅóÓÑÔÚJava¿ª·¢ÖУ¬Ê¹ÓÃOracleÊý¾Ý¿âµÄʱºò£¬¾³£»áÅöµ½ÓÐORA-01000: maximum open cursors exceeded.µÄ´íÎó¡£
ʵ¼ÊÉÏ£¬Õâ¸ö´íÎóµÄÔÒò£¬Ö÷Òª»¹ÊÇ´úÂëÎÊÌâÒýÆðµÄ¡£
ora-01000: maximum open cursors exceeded.
±íʾÒѾ´ïµ½Ò»¸ö½ø³Ì´ò¿ªµÄ×î´óÓαêÊý¡£
ÕâÑùµÄ´íÎóºÜÈÝÒ׳öÏÖÔÚJava´úÂëÖеÄÖ÷ÒªÔÒòÊÇ£ºJava´úÂëÔÚÖ´ ......
À¬»øÊÕ¼¯¼¸ºõÊÇÿ¸ö¿ª·¢ÈËÔ±¶¼Ï²°®µÄÒ»¸ö Java™ Æ½Ì¨ÌØÐÔ£¬Ëü¼ò»¯ÁË¿ª·¢£¬Ïû³ýÁËËùÓÐÖÖÀàµÄDZÔÚ´úÂë´íÎ󡣿ɾ¡¹ÜÀ¬»øÊÕ¼¯Ò»°ãÀ´Ëµ¿ÉÒÔÈÃÄúÎÞÐè½øÐÐ×ÊÔ´¹ÜÀí£¬ÓÐʱºòÄú»¹ÊDZØÐë×Ô¼º½øÐÐһЩÄÚÎñ´¦Àí¡£
ÏÔʽµØÊÍ·Å×ÊÔ´
Java ³ÌÐòÖÐʹÓõľø´ó¶àÊý×ÊÔ´¶¼ÊǶÔÏó£¬À¬»øÊÕ¼¯ÔÚÇåÀí¶ÔÏó·½Ãæ×öµÃºÜºÃ¡£Òò´Ë£¬Äú¿ÉÒÔʹÓÃÈÎ ......
Java´úÂ룺
import java.util.regex.*;
public final class RegExpValidator
{
/**
* ÑéÖ¤ÓÊÏä
* @param ´ýÑéÖ¤µÄ×Ö·û´®
* @return Èç¹ûÊÇ·ûºÏµÄ×Ö·û´®,·µ»Ø <b>true </b>,·ñÔòΪ <b>false </b>
*/
public static boolean isEmail(String str)
{
......