Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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½«excelµ¥Ôª¸ñÊý¾Ýת»»³ÉsqlÓï¾ä

Ê×ÏÈÒªÓÐ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 ......

ͨ¹ýѧϰÕÅÀÏʦµÄjavaÊÓƵÎÒѧµ½ÁËʲô

¡¾1¡¿Í¨¹ý¿´ÕâÌ×ÊÓƵÎÒѧµ½ÁËÃæÊԵļ¼ÇÉ£¬ÒÔ¼°Ò»Ð©ÐèÒª¼ÇסµÄÃæÊÔÌâ
¡¾2¡¿Í¨¹ý¿´ÊÓƵÎÒѧµ½ÁËÔõÑùȥѧϰ£¬ÔõÑùÔÚ¶Ìʱ¼äÄڰѸÃÓõļ¼Êõѧ»á£¬Í¨¹ý²é¿´×ÊÁÏÆ©ÈçAPIµÈ£¬¶øÇÒ»¹Ñ§»áÁËÏÖѧÏÖÂô£¬»îѧ»îÓÃ
¡¾3¡¿Ê²Ã´ÊÇIDEÓ¦ÓóÌÐò¿ª·¢¹¤¾ß
¡¾4¡¿MyEclipseµÄһЩʹÓÃС¼¼ÇÉ£¬Í¨¹ýÕâЩС¼¼ÇÉ¿ÉÒÔÔö¼Ó¿ª·¢Ð§ÂÊ
£¨¿ì½Ý¼ü£©£¨javaÄ ......

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 ......

java ¶ÓÁÐʵÏÖ

¶ÓÁÐÆäʵ ËùÖ¸Éú»îÖÐÅŶӵÄÏÖÏó£¬È¥É̳¡¹ºÎ¸¶¿îʱÐèÒªÅŶӣ¬ Âò·¹Ê±ÐèÒªÅŶӣ¬ ºÃ¶àÊÂÇ鶼ÊÇÐèÒªÅŶӣ¬ ÅÅÔÚµÚһλµÄÔòÏÈ´¦Àí£¬½áÊøºó£¬ ºóÃæµÄÈ˶¼ÏñÇ°Òƶ¯Ò»Î»£¬ÔÚ¿ª·¢ÖÐÒ²ÓкöàÕâÑùµÄÊÂÇéÐèÒª´¦Àí£¬ÈçÎļþµÄÏÂÔØ£¬¶ÌÐŵķ¢Ë͹¦ÄÜ£¬ µÈÕâЩ¶¼ÊÇÐèÒª¶ÓÁз½Ê½ÊµÏÖ¡£ºÃÁË£¬ ·Ï»°²»¶à˵£¬ ÏêÇé¼ûÏÂÃæ´úÂ룡
package com. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ