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

¹ØÓÚ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ÖÐÎÞ·¨ÏÔʾ

ÎÒµÄjava applet ǶÈëhtmlºóÎÞ·¨ÏÔʾ£¬¶øÓÃappletviewerÏÔʾÕý³£ÎªÊ²Ã´£¬»¹ÓоÍÊÇÓÃhtml converterת»¯ºó¿ÉÒÔÏÔʾ£¬ÎªÊ²Ã´£¿Çë´óÏÀ´Í½Ì£¡
HTML code:

<HTML>
<HEAD>
<TITLE>TEST.HTML< ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

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ÕâÒ»·½Ãæ·¢Õ¹£¬ÓÐÄÄһλ¸ßÊÖ¿ÉÒÔ¸æËßÎÒ£¬Ïë³ÉΪһÃûJAVA±à³Ì¸ßÊÖ£¬Ëû±ØÐëҪѧϰµÄ֪ʶÂ𣿱ÈÈç˵ÎÒѧÍêÁËJAVAµÄ»ù´¡ÖªÊ¶Ö®ºóÎҸðÑÄ¿¹â·ÅÔÚÄÄÒ»·½Ã棬½ÓÏÂÀ´ÎÒÔÚѧϰÓйØJAVAµÄʲô֪ʶ£¿ÅóÓÑà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ