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

JAVAÖзÀÖ¹SQL×¢Èë¹¥»÷ÀàµÄÔ´´úÂë

package cn.com.hbivt.util;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2005</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class StringUtils {
//¹ýÂËͨ¹ýÒ³Ãæ±íµ¥Ìá½»µÄ×Ö·û
private static String[][] FilterChars={{"<","<"},{">",">"},{" "," "},{"\"","""},{"&","&"},
{"/","/"},{"\\","\"},{"\n","<br>"}};
//¹ýÂËͨ¹ýjavascript½Å±¾´¦Àí²¢Ìá½»µÄ×Ö·û
private static String[][] FilterScriptChars={{"\n","\'+\'\\n\'+\'"},
{"\r"," "},{"\\","\'+\'\\\\\'+\'"},
{"\'","\'+\'\\\'\'+\'"}};
/**
* ÓÃÌØÊâµÄ×Ö·ûÁ¬½Ó×Ö·û´®
* @param strings ÒªÁ¬½ÓµÄ×Ö·û´®Êý×é
* @param spilit_sign Á¬½Ó×Ö·û
* @return Á¬½Ó×Ö·û´®
*/
public static String stringConnect(String[] strings,String spilit_sign){
String str="";
for(int i=0;i<strings.length;i++){
str+=strings[i]+spilit_sign;
}
return str;
}
/**
* ¹ýÂË×Ö·û´®ÀïµÄµÄÌØÊâ×Ö·û
* @param str Òª¹ýÂ˵Ä×Ö·û´®
* @return ¹ýÂ˺óµÄ×Ö·û´®
*/
public static String stringFilter(String str){
String[] str_arr=stringSpilit(str,"");
for(int i=0;i<str_arr.length;i++){
for(int j=0;j<FilterChars.length;j++){
if(FilterChars[j][0].equals(str_arr[i]))
str_arr[i]=FilterChars[j][1];
}
}
return (stringConnect(str_arr,"")).trim();
}
/**
* ¹ýÂ˽ű¾ÖеÄÌØÊâ×Ö·û£¨°üÀ¨»Ø³µ·û(\n)ºÍ»»Ðзû(\r)£©
* @param str Òª½øÐйýÂ˵Ä×Ö·û´®
* @return ¹ýÂ˺óµÄ×Ö·û´®
* 2004-12-21 ãÆ
*/
public static String stringFilterScriptChar(String str){
String[] str_arr=stringSpil


Ïà¹ØÎĵµ£º

javaÈëÃÅ

 Javaѧϰ´ÓÈëÃŵ½¾«Í¨ 
Ò»¡¢ JDK (Java Development Kit) 
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......

javaʹÓÃrocksawºÍvserv tcpipʵÏÖ»ùÓÚICMPµÄPing¹¦ÄÜ

Ò»£º×¼±¸ www.savarese.org download
 1.  rocksaw-1.0.0-src.tar.gz
 2.  vserv-tcpip-0.9.2-src.tar.gz
¶þ£º±àÒëÔ´ÎļþµÃµ½jar°ü ʹÓÃAnt
 1.  build vserv-tcpip-0.9.2-src
      ÔÚvserv-tcpip-0.9.2Ŀ¼ÏÂÃæ½¨Ò»¸ötestsĿ¼£¬È»ºóÔÚcmd´°¿ÚϽøÈë ......

javaÃæÊÔÏà¹ØÌâÄ¿


   ÓиÐ:ӦƸJava±ÊÊÔʱ¿ÉÄܳöÏÖÎÊÌâ¼°Æä´ð°¸
ǰ¶Îʱ¼äÒòΪҪ²Î¼ÓÒ»¸ö±ÊÊÔ£¬ÔÚ×¼±¸ÆÚ¼äÔÚÍøÉÏÕÒµ½ÁËÁ½Ìõ¹ØÓÚ±ÊÊÔÌâÄ¿µÄÎÄÕ£¬ÆäÖÐһƪΪ<<ÓиÐ:ӦƸJava±ÊÊÔʱ¿ÉÄܳöÏÖÎÊÌâ>>£¬»¹ÓÐһƪÍüÁËÃû×Ö£¬¶ÁºóÉîÊÜÆô·¢¡£
ÔÚѰÕÒÕâЩ´ð°¸µÄ¹ý³ÌÖУ¬ÎÒ½«Ïà¹Ø´ð°¸¼Ç¼ÏÂÀ´£¬¾ÍÐγÉÁËÒÔÏÂÕâЩ¶«Î÷¡£ÐèҪ˵à ......

SQLÓï¾äµ¼Èëµ¼³ö´óÈ«


£¨×¢Òâoffice2007µÄͬѧ°Ñprivider='Microsoft.Jet.OLEDB.4.0'¸ÄΪ'Microsoft.ACE.OLEDB.12.0'¡£¡£offiec2003Óë2007µÄÌṩÆ÷ÊDz»Ò»ÑùµÄ¡£¡££©
 
 
 
 
SQLÓï¾äµ¼Èëµ¼³ö´óÈ«[ÊÕ¼¯]
/******* µ¼³öµ½excel
EXEC master..xp_cmdshell 'bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -
S"GNE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ