JDBC 链接oracle的三种URL写法
1.普通SID方式
jdbc:Oracle:thin:username/password@x.x.x.1:1521:SID
2.普通ServerName方式
jdbc:oracle:thin:username/password@//x.x.x.1:1522/ABCD
3.RAC方式
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.2)(PORT=1521)))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxrac)))
(1) DriverName
Oracle:oracle.jdbc.driver.OracleDriver
MySQL:com.mysql.jdbc.Driver
Sql server:com.microsoft.jdbc.sqlserver.SQLServerDriver
(2) URL
Oracle:jdbc:oracle:thin:(协议)@xxx.xxx.xxx.xxx:xxx(ip地址和端口号:xxx(数据库名字)
如:jdbc:oracle:thin:@localhost:1521:myDataBase
Mysql:jdbc:mysql://localhost:3306/数据库名
如:jdbc:mysql://127.0.0.1:3306/test
SqlServer:jdbc:microsoft:sqlserver://localhost:1433/数据库名