jdbc连接oracle的三种url形式
1,jdbc:oracle:thin:@localhost:1521:orcl
SID的指令获取:
sqlplus /as sysdba
select value from v$parameter where name='instance_name'
2,jdbc:oracle:thin:@//localhost:1521/orcl.city.com
service_name的指令获取:
sqlplus /as sysdba
select value from v$parameter where name='service_name'
3,jdbc:oracle:thin:@TNS_ALIAS_NAME
步骤:
1,创建数据库并插入数据
2,存放ojdbc.jar到lib包
3,右键项目,build path->libraries->add jars->添加ojdbc.jar