本文實例講述了java獲得mysql和oracle鏈接的類。分享給大家供大家參考。具體如下:
導入java.sql.connection; import java.sql.drivermanager; import java.sql.sqlexception; public Class class connectdb {private static final final string mysql =“ jdbc:mysql:mysql:// :thin:@“; private connectdb (){} public static Connection getInstance(字符串dbtype,string url)拋出nosuchdbexception,sqlexception {if(if(“ mysql” .equalsignorecase(dbtype))返回.equalsignorecase(dbType))返回getoracleconn(url); return null ;} public static void colleconn(connection conn){if(conn!= null){try {conn.close();} catch(sqlexception e){e){e){e。 printStackTrace();}}}}私有靜態連接getMysqlConn(string url)拋出sqlexception {connection conn = null; try {class.forname(“ com.mysql.jdbc.driver”) ();} conn = drivermanager.getConnection(mysql + url,“ root” ,“ root”); return conn;}私有靜態連接getoracleConn(string url)拋出sqlexception {connection conn = null; oracle.jdbc.driver.oracledriver“);} catch(classNotFoundException e){e.printstacktrace(); } conn = drivermanager.getConnection(oracle + url,“ scott”,“ scott”,“ scott”,“ scott”,“ tiger”,“ tiger”}}}}}}}}}}}}}}}} }}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}
希望本文所述對大家的爪哇程序設計有所幫助。