package com.yihai.jdbc;import java.sql.Connection;import java.sql.DriverManager;/** * 测试连接oracle数据库 * @author wpc * */public class JdbcSuccess {//驱动，URL，用户名，密码private static final String driver = "oracle.jdbc.driver.OracleDriver";private static final String url = "jdbc:oracle:thin:@locoracle账号alhost:1521:orcl";private static final String username = "scott";private static final String password = "929118";public static Connection getConnection() {Connection connection = null;try {// 加 载驱动Class.forName(driver);// 通过驱动管理类获取数据库连接connection = DriverManager.getConnection(url, username, password);// 关闭连接connection.close();} catch (ClassNotFoundException e) {e.printStackTrace();} catch (Exception e) {e.printStackTrace();}return connection;}// 测试oracle连接是否成功public static void main(String[] args) {Connection connection = JdbcSuccess.getConnection();if (connection != null) {System.out.println("连接oracle数据库成功:" + connection);} else {System.out.println("连接oracle数据库失败!!!");}}}
