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
Ïà¹ØÎĵµ£º
Ê×ÏÈÒªÓÐjxlÀà¿â¡£
³ÌÐòÈçÏ£º
import java.io.*;
import jxl.*;
public class ExcelToSql {
public static void main(String args[])
{
try
{
Workbook book= Workbook.getWorkbook(new File("D:\\workspaceuse6\\foundation\\test\\com\\gres ......
¡¾1¡¿Í¨¹ý¿´ÕâÌ×ÊÓƵÎÒѧµ½ÁËÃæÊԵļ¼ÇÉ£¬ÒÔ¼°Ò»Ð©ÐèÒª¼ÇסµÄÃæÊÔÌâ
¡¾2¡¿Í¨¹ý¿´ÊÓƵÎÒѧµ½ÁËÔõÑùȥѧϰ£¬ÔõÑùÔÚ¶Ìʱ¼äÄڰѸÃÓõļ¼Êõѧ»á£¬Í¨¹ý²é¿´×ÊÁÏÆ©ÈçAPIµÈ£¬¶øÇÒ»¹Ñ§»áÁËÏÖѧÏÖÂô£¬»îѧ»îÓÃ
¡¾3¡¿Ê²Ã´ÊÇIDEÓ¦ÓóÌÐò¿ª·¢¹¤¾ß
¡¾4¡¿MyEclipseµÄһЩʹÓÃС¼¼ÇÉ£¬Í¨¹ýÕâЩС¼¼ÇÉ¿ÉÒÔÔö¼Ó¿ª·¢Ð§ÂÊ
£¨¿ì½Ý¼ü£©£¨javaÄ ......
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 ......
¶ÓÁÐÆäʵ ËùÖ¸Éú»îÖÐÅŶӵÄÏÖÏó£¬È¥É̳¡¹ºÎ¸¶¿îʱÐèÒªÅŶӣ¬ Âò·¹Ê±ÐèÒªÅŶӣ¬ ºÃ¶àÊÂÇ鶼ÊÇÐèÒªÅŶӣ¬ ÅÅÔÚµÚһλµÄÔòÏÈ´¦Àí£¬½áÊøºó£¬ ºóÃæµÄÈ˶¼ÏñÇ°Òƶ¯Ò»Î»£¬ÔÚ¿ª·¢ÖÐÒ²ÓкöàÕâÑùµÄÊÂÇéÐèÒª´¦Àí£¬ÈçÎļþµÄÏÂÔØ£¬¶ÌÐŵķ¢Ë͹¦ÄÜ£¬ µÈÕâЩ¶¼ÊÇÐèÒª¶ÓÁз½Ê½ÊµÏÖ¡£ºÃÁË£¬ ·Ï»°²»¶à˵£¬ ÏêÇé¼ûÏÂÃæ´úÂ룡
package com. ......