手动测试oracle数据库连接

package com.test.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;

public class ConnectionFactory {
public Connection getConnection() {
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver"); //加载数据库驱动
System.out.println("数据库驱动加载成功!"); //输出的信息
String url = "jdbc:oracle:thin:@localhost:1521:orcl"; //获取连接URL
String user = "scott"; //连接用户名
String password = "tiger"; //连接密码
 conn = DriverManager.getConnection(url, user, password); //获取数据库连接
if (conn != null) {
System.out.println("成功的与Oracle数据库建立连接!!");
}
} catch (Exception e) {
e.printStackTrace();
}
return conn; //返回Connection实例
}
public static void main(String[] args) {
ConnectionFactory getConn = new ConnectionFactory();
getConn.getConnection();
}
}

posted @ 2018-02-07 18:25  Arvins  阅读(3453)  评论(0编辑  收藏  举报