¹ØÓÚjava oracle10g ±àÂ뷽ʽ£¬Èë¿âµÄÎÊÌâ
ÎÒÓöµ½Ò»¸öÂÒÂëÎÊÌ⣬²»Ì«Ã÷°×£¬À´ÎÊһϣ»
ÏÈ˵Èí¼þ°æ±¾£º
Êý¾Ý¿â£ºoracle10g
java se 1.6
¿â°æ±¾£ºjxl ,ojdbc14
ÉèÖãº
oracle10gÉèÖÃΪutf8
´óÌåÁ÷³ÌÊÇÕâÑùµÄ£¬ÎÒÓÃjxl¶ÁÈëexcelÊý¾Ý£¬È»ºó²åÈëµ½oracleÖУ»
ÏÖÔÚ³öÏÖµÄÎÊÌâÊÇ£º
ÎÒÈë¿âµÄººÓï³öÏÖÂÒÂëÁË£¬ÕâЩººÓïÔÚpl/sqlÏÂÏÔʾÊÇÕý³£µÄ£¬ÔÚÓÃjavaÖØÐ´ÓÊý¾Ý¿â¶ÁÈëÕâЩÂÒÂ룬µ÷ÊÔʱ¿´¼àÊÓ±äÁ¿Ê±Ò²ÊÇÕý³£µÄ£¬ÔÚsql/plus϶ÁÈëÊÇÂÒÂëµÄ£»
²Ù×÷ϵͳΪwin 2003
pl/sql sql/plus¶¼ÊÇÓõÄĬÈÏÉèÖÃ×Ö·û¼¯
ÎÒÏëÈÃoracleÖеÄÊý¾Ý±£Ö¤ÊÇutf8¸ñʽµÄ£¬Ôõô´¦Àí£»£¨ÔڣףţÂÉÏ·¢ÏÖ£¬ÂÒÂë¸Ä³Égb2312ÏÔʾ¾ÍÕý³£ÁË£©
ÎÒÓõÄjdbc£¬Í¨¹ýojdbc14ÓÃĬÈÏÉèÖÃÁ´½ÓµÄÊý¾Ý¿â£»
¸½ÎÒµÄjdbcÓ÷¨
String cmd ("insert into xxx (a,b),values('"+str1+"','"+str2+"')");
rs = stat.execute(cmd);
Õâ¸öÓ¦¸ÃÊÇ´æÈ¡µÄÎÊÌâ
ºÍÊý¾Ý¿â±àÂ뷽ʽû¹ØÏµ°É
½¨Òéд¸ö¹ýÂËÆ÷
str1= new String(str1.getBytes("GB2312","UTF-8"));
³¢ÊÔÏÂתÂë
Ö§³Ö2Â¥,Ó¦¸Ã°Ñ´ÓÒ³Ãæ»ñµÃµÄÊý¾Ý½øÐÐÒ»´Î±àÂë,È»ºóÔÙ×öÈë¿â²Ù×÷
ÎÒÕâ¸öÊǸö×ÀÃæ³ÌÐò£¬¸ú£×£Å£ÂûÓйØÏµ£»Ö»ÊǼòµ¥µØ°Ñexcel±íÊý¾Ý¶ÁÈëÈ»ºóͨ¹ýjdbc·½Ê½Èëµ½Êý¾Ý¿âÖУ»ÕâÖÖÇé¿öÊÇÄã˵µÄ¹ýÂËÆ÷Âð£¿
Java code
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com
Ïà¹ØÎÊ´ð£º
ÎÒµÄjava applet ǶÈëhtmlºóÎÞ·¨ÏÔʾ£¬¶øÓÃappletviewerÏÔʾÕý³£ÎªÊ²Ã´£¬»¹ÓоÍÊÇÓÃhtml converterת»¯ºó¿ÉÒÔÏÔʾ£¬ÎªÊ²Ã´£¿Çë´óÏÀ´Í½Ì£¡
HTML code:
<HTML>
<HEAD>
<TITLE>TEST.HTML< ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÏëÎÒjavaÕâÒ»·½Ãæ·¢Õ¹£¬ÓÐÄÄһλ¸ßÊÖ¿ÉÒÔ¸æËßÎÒ£¬Ïë³ÉΪһÃûJAVA±à³Ì¸ßÊÖ£¬Ëû±ØÐëҪѧϰµÄ֪ʶÂ𣿱ÈÈç˵ÎÒѧÍêÁËJAVAµÄ»ù´¡ÖªÊ¶Ö®ºóÎҸðÑÄ¿¹â·ÅÔÚÄÄÒ»·½Ã棬½ÓÏÂÀ´ÎÒÔÚѧϰÓйØJAVAµÄʲô֪ʶ£¿ÅóÓÑà ......