Java测试各种数据库连接(用Connection类)
源代码:
package cn.finedo.fdcollect_service.util; import java.sql.Connection; import org.apache.logging.log4j.LogManager; import org.apache.logging.log4j.Logger; public class DoConnection { private static Logger logger = LogManager.getLogger(); public static Connection connection(String dbtype,String linktype,String tns,String ip,String port,String dbname,String username,String password){ Connection conn = null; try { String jdbcurl = ""; if ("ORACLE".equals(dbtype.toUpperCase())) { if("单节点".equals(linktype)){ jdbcurl = "jdbc:oracle:thin:@" + ip + ":" + port + ":" + dbname; }else{ jdbcurl = "jdbc:oracle:thin:@ "+ tns; } conn =DBHelper.initOracle(jdbcurl,username,password, false); } else if ("MYSQL".equals(dbtype.toUpperCase())) { jdbcurl = "jdbc:mysql://" + ip + ":" + port + "/" + dbname + "?useUnicode=true&characterEncoding=utf-8"; conn =DBHelper.initMysql(jdbcurl, username,password, false); } else if ("DB2".equals(dbtype.toUpperCase())) { jdbcurl = "jdbc:db2://" + ip + ":" + port + "/" + dbname; conn =DBHelper.initDB2(jdbcurl, username,password, false); } else if ("SQLSERVER".equals(dbtype.toUpperCase())) { jdbcurl = "jdbc:sqlserver://" + ip + ":" + port + ";DatabaseName=" + dbname; conn =DBHelper.initSQLServer(jdbcurl, username,password, false); }else if("GREENPLUM".equals(dbtype.toUpperCase())){ /*jdbcurl = "jdbc:pivotal:greenplum://" + ip + ":" + port + ";DatabaseName=" + dbname;*/ jdbcurl = tns; conn = DBHelper.initGreenPlum(jdbcurl, username, password, false); }else if("HIVE".equals(dbtype.toUpperCase())){ /*jdbcurl = "jdbc:hive2://" + ip + ":"+port + "/default";*/ jdbcurl = tns; conn = DBHelper.initHIVE(jdbcurl, username, password, false); }else { return null; } } catch (Exception e) { logger.error("数据源连接失败",e); return null; } return conn; } public static void close(Connection conn){ if (conn != null) { DBHelper.closeDB(conn, null, null); } else { DBHelper.closeDB(conn, null, null); } } }
DBHelper.java
package cn.finedo.fdcollect_service.util; import java.sql.Connection; import java.sql.Driver; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import org.apache.logging.log4j.LogManager; import org.apache.logging.log4j.Logger; public class DBHelper { private static Logger logger = LogManager.getLogger(); // public static Connection conn=null; /** * @author Liyg * @description 创建ORACLE连接信息 * @param jdbcurl * @param username * @param password * @param autoCommit * @return */ public static Connection initOracle(String jdbcurl, String username, String password, boolean autoCommit) { Connection conn=null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); //连接数据库 conn = DriverManager.getConnection(jdbcurl, username, password); conn.setAutoCommit(autoCommit); // logger.debug(jdbcurl); // logger.debug("username=【"+username+"】"); // logger.debug("Oracle DATABASE: Connection success!"); }catch(Exception se) { //连接失败 // logger.debug("initOra:"+jdbcurl + "\r\n" + " Connection failed! " + se.getMessage()); //System.exit(0); logger.error("ORACLE连接失败",se); return null; } return conn; } /** * @author Liyg * @description 创建DB2连接信息 * @param jdbcurl * @param username * @param password * @param autoCommit * @return */ public static Connection initDB2(String jdbcurl, String username, String password, boolean autoCommit) { Connection conn=null; try { Driver driver=(Driver) Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance(); //连接数据库 DriverManager.registerDriver(driver); conn = DriverManager.getConnection(jdbcurl, username, password); conn.setAutoCommit(autoCommit); // logger.info("db2 DATABASE:" + jdbcurl + " Connection success!"); }catch(Exception se) { // logger.debug("initDB2:"+jdbcurl + "\r\n" + " Connection failed! " + se.getMessage()); logger.error("DB2连接失败",se); return null; } return conn; } /** * @author Liyg * @description 创建MYSQL连接信息 * @param jdbcurl * @param username * @param password * @param autoCommit * @return */ public static Connection initMysql(String jdbcurl, String username, String password, boolean autoCommit) { Connection conn=null; try { Class.forName("com.mysql.jdbc.Driver"); //连接数据库 conn = DriverManager.getConnection(jdbcurl, username, password); conn.setAutoCommit(autoCommit); // logger.debug(jdbcurl); // logger.debug("username=【"+username+"】"); // logger.debug("MYSQL DATABASE: Connection success!"); }catch(Exception se) { //连接失败 conn = null; // logger.debug("initMYSQL:"+jdbcurl + "\r\n" + " Connection failed! " + se.getMessage()); logger.error("MYSQL连接失败",se); return null; } return conn; } /** * @author Liyg * @description 创建SQLServer连接信息 * @param jdbcurl * @param username * @param password * @param autoCommit * @return */ public static Connection initSQLServer(String jdbcurl, String username, String password, boolean autoCommit) { Connection conn=null; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); // 连接数据库 conn = DriverManager.getConnection(jdbcurl, username, password); conn.setAutoCommit(autoCommit); // logger.debug(jdbcurl); // logger.debug("username=【" + username + "】"); // logger.debug("SQLSERVER DATABASE: Connection success!"); } catch (Exception se) { // 连接失败 // logger.debug("initSQLServer:"+jdbcurl + "\r\n" + " Connection failed! " + se.getMessage()); // System.exit(0); logger.error("SQLSERVER连接失败",se); return null; } return conn; } /** * @author zk * @description 创建GreenPlum连接信息 * @param jdbcurl * @param username * @param password * @param autoCommit * @return */ public static Connection initGreenPlum(String jdbcurl, String username, String password, boolean autoCommit) { Connection conn=null; try { Class.forName("com.pivotal.jdbc.GreenplumDriver"); //conn = DriverManager.getConnection("jdbc:pivotal:greenplum://192.168.229.146:5432;DatabaseName=database", "gpadmin", "111"); conn = DriverManager.getConnection(jdbcurl,username, password); conn.setAutoCommit(autoCommit); // logger.debug("GreenPlum DATABASE: Connection success!"); } catch (Exception se) { // 连接失败 // logger.debug("GreenPlum:"+jdbcurl + "\r\n" + " Connection failed! " + se.getMessage()); logger.error("GREENPLUM连接失败",se); return null; } return conn; } /** * @author zk * @description 创建HIVE连接信息 * @param jdbcurl * @param username * @param password * @param autoCommit * @return */ public static Connection initHIVE(String jdbcurl, String username, String password, boolean autoCommit) { Connection conn=null; try { Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver"); //conn = DriverManager.getConnection("jdbc:pivotal:greenplum://192.168.229.146:5432;DatabaseName=database", "gpadmin", "111"); conn = DriverManager.getConnection(jdbcurl,username, password); conn.setAutoCommit(autoCommit); // logger.debug("HIVE: Connection success!"); } catch (Exception se) { // 连接失败 // logger.debug("HIVE:"+jdbcurl + "\r\n" + " Connection failed! " + se.getMessage()); logger.error("HIVE连接失败",se); return null; } return conn; } /** * @author Liyg * @description 根据传入的数据源类型,创建Connection连接信息 * @param jdbcurl * @param username * @param password * @param autoCommit * @param dbtype * @return */ public static Connection intiConnection(String jdbcdriver,String jdbcurl, String username, String password, boolean autoCommit, String dbtype) { Connection conn = null; try { Class.forName(jdbcdriver); // 连接数据库 conn = DriverManager.getConnection(jdbcurl, username, password); conn.setAutoCommit(autoCommit); // logger.debug(jdbcurl); // logger.debug("username=【" + username + "】"); // logger.debug("SQLSERVER DATABASE: Connection success!"); } catch (Exception se) { // 连接失败 // logger.debug("initSQLServer:"+jdbcurl + "\r\n" + " Connection failed! " + se.getMessage()); // System.exit(0); logger.error("连接失败",se); return null; } return conn; } /** * 关闭数据库 * @author Liyg * @param conn * @param pstmt */ public static void closeDB(Connection conn, PreparedStatement pstmt,ResultSet rs) { try { if (rs != null) { rs.close(); } rs = null; if (pstmt != null) { pstmt.close(); } pstmt = null; if (conn != null) { conn.close(); } conn = null; } catch (Exception ee) { // logger.info("关闭数据库操作异常:" + ee.getMessage()); logger.error("数据源关闭失败",ee); } } }
作者:Rest探路者
出处:http://www.cnblogs.com/Java-Starter/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意请保留此段声明,请在文章页面明显位置给出原文连接
Github:https://github.com/cjy513203427