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)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
JDK°æ±¾£ºjdk1.6.0_17
a. ÏÂÔØ°²×°°üjdk-6u17-linux-i586-rpm.bin
b. cp jdk-6u17-linux-i586-rpm.bin /usr/local/
c. chmod a+x jdk-6u17-linux-i586-rpm.bin
d. sh jdk-6u17-linux-i586-rpm.bin ½ÓÊÜÐÒéyes£¬°²×°Íê³É
e. ÉèÖû·¾³±äÁ¿
vi /etc/profile
¼ÓÈëÏÂÃæÄÚÈÝ£º
#set java environment
JAVA_HOME=/ ......
ÏÈroot´ò²¹¶¡£ºp3006854_9204_linux.zip
ÔÙÉèoracle»·¾³±äÁ¿
°²×°
°²×°½áÊø½¨¿â֮ǰÐèÒª´òµÄ²¹¶¡ÓУº
p2617419_220_GENERIC.zip
p3119415_9204_linux.zip
¾ßÌå²Î¿¼ÕâƪÎÄÕ£º
Redhat Enterprise Linux 4°²×°oracle
¹Ø¼ü×Ö: redhat el4 oracle °²×°
Ò». °²×°×¼±¸
1. as4°²×°Íêºó£¬ÐèÒª¼ì²éÏÂÁÐÈí¼þ ......
ÔÚÎÒ»úÆ÷ÉÏ°²×°µÄÊÇJDK6£¬ÏÂÔØactiveMQ5.3Æô¶¯Ê±±¨´í£¬Ìáʾjaxb°üÒѾ¼ÓÔØ2.0°æ±¾ÎÞ·¨¼ÓÔØ2.1°æ±¾¡£
ÎÒͨ¹ýÍøÂçËÑË÷ÁËһϷ¢ÏÖ£¬jaxb2.0ÊÇJDK·¢²¼Ê±°üº¬ÔÚrt.jar°üÖеġ£µ«ÊÇactiveMQ5.3È´ÐèÒª2.1°æ±¾¡£Õâ¸ÃÈçºÎ´¦Àí£¿
×ܲ»Äܽ«rt.jar°ü½â¿ª£¬½«jaxb2.1µÄÀา¸Ç½øÈ¥£¬ÔÙÖØдò°ü°É¡£ÕâÑùÌ«Âé·³ÁË¡£
ÔٴνøÐÐÍøÂçËÑË÷£¬·¢ ......
Õû¸öÀàÎļþ×¢ÊÍ
ʾÀýÈçÏÂ
:
/*
* @(#)Object.java
1.61 03/01/23
*
* Copyright 2003 Sun Microsystems, Inc. All rights reserved.
* SUN PROPRIETARY/CONFIDENTIAL. Use is subject to license terms.
*/
package java.lang;
& ......