Java-ConnectDB工具类

最新推荐文章于 2023-01-09 12:53:37 发布

weixin_33711641

最新推荐文章于 2023-01-09 12:53:37 发布

阅读量164

点赞数

CC 4.0 BY-SA版权

文章标签： java 数据库

原文链接：https://yq.aliyun.com/articles/364758

本文提供了一个使用Java进行数据库连接的示例代码，包括MySQL、Oracle和SQL Server三种数据库类型的连接方式。通过加载不同的数据库驱动并使用JDBC进行连接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


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

/**
 * 功能描述：连接数据库-mysql/oracle
 */
public class ConnectDB {

    private static final String MYSQL = "jdbc:mysql://";

    private static final String ORACLE = "jdbc:oracle:thin:@";

    private static final String SQLSERVER = "jdbc:microsoft:sqlserver://";
    private ConnectDB() {
    }

    public static Connection getConnection(String DBType, String url,
            String user, String password) throws SQLException {
        if ("mysql".equalsIgnoreCase(DBType))
            return getMySqlConn(url, user, password);
        if ("oracle".equalsIgnoreCase(DBType))
            return getOracleConn(url, user, password);
        if ("sqlserver".equals(DBType)){
            return getSqlServerConn(url, user, password);
        }
        return null;
    }

    public static void closeConn(Connection conn) {
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    private static Connection getMySqlConn(String url, String user,
            String password) throws SQLException {
        Connection conn = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");// 加载驱动
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        conn = DriverManager.getConnection(MYSQL + url, "root", "root");

        return conn;
    }

    private static Connection getOracleConn(String url, String user,
            String password) throws SQLException {
        Connection conn = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");// 加载驱动
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        conn = DriverManager.getConnection(ORACLE + url, "scott", "tiger");

        return conn;
    }

    private static Connection getSqlServerConn(String url, String user,
            String password) throws SQLException {
        Connection conn = null;
        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");// 加载驱动
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        conn = DriverManager.getConnection(SQLSERVER + url, "root", "root");

        return conn;
    }
    public static void main(String[] args) {
        try {
            Connection conn = getConnection("MySQL", "127.0.0.1", "root",
                    "root");
            if (conn == null) {
                System.out.println("Connection the database is failled !");
            } else {
                System.out.println(conn.toString());
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

}