Connect to Oracle with Java

Connect to Oracle with Java


Thin Driver 
Thin Driver是百分百純JAVA打造，透過SOCKET(TCP/IP)的方式來連接資料庫。 
有兩種URL syntax 
舊的，只對SID有用： 
jdbc:oracle:thin:@[HOST][:PORT]:SID 
新的，則多了SERVICE NAME 
jdbc:oracle:thin:[USER/PASSWORD]@[HOST][:PORT]:SID 
jdbc:oracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE 

例： 
String url = "jdbc:oracle:thin:@//yourhost:yourport/orcl"; 
or 
String url = "jdbc:oracle:thin:@yourhost:yourport:orcl";