Çë½ÌjsÈçºÎ²Ù×÷oracleÊý¾Ý¿â - Web ¿ª·¢ / JavaScript
ÈçºÎÓÃjsÁ¬½ÓoracleÊý¾Ý¿â£¬´´½¨±í£¬Ìí¼ÓÊý¾ÝµÈ²Ù×÷£¬¾Ù¼¸¸ö¼òµ¥µÄjs´úÂëÀý×Ó¿´¿´£¿
JSÊÇ¿Í»§¶ËµÄ¶«Î÷£¬Êý¾Ý¿âÊÇÔÚ·þÎñÆ÷¶ËµÄ¶«Î÷¡£
Èç¹ûÄãÏëÒªÓÃJS²Ù×÷Êý¾Ý¿â£¬ÄÇô£¬ÄãÐèÒªÔ¤ÏÈÔÚ·þÎñÆ÷¶Ë±àдºǫ́³ÌÐò£¬Õâ¸ö³ÌÐò¿ÉÄÜÊÇasp, php, javaµÈ£¬µ«²»ÊÇJS¡£È»ºóÒ³ÃæÀïͨ¹ýajax»òÕßÖ±½Óͨ¹ýÒ³ÃæµÄÌøת£¬È¥µ÷Óúǫ́³ÌÐòÀ´²Ù×÷Êý¾Ý¿â
JScript code:
var con = new ActiveXObject("ADODB.Connection");
con.open("Provider=OraOLEDB.Oracle;Source='';User ID='';Password='';PLSQLRset=1");
ÕâÑù¾Í¿ÉÒÔÁ¬½ÓÊý¾Ý¿â¶ÁÈ¡Êý¾ÝÁË
JSµÄÔ´´úÂëÒ»°ã±ðÈ˲鿴ԴÎļþ¾ÍÄÜ¿´µ½ÁË¡¡
Ö±½ÓÓÃÀ´²Ù×÷£¬»áºÜ±¯ÇéµÄ
¶øÇÒActiveXObjectµÄ¼æÈÝÐÔ¡Ò²»áÏ൱µÄ±¾ß
var con = new ActiveXObject("ADODB.Connection");
con.open("Provider=OraOLEDB.Oracle;Source='';User ID='';Password='';PLSQLRset=1");
wangfuxiang ÄãÓÃÕâÑùµÄajaxÁ¬½ÓÊý¾Ý¿âÂð£¿
ÔÚʵ¼ÊÏîÄ¿ÖÐÖ¸¶¨²»ÄÜÓÃjsÁ¬½ÓÊý¾Ý¿âÁË£¬°²È«ÐÔÎÊÌâ°¡£¡µ«ÊÇÕâÖÖ·½·¨È·ÊµÊÇ¿ÉÒÔÁ¬½ÓÊý¾Ý¿âµÄ¡£
4Â¥µÄÈç¹û¸ÒÐËȤ¿ÉÒÔ³¢ÊÔÏ£¬ËÙ¶ÈÒ²Âù¿ìµÄ¡£
aspµÄ»° Óà jscriptд·þÎñÆ÷ Á¬ oracle°¡
Ò»°ã²»ÓÃÕⶫÎ÷²Ù×÷Êý¾Ý¿âµÄ°É¡£¡£
ÓÃ ActiveXObject
µÄ»°»ðºü ²»¼æÈÝ
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬ÈÏ°²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......