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
Ïà¹ØÎĵµ£º
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 ......
ÓÃJava±àдӦÓÃʱ£¬ÓÐʱÐèÒªÔÚ³ÌÐòÖе÷ÓÃÁíÒ»¸öÏֳɵĿÉÖ´ÐгÌÐò»òϵͳÃüÁÕâʱ¿ÉÒÔͨ¹ý×éºÏʹÓÃJavaÌṩµÄRuntimeÀàºÍProcessÀàµÄ·½·¨ÊµÏÖ¡£ÏÂÃæÊÇÒ»ÖֱȽϵäÐ͵ijÌÐòģʽ£º
...
Process process = Runtime.getRuntime().exec(".\\p.exe");
process.waitfor( );
...&nb ......
Ò»¡¢µ÷ÓÃÊôÐÔÎļþÊôÐԵĴúÂ룺
String url=SmsProperties.get("sms_address_frontend");//È¡µØÖ·Èç“sms_address_frontend=http://172.16.1.9:8280/sms_frontend/services/smsSenderWebService”
String smsServer = SmsProperties.get("sms_server_name");//·¢ËͶÌÐŵķþÎñÕ˺Å(ÕâÀï¿ÉÒÔÈ¡ÖÐÎÄÊôÐ ......
̰³ÔÉßµÄËã·¨·ÖÎö(Java)
̰³ÔÉßÊÇÒ»¿î·Ç³£¾µäµÄÊÖ»úÓÎÏ·¡£ËüÓкܶàËã·¨£¬ÕâÀïÏêϸ·ÖÎöÒ»ÖֱȽÏÓÅÐãµÄËã·¨¡£
Ê×ÏȽéÉÜÏÂÖ÷ÒªÓõ½µÄÆß¸öÀࣺ
l WormMain£º×îÖ÷ÒªµÄÀ࣬¿ØÖÆËùÓÐÆäËüÀàµÄÔËÐкÍÏú»Ù¡£
l &nbs ......