java ºº×Ö»ùÓÚÆ´ÒôÊ××Öĸ¼ìË÷
×î½ü½ÓÊÖ¸ù¾ÝÆ´ÒôÊ××ÖĸÀ´¼ìË÷ÖÐÎĵÄС¹¦ÄÜ£¬ ±ÈÈçÊäÈëA ¿ÉÒ԰ѿͻ§ÐÕÊϵĵÚÒ»¸ö×ֵį´ÒôÊ××ÖĸΪAµÄÈ«²¿¼ìË÷³öÀ´
ÏàÐÅ»ù±¾ÔÚһЩӦÓÃÕ¾µãÉ϶¼¿ÉÒÔ¿´µÄµ½¡£
֮ǰûÓÐд¹ýÀàËÆµÄ¹¦ÄÜ¡£¸ÕÄõ½µÄʱºòÒ²ºÜÓôÃÆ¡£¡£ ÕâÔõôд£¬ ÓÖ²»ÄÜÏñÕý³£²éѯһÑù select * from Table where name like 'A%', ÎʹýһЩÓоÑéµÄ£¬ ±ã¸øÁËÈçϼ¸¸öʵÏÖ·½·¨£º
Ò»¡¢ÔÚ±íÖÐÔö¼ÓÒ»¸ö×ֶΣ¬ÓÃÓÚ´æ´¢¿Í»§ÐÕÊϵÚÒ»¸ö×ÖÆ´ÒôµÄÊ××Öĸ¡£ÒÔºó²éѯֱ½Ó name = 'A' ¾ÍOKÁË¡£ µ«¹«Ë¾²»Ô¸ÕâÑù£¬ÒòΪÏÖÔÚ±íÖÐÒÑÓÐÊý¾Ý£¬ÏÖÔÚÔö¼ÓÒÔ¼°ºóÆÚά»¤¶¼ºÜ²»·½±ã£¬ ±ãÆúÖ®¡£¡£
¶þ¡¢ÀûÓÃgp2312µÄ±àÂ룬±ÈÈçÒÔa¿ªÍ·µÄΪ B0A1 µ½ B0C4 ÄÇô²éѯֱ½Ó select * from Table where substr(name,0,1) between 'B0A1' and 'B0C4' ¾ÍÄÜÖ±½Ó°ÑËùÐèÊý¾Ý²éѯ³öÀ´ÁË¡£ ²»Öª´Ë·½·¨ÊÇ·ñ¿ÉÐУ¬ÒòΪÏÖÔÚÊý¾Ý¿âµÄ±àÂëÊÇutf-8£¬ ²»ÄÜÊÊÓÃ
Èý¡¢ÀûÓÃoracle º¯Êý£¬½«´«ÈëµÄÐÕÃûת³ÉËùÐèµÄÐÕÊÏÆ´ÒôÊ××Öĸ£¬Èç: from Client c where F_TRANS_PINYIN_CAPITAL(c.userName) =:state ÏÖÔÚ»¹²»ÖªÆäЧÂʵ½µ×ÔõÑù£¬ ²»¹ýÄܺܺõĽâ¾öµ±Ç°ÎÊÌâ¡£¡£ ±ã²ÉÓÃÖ®¡£
ÏÂÃæÊÇoracleº¯ÊýµÄд·¨¡£¡£:
CREATE OR REPLACE FUNCTION F_TRANS_PINYIN_CAPITAL(P_NAME IN VARCHAR2) RETURN VARCHAR2 AS
V_COMPARE VARCHAR2(100);
V_RETURN VARCHAR2(4000);
FUNCTION F_NLSSORT(P_WORD IN VARCHAR2) RETURN VARCHAR2 AS
BEGIN
RETURN NLSSORT(P_WORD, 'NLS_SORT=SCHINESE_PINYIN_M');
END;
BEGIN
V_COMPARE := F_NLSSORT(SUBSTR(P_NAME, 1, 1));
IF V_COMPARE >= F_NLSSORT(' ß¹ ') AND V_COMPARE <= F_NLSSORT('驁 ') THEN
V_RETURN := V_RETURN || 'A';
ELSIF V_COMPARE >= F_NLSSORT('°Ë ') AND V_COMPARE <= F_NLSSORT('²¾ ') THEN
V_RETURN := V_RETURN || 'B';
ELSIF V_COMPARE >= F_NLSSORT('àê ') AND V_COMPARE <= F_NLSSORT('錯 ') THEN
V_RETURN := V_RETURN || 'C';
ELSIF V_COMPARE >= F_NLSSORT('咑 ') AND V_COMPARE <= F_NLSSORT('鵽 ') THEN
V_RETURN := V_RETURN || 'D';
ELSIF V_COMPARE >= F_NLSSORT('妸 ') AND V_COMPARE <= F_NLSSORT
Ïà¹ØÎĵµ£º
×î½ü³ÉÁ¢ÁËÒ»¸öJAVA Ⱥ Ïë¸ú´ó¼ÒÒ»¿é½»Á÷ 41912406 £» ¸Ð¾õºÃ¾Ãû¿´¹ýJAVAÁË £¬¶¼ÓÐЩÉúÊèÁË¡£ÏÖÔÚÔÚÒ»¼Ò»Æ½ðͶ×ʹ«Ë¾¹¤×÷£¬Ëä˵¹¤×÷»·¾³»¹ÐУ¬µ«ÄÚÐÄÀïºÃÏñ²¢²»Ï²»¶Õâ¸ö£¬ÒÔºó»¹ÊÇÕÒ¸öÈí¼þ¹«Ë¾¸ÉΪºÃ¡£ÔÚÕâ¸öÐÐÒµÄܶÔÊÀ½ç¾¼ÃÁËÁ˽âºÜ¶à£¬ÎÒÏëÕâ¶ÔÎÒÒÔºó»áÓаïÖúµÄ£¬ÏÈÔÚÕâ¸É×Å£¬³¤µã֪ʶÓë¾ÑéÒ²²»´í¡£ ......
ÒòΪ³ÌÐòÒª´ÓÊý¾Ý¶ÁÈ¡½ü10WÐмǼ´¦Àí£¬µ±¶Áµ½9WµÄʱºò¾Í³öÏÖ java.lang.OutOfMemoryError: Java heap space ÕâÑùµÄ´íÎó¡£
ÔÚÍøÉÏÒ»²é¿ÉÄÜÊÇJAVAµÄ¶ÑÕ»ÉèÖÃ̫СµÄÔÒò¡£
¸ú¾ÝÍøÉϵĴ𰸴óÖÂÓÐÕâÁ½ÖÖ½â¾ö·½·¨£º
1¡¢ÉèÖû·¾³±äÁ¿
set JAVA_OPTS= -Xms32m -Xmx512m
¿ÉÒÔ¸ù¾Ý×Ô¼º»úÆ÷µÄÄÚ´æ½øÐиü¸Ä,µ«±¾È˲âÊÔÕâÖÖ· ......
×Ô¼ºÔÚ¹«Ë¾ÍøÕ¾¿ª·¢×ÜÓÃDWR¿ª·¢µÄÒ»¸ö¼òµ¥ÁÄÌì
±¾ÈËÒ²ÊÇÔÚÍøÕ¾¿ª·¢µØÍ¼Ê±Óе½ÁËÕâ¸ö¼¼Êõ£¬¸ÕѧϰDWR°ë¸öÔÂ
¾Í°ÑËæÊÖдµÄÒ»¸ö¼òµ¥ÁÄÌìÀ´¸ø´ó¼Ò¹²Ïí£¬Çдèһϡ£
ÓÉÓÚ¿¼Âǵ½Ä³Ð©¾Ö²¿ÔÒò£¬Ö»·¢±íÁËÒ»Ð©ÖØÒª¼¼Êõ·½ÃæµÄ×ÊÁÏ£¬Ã»ÓаÑÈ«²¿¶«Î÷¹²Ïí¡£Çë¸öÈËÌåÁ¡£
ÓÉÓÚDWR2.0ÓиöBug £¬ÎÒÓõÄDWR1.0£¬µ«ÊÇ£¬Ëü±ØÐëÓÃJDK1.4
......
×î½üÌýµ½Ò»¸öÏûÏ¢£¬¾Ý˵ÌÚѶµÄ²Æ¸¶Í¨ÔÚÕÐÆ¸ Java ·½ÃæµÄ¸ßÊÖ£¬"²ÎÓëϵͳ¼Ü¹¹Ñ¡ÐÍ"£¬Òª°Ñµ×²ã¼Ü¹¹´Ó C/C++ Ç¨ÒÆµ½ Java ¼Ü¹¹ÉÏÀ´¡£Æäʵµ±ÄãµÄÏîÄ¿µ½Ò»¶¨¹æÄ£Ö®ºó¸ü¶àÐèÒª¿¼ÂǵÄÊǶàÈËÐ×÷¿ª·¢µÄÎÊÌ⣬¿ÉÄܵ±³õ²Æ¸¶Í¨µÄºËÐÄ´úÂëÒ²¾ÍÊÇÒ»Á½¸öÈËÓÃC/C++¸ã¶¨µÄ£¬¿ÉÊǵ±ÒµÎñÀ©´ó¡¢¸´ÔÓÖ®ºó£¬·¢ÏÖ¶ ......
¶ÓÁÐÆäʵ ËùÖ¸Éú»îÖÐÅŶӵÄÏÖÏó£¬È¥É̳¡¹ºÎ¸¶¿îʱÐèÒªÅŶӣ¬ Âò·¹Ê±ÐèÒªÅŶӣ¬ ºÃ¶àÊÂÇé¶¼ÊÇÐèÒªÅŶӣ¬ ÅÅÔÚµÚһλµÄÔòÏÈ´¦Àí£¬½áÊøºó£¬ ºóÃæµÄÈ˶¼ÏñÇ°ÒÆ¶¯Ò»Î»£¬ÔÚ¿ª·¢ÖÐÒ²ÓкöàÕâÑùµÄÊÂÇéÐèÒª´¦Àí£¬ÈçÎļþµÄÏÂÔØ£¬¶ÌÐŵķ¢Ë͹¦ÄÜ£¬ µÈÕâЩ¶¼ÊÇÐèÒª¶ÓÁз½Ê½ÊµÏÖ¡£ºÃÁË£¬ ·Ï»°²»¶à˵£¬ ÏêÇé¼ûÏÂÃæ´úÂ룡
package com. ......