java增强connection类,java 数据库Connection 工具类

野性酷女 2023-01-13 09:23 39阅读 0赞

package com.common.database;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

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();

java增强connection类,java 数据库Connection 工具类

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 java.net.ConnectException: Connection refused (Connection refused)

相关 java——JDBC——JDBC各个类详解——Connection

相关 java增强connection类,java 数据库Connection 工具类

相关 java connect_connect.java

相关【Eureka】java.net.ConnectException: Connection refused: connect

相关 java connection_Java Connection集合分析之List

相关 java.net.ConnectException: Connection refused: connect 解决

相关 Java JDBC Connections

相关 java.net.ConnectException: Connection refused: connect错误

相关 java.net.ConnectException: Connection refused: connect