本文实例讲述了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”}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}
希望本文所述对大家的爪哇程序设计有所帮助。