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ѧϰ´ÓÈëÃŵ½¾«Í¨
Ò»¡¢ JDK (Java Development Kit)
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......
Ò»£º×¼±¸ 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±ÊÊÔʱ¿ÉÄܳöÏÖÎÊÌâ>>£¬»¹ÓÐһƪÍüÁËÃû×Ö£¬¶ÁºóÉîÊÜÆô·¢¡£
ÔÚѰÕÒÕâЩ´ð°¸µÄ¹ý³ÌÖУ¬ÎÒ½«Ïà¹Ø´ð°¸¼Ç¼ÏÂÀ´£¬¾ÍÐγÉÁËÒÔÏÂÕâЩ¶«Î÷¡£ÐèҪ˵à ......
£¨×¢Òâ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 ......