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

oracleÖÐjdbcÇý¶¯°üµÄ˵Ã÷

´Óoracle8µ½oracle10£¬JDBCĿ¼ÏµÄÇý¶¯°ü¶¼¸÷Óв»Í¬¡£¿´ÁËÒ»ÏÂoracleµÄÎĵµËµÃ÷£¬Á˽âÁËÒ»ÏÂËüÃǵÄÓÃ;£¬ÏàÐÅ´ó¼ÒÓÐʱºòÒ²ºÜÃÔ»ó£¬Ð´³öÀ´¹²Ïíһϡ£
ÕâЩÊÇoracle10gϵÄÇý¶¯°üµÄÃû³ÆºÍËüÃǵÄ×÷Óã¬ÆäËû°æ±¾µÄoracle»ù±¾ÀàËÆ¡£
Ö§³ÖËùÓÐÆ½Ì¨µÄJDBC ThinÇý¶¯
classes12.jar (1,417,089 bytes) - JDK 1.2 ºÍ JDK 1.3ÏÂʹÓÃ
classes12_g.jar (1,794,418 bytes) - ºÍclasses12.jarÏàͬ, µ«ÊǰüÖеÄÀàʹÓÃ"javac -g"ÃüÁî±àÒ룬°üº¬µ÷ÊÔÐÅÏ¢.
classes12dms.jar (1,424,743 bytes) - ºÍclasses12.jarÏàͬ, µ«Êǰüº¬Ò»Ð©¸½¼ÓµÄ´úÂëÖ§³ÖOracle Dynamic Monitoring Service.
classes12dms_g.jar (1,802,368 bytes) - ºÍ classes12dms.jarÏàͬ£¬µ«ÊǰüÖеÄÀàʹÓÃ"javac -g"±àÒ룬°üº¬µ÷ÊÔÐÅÏ¢.
ojdbc14.jar (1,352,918 bytes) - JDK 1.4ÏÂʹÓÃ
ojdbc14_g.jar (1,691,855 bytes) - ºÍojdbc14.jarÏàͬ,µ«ÊǰüÖеÄÀàʹÓÃ"javac -g"±àÒ룬°üº¬µ÷ÊÔÐÅÏ¢.
ocrs12.jar (54,030 bytes) - ÒýÈëÁËjavax.sql.rowset½Ó¿Ú, ÈçCachedRowSet ºÍ WebRowSet. ¿ÉÒÔÔÚ JDK 1.2, 1.3, ºÍ 1.4ÏÂʹÓÃ.
orai18n.jar (5,018,093 bytes) - ʹÓÃÔÚJDK 1.2, 1.3 ºÍ 1.4ϵÄNLS(National Language Support,¹ú¼ÒÓïÑÔÖ§³Ö)Àà.Õâ¸öjar°üÌæ»»ÁËÀϵÄnls_charset jar/zip Îļþ.
demo.tar (532,480 bytes) - °üº¬Ò»Ð©JDBCÀý³Ì.
 


Ïà¹ØÎĵµ£º

Oracle²Ù×÷ϵͳÈÏÖ¤

ĬÈÏÇé¿öÏ£¬ÔÚOracleµÄÖ÷»úÉÏ£¨linuxϵͳ£©µÄOracle²Ù×÷ϵͳÓû§Ï£¬ÒÔsysÓû§µÇ½Êý¾Ý¿âʱ¿ÉÒÔ²»ÓÃÊäÈëÃÜÂëÖ±½ÓµÇ¼¡£Êµ¼ÊÉÏ£¬Ö»ÒªÊÇÊôÓÚdba×飨linux£©»òosdba×飨windows£©Ï£¬¶¼¿ÉÒÔ²»ÓÃÃÜÂë½øÐеǼ¡£ÕâÊÇÈÏÖ¤·½Ê½³ÆÎªOSÈÏÖ¤¡£
ÕâÖֵǼ·½Ê½µÄ¿ØÖÆ£¬ÊÇͨ¹ý$ORACLE_HOME/network/admin/sqlnet.oraÖеģº
SQLNET.AUTH ......

OracleÔÚwindowsϰ²×°¼ÍÒª


°²×°£º
ÔËÐÐG:\install\setup.exe°²×°Oracle£¬µ«²»´´½¨Æô¶¯Êý¾Ý¿â
´´½¨Êý¾Ý¿â(ʹÓÃConfiguration And Migration Tools->DataBase Configuration Assistant)
´´½¨¼àÌý³ÌÐò(ʹÓÃConfiguration And Migration Tools->NetManager»òÕß Configuration And Migration Tools->Net Configuration Assistant)
´´½¨·þÎñ ......

jdbcÖе÷ÓÃoracle´æ´¢¹ý³Ì

1¡¢´´½¨±í£º
     create table stud(
             sid int,
            sname varchar2(50)
     )
     ²¢²åÈëÒ»ÌõÊý¾Ý
&n ......

jsp·ÖÒ³£¨oracle+jsp+apache£©

Ò» Ç°Ìá 
Ï£Íû×îеļͼÔÚ¿ªÍ·¸øÄãµÄ±í½¨Á¢²éѯ£º
±í£ºmytable 
²éѯ£ºcreate or replace view as mytable_view from mytable order by id desc ÆäÖУ¬×îºÃʹÓÃÐòÁкÅcreate sequence mytable_sequence À´×Ô¶¯Ôö¼ÓÄãµÄ¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ