Oracle jdbc 连接代码单例

最新推荐文章于 2021-09-11 11:24:09 发布

幻云爱你

最新推荐文章于 2021-09-11 11:24:09 发布

阅读量285

点赞数

文章标签： jdbc oracle

本文链接：https://blog.csdn.net/qq_35376421/article/details/78441209

版权

oracle jdbc 连接代码

package com.util;

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

public class DB {

    public static final String Uri = "jdbc:oracle:thin:@";
    public static final String Host = "localhost:";
    public static final String Port = "1521";
    public static final String DataBase = ":orcl";
    public static final String DBAccount = "scott";
    public static final String DBPassWord = "123456";
    public static final String ClassName = "oracle.jdbc.driver.OracleDriver";

    private static String URL = DB.Uri + DB.Host + DB.Port + DB.DataBase;

    private static Connection con = null;
    static {
        try {
            Class.forName(DB.ClassName);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    private DB() {
        System.out.println("private DB()...");
    }

    public static Connection getConnection() {
        try {
            if (con == null) {
                System.out.println(URL);
                con = DriverManager.getConnection(URL, DB.DBAccount,DB.DBPassWord);
            } else {
                return con;
            }
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        }
        return con;
    }

    public static void main(String[] args) {
        System.out.println(DB.getConnection());
    }

}