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
Ïà¹ØÎĵµ£º
ÔÚ³ÌÐòÖУ¬Îı¾Îļþ¾³£ÓÃÀ´´æ´¢±ê×¼µÄASCIIÂëÎı¾£¬±ÈÈçÓ¢ÎÄ¡¢¼Ó¼õ³Ë³ýµÈºÅÕâЩÔËËã·ûºÅ¡£Îı¾ÎļþÒ²¿ÉÄÜÓÃÓڴ洢һЩÆäËû·ÇASCII×Ö·û£¬Èç»ùÓÚ
GBKµÄ¼òÌåÖÐÎÄ£¬»ùÓÚBIG5µÄ·±ÌåÖÐÎĵȵȡ£ÔÚ´æ´¢ÕâЩ×Ö·ûʱÐèÒªÕýÈ·Ö¸¶¨ÎļþµÄ±àÂë¸ñʽ£»¶øÔÚ¶ÁÈ¡ÕâЩÎı¾Îļþʱ£¬ÓÐʱºò¾ÍÐèÒª×Ô¶¯Åж¨ÎļþµÄ±àÂë
¸ñʽ¡£
°´ÕÕ¸ø¶¨µÄ×Ö·û¼¯´ ......
Action×¢½âÅäÖÃ
ʹÓ÷½Ê½ÈçÏ£º
Java´úÂë
@ParentPackage(value="struts-default")
@Namespace(value="/test")
@Result(name="success",value="/userSuc.jsp")
@Results({
@Result(name="success",value="/userSu ......
import java.io.BufferedInputStream;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
public class RunDosCommand {
public static void main(String[] args) throws IOException {
String cmd = "ipconfig";
R ......
ÎÒÔÚ¼ÆËã»úÐÐÒµºÍÎÒµÄͼ±êÒ»Ñù»¹Ö»ÊÇÒ»¸öСº¢£¬µ±ÎÒÔÚÄÃϼÆËã»ú4¼¶£¨Èí¼þ²âÊÔ¹¤³Ìʦ£©ºÍ±àдÁ˲»ÉÙµÄͦcoolµÄ³ÌÐòÖ®ºó£¬¾õµÃ
×Ô¼ºË®Æ½²»Àµ¹þ¡£½á¹û¸Õ¿çÈëÒ»¸ö´ó¹«Ë¾ÊµÏ°µÄʱºò£¬ÎÒ¿´µ½ÎÒµÄÄǸöÏîÄ¿£¬ºÜ¿ìÎÒ±à³ÌµÄ˼άÓÖÔÚÌø¶¯£¬¿É“ÀÏ´ó”À´ÁËÒ»¾äc/c++ʵÏÖ
£¬ÎҾͷ·ðµ½ÁËÒ»¸ ......
ÓÃJava±àдӦÓÃʱ£¬ÓÐʱÐèÒªÔÚ³ÌÐòÖе÷ÓÃÁíÒ»¸öÏֳɵĿÉÖ´ÐгÌÐò»òϵͳÃüÁÕâʱ¿ÉÒÔͨ¹ý×éºÏʹÓÃJavaÌṩµÄRuntimeÀàºÍProcessÀàµÄ·½·¨ÊµÏÖ¡£ÏÂÃæÊÇÒ»ÖֱȽϵäÐ͵ijÌÐòģʽ£º
...
Process process = Runtime.getRuntime().exec(".\\p.exe");
process.waitfor( );
...&nb ......