用jdbc链接oracle数据库,需要添加ojdbc.jar包。下面是例子:
- package com.blade.conn;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- public class JDBCConnect {
- public static void main (String args[]){
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
- String url="jdbc:oracle:thin:@127.0.0.1:1521:ORCL"; //oracle地址
- String user="blade";
- String password="mirage";
- Connection connection = null;
- try {
- connection= DriverManager.getConnection(url,user,password);
- System.out.println("链接成功!");
- } catch (SQLException e) {
- e.printStackTrace();
- }
- } catch (InstantiationException e) {
- e.printStackTrace();
- } catch (IllegalAccessException e) {
- e.printStackTrace();
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- }
- }
- }