Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

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

Á˽âLDAP

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

java ÐéÄâ»úÔËÐÐʱÊý¾ÝÇøÓò Runtime Data Areas

The Java virtual machine defines various runtime data areas that are used during execution of a program. Some of these data areas are created on Java virtual machine start-up and are destroyed only when the Java virtual machine exits. Other data areas are per thread. Per-thread data areas are create ......

JAVA´úÂëС¼¼ÇÉ£¬ÊµÊ±¸üУ¬¸üе½20100107

    ÔÚCSDNÖп´µ½Á˸öÓйØjava¼¼ÇɵÄÌû×Ó£¬¾õµÃ·Ç³£ÓÐÓ㬿ÉÒÔ±ÜÃ⿪·¢¹ý³ÌÖвúÉúµÄһЩµÍ¼¶µÄ´íÎó£¬Ìû×Ó±¾ÉíÒѾ­½øÐÐÁË×ܽᣬÎÒÌô³öÁËÆäÖÐһЩ¸öÈ˾õµÃƽʱ¿ª·¢¹ý³ÌÖÐÓÐÓõIJ¿·Ö£¬ÔÙ¼ÓÉÏ×Ô¼ºÔÚ¹¤×÷ÖÐѧµ½µÄ¼¼ÇÉ£¬ÕûÀíÔÚ±¾ÎÄÖУ¬²¢Ëæ×Åʱ¼äʵʱ¸üÐÂ
1¡¢Ð´ºÃ×¢ÊÍ¡£ÊäÈë²ÎÊý¡¢Êä³öÀàÐÍ¡¢·½·¨¹¦ÄÜ£¬°ÑÕâÈýµãÃè ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ