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

javaÊý¾Ý¿â¿ª·¢ÖÐÁ½ÖÖ×¢²áoracleÇý¶¯µÄ·½Ê½

Ò»¡¢ÀûÓÃClass.forNameº¯Êý£¨ÓÃjava¿ª·¢B/SģʽµÄ³ÌÐò£© 1.´úÂëÈçÏ£º //×¢²áÇý¶¯³ÌÐò
public boolean connectDb() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
return true;
} catch (ClassNotFoundException e) {
System.out.println(e);
return false;
}
}
//»ñÈ¡Á¬½Ó
private Connection getConn(){
try{
connection=DriverManager.getConnection(url,user,password);
}catch(Exception e){
System.out.println(e);
}
return connection;
}

2.Ç°ÌáÌõ¼þ£º
  JDKµÄ°²×°¼°»·¾³±äÁ¿µÄÅäÖô˴¦²»ÔÙ׸Êö£»
  ½«oracle°²×°Ä¿Â¼ÏµÄjdbcϵÄclasses12.jarÎļþ¿½±´µ½tomcatĿ¼ÏµÄcommon\lib\ÏÂÃ棬·ñÔò»áÅ׳öClassNotFoundException£»
  url,user,passwordÊÓ¿ª·¢»·¾³¶ø¶¨
¶þ¡¢ÀûÓÃDriverManager.registerDriverº¯Êý£¨¿ª·¢C/SģʽµÄ³ÌÐòʱ£©
1.´úÂëÈçÏ£º

public Connection connectDatabase(){
try{
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
conn=DriverManager.getConnection("jdbc:oracle:thin:@172.16.1.52:1521:orcl","scott","test");
}catch (SQLException e){
System.out.println("caught:\n"+e);
System.exit(1);
}
return conn;
}

2.Ç°ÌáÌõ¼þ£º
JDKµÄ°²×°¼°»·¾³±äÁ¿µÄÅäÖô˴¦²»ÔÙ׸Êö£»
import.java.sql.*;
Èý¡¢Ò»µã˵Ã÷
1.Èç¹ûÔÚµÚÒ»ÖÖÇé¿öÏÂÓõڶþÖÖÇé¿öÌṩµÄ·½·¨£¬±àÒë²»ÄÜͨ¹ý¡£
2.Èç¹ûÔÚµÚ¶þÖÖÇé¿öÏÂÓõÚÒ»ÖÖÌṩµÄ·½·¨±àÒëÄܹ»Í¨¹ý£¬µ«ÊÇÔËÐÐʱ»á±¨oracle.jdbc.driver.OracleDriver£¬ÕÒ²»µ½µÄÒì³£¡£
3.½¨Ò鿪·¢²»Í¬µÄģʽ£¬²ÉÓò»Í¬µÄ×¢²áÇý¶¯µÄ·½·¨¡£
4.¼ÓÔØÇý¶¯Ê±¶¼Òª²¶»ñÒì³££¬µ±È»¿ÉÒÔ¶¼ÓÃExceptionÀ࣬Èç¹û¸üÏêϸµÄ»°£¬µÚÒ»ÖÖÇé¿öÏ£¬²¶»ñClassNotFoundException£¬µÚ¶þÖÖÇé¿öϲ¶»ñSQLExceptionÒì³££¬·Ö±ð²ÉÈ¡ÏàÓ¦µÄ´¦Àí·½Ê½¡£


Ïà¹ØÎĵµ£º

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

ÔÚORACLE 10gµÇ½´´½¨ÐÂÓû§

ÔÚORACLE 10gµÇ½´´½¨ÐÂÓû§£º
 
ÔÚORACLE 10gµÇ½´´½¨ÐÂÓû§£º
1¡¢ÓÃsys Óû§µÇ¼
2¡¢create user test1 identified by test123;
3¡¢grant connect,resource to test1;
ÓÃtest1µÇ½£º sqlplus test1/test123
°²×°ÍêÁËOracleÊý¾Ý¿â£¬ÍüÁËÔÚ¿ÚÁî¹ÜÀíÖиøSCOTT½âËøÔõô°ì
 
 
 
ÎÊÌâ²¹³ä ......

Oracle PL/SQL¹ÜÀíLDAP·þÎñÆ÷(DBMS_LDAP°üµÄʹÓÃ)

Á˽âLDAP

LDAPÊÇLight Directory Access ProtocolÇáÁ¿¼¶Ä¿Â¼·ÃÎÊЭÒéµÄ¼ò³Æ£¬LDAPÓëÊý¾Ý¿âÓкܴóµÄÇø±ð£¬ËüµÄÊý¾ÝÊÇÊ÷×´µÄ£¬¶øÇÒÿ¸ö½ÚµãµÄÊôÐÔÒ²±È½Ï¹Ì¶¨¡£
LDAPЭÒéÖÐÓÃdn±íʾһÌõ¼Ç¼µÄλÖã¬dc±íʾһÌõ¼Ç¼ËùÊôÇøÓò£¬ou±íʾһÌõ¼Ç¼ËùÊô×éÖ¯£¬cn±íʾһÌõ¼Ç¼µÄÃû³Æ£¬uid±íʾһÌõ¼Ç¼µÄID£¬ÆäÖÐdnÊǸù¾ ......

JavaµÄÊ®´óʼþ


1990£­1994£ºJavaÔµÆð
Larry Wall˵£¬ÓÅÐã³ÌÐòÔ±Ó¦ÓеÄÈý¸öÌصã:ÀÁ¶è¡¢¼±ÔêºÍ°ÁÂý¡£Java¾ÍÊǵ®ÉúÔÚһȺÀÁ¶è¡¢¼±Ôê¶ø°ÁÂýµÄ³ÌÐòÌì²ÅÖ®ÖС£
1990Äê12Ô£¬SunµÄ¹¤³ÌʦPatrick Naughton±»µ±Ê±Ôã¸âµÄSun C++¹¤¾ßÕÛÄ¥µÄ¿ì·èÁË¡£Ëû´óÉù±§Ô¹£¬²¢ÍþвҪÀ뿪SunתͶµ±Ê±ÔÚSteve JobsÁ쵼֮ϵÄNeXT¹«Ë¾¡£Áìµ¼²ãΪÁËÁôסËû£¬¸øËû ......

activeMQÆô¶¯´íÎó£¬Òý³öµÄjava endorsedĿ¼ÎÊÌâ¡£

ÔÚÎÒ»úÆ÷ÉÏ°²×°µÄÊÇJDK6£¬ÏÂÔØactiveMQ5.3Æô¶¯Ê±±¨´í£¬Ìáʾjaxb°üÒѾ­¼ÓÔØ2.0°æ±¾ÎÞ·¨¼ÓÔØ2.1°æ±¾¡£
ÎÒͨ¹ýÍøÂçËÑË÷ÁËһϷ¢ÏÖ£¬jaxb2.0ÊÇJDK·¢²¼Ê±°üº¬ÔÚrt.jar°üÖеġ£µ«ÊÇactiveMQ5.3È´ÐèÒª2.1°æ±¾¡£Õâ¸ÃÈçºÎ´¦Àí£¿
×ܲ»Äܽ«rt.jar°ü½â¿ª£¬½«jaxb2.1µÄÀา¸Ç½øÈ¥£¬ÔÙÖØдò°ü°É¡£ÕâÑùÌ«Âé·³ÁË¡£
ÔٴνøÐÐÍøÂçËÑË÷£¬·¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ