数据库连接[JDBC]

方法一：

JDBC Source

package com.ly.util;

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

/**
 * 功能描述：连接数据库
 * 
 * @author TONY
 *
*/
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");// 加载驱动MYSQL
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        conn = DriverManager.getConnection(MYSQL + url, user, password);

return conn;
    }

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

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");// 加载驱动MSSQL
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        conn = DriverManager.getConnection(SQLSERVER + url, user, password);

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

    }

}

方法二：

Java类

JAVA类

Database.Propertis

#数据库驱动
 jdbc.driver=oracle.jdbc.driver.OracleDriver
#数据库远程连接
 jdbc.url=jdbc\:oracle\:thin\:@10.24.1.183\:1521\:hbgis1
#数据库用户名
 jdbc.username=tiger
#数据库密码
 jdbc.password=dragon

转载于:https://www.cnblogs.com/lovexinsky/archive/2012/03/08/2384844.html