工作总结之----java代码连接数据库（SqlServer和oracle）_java将oracle 和 sqlserver视图关联-优快云博客

本文链接：https://blog.youkuaiyun.com/u013062329/article/details/80523183

本文提供了一个Java中使用JDBC连接SQL Server和Oracle数据库的示例代码，包括加载驱动、建立连接及关闭资源等步骤。

代码：

import java.sql.*;

public class JDBCUtil {
    private static final String DBDRIVERSQLSWRVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";// sqlserver驱动类类名
    private static final String DBDRIVERORACLE = "oracle.jdbc.driver.OracleDriver";// oracle驱动类类名

    private static final String DBNAME = "xxxx";// 数据库名
    private static final String DBUSER = "xxxx";// 数据库用户名
    private static final String DBPASSWORD = "xxxxx";// 数据库密码
    private static final String DBURL = "jdbc:sqlserver://IP:prot;DatabaseName="+DBNAME;// 连接URL

    private static final String DBUSERORCL = "xxxx";// oracle数据库用户名
    private static final String DBPASSWORDORCL = "xxxx";// oracle数据库密码
    private static final String DBURLORCL = "jdbc:oracle:thin:@IP:prot:数据库名";// oracle连接URL


    private static Connection conn = null;

    private static PreparedStatement ps = null;

    private static ResultSet rs = null;
    /*
        * 获取数据库连接
        */
    public static Connection getConnection() {

        try {

            Class.forName(DBDRIVERSQLSWRVER);// 注册驱动
            System.out.println("成功加载SQL Server驱动程序");
            conn = DriverManager.getConnection(DBURL,DBUSER,
                    DBPASSWORD);// 获得连接对象
            System.out.println("数据库连接成功");
        } catch (ClassNotFoundException e) {// 捕获驱动类无法找到异常

            System.out.println("找不到SQL Server驱动程序");
            System.out.println(e.toString());
            e.printStackTrace();

        } catch (SQLException e) {// 捕获SQL异常

            e.printStackTrace();
        }

        return conn;
    }

    public static Connection getConnectionOracle() {

        try {

            Class.forName(DBDRIVERORACLE);// 注册驱动
            System.out.println("成功加载SQL Server驱动程序");
            conn = DriverManager.getConnection(DBURLORCL,DBUSERORCL,
                    DBPASSWORDORCL);// 获得连接对象
            System.out.println("数据库连接成功");
        } catch (ClassNotFoundException e) {// 捕获驱动类无法找到异常

            System.out.println("找不到oracle驱动程序");
            System.out.println(e.toString());
            e.printStackTrace();

        } catch (SQLException e) {// 捕获SQL异常

            e.printStackTrace();
        }

        return conn;
    }

    public static void closeAll(Connection conn, Statement stmt,PreparedStatement pstmt, ResultSet rs) {
       try {
           if (rs != null) {
               rs.close();
           }
           if (pstmt != null) {
               pstmt.close();
           }
           if (stmt != null) {
               stmt.close();
           }
           if (conn != null) {
               conn.close();
           }
           System.out.print("关闭成功");
       }catch (SQLException e){
           System.out.print("关闭失败");
       }
    }

    public static final void main(String[] args) throws SQLException {
        Connection conn = getConnection();
        conn.close();
    }
}