mev-4.0.01/source/org/tigr/microarray/mev/cgh/DBObj/OracleConnectionFactory.java

Code
Comments
Other
Rev Date Author Line
2 26 Feb 07 jari 1 package org.tigr.microarray.mev.cgh.DBObj;
2 26 Feb 07 jari 2
2 26 Feb 07 jari 3 /*
2 26 Feb 07 jari 4  * ConnectionFactory.java
2 26 Feb 07 jari 5  *
2 26 Feb 07 jari 6  * Created on February 25, 2002, 1:31 AM
2 26 Feb 07 jari 7  */
2 26 Feb 07 jari 8 import java.sql.Connection;
2 26 Feb 07 jari 9 import java.sql.DriverManager;
2 26 Feb 07 jari 10 import java.sql.ResultSet;
2 26 Feb 07 jari 11 import java.sql.SQLException;
2 26 Feb 07 jari 12 import java.sql.Statement;
2 26 Feb 07 jari 13
2 26 Feb 07 jari 14 /**
2 26 Feb 07 jari 15  *
2 26 Feb 07 jari 16  * @author  Adam Margolin
2 26 Feb 07 jari 17  * @author Raktim Sinha
2 26 Feb 07 jari 18  */
2 26 Feb 07 jari 19
2 26 Feb 07 jari 20 public class OracleConnectionFactory {
2 26 Feb 07 jari 21     private static OracleConnectionFactory ref = new OracleConnectionFactory();
2 26 Feb 07 jari 22     /** Creates new ConnectionFactory */
2 26 Feb 07 jari 23     public OracleConnectionFactory() {
2 26 Feb 07 jari 24         try{
2 26 Feb 07 jari 25             Class.forName("oracle.jdbc.driver.OracleDriver");
2 26 Feb 07 jari 26         }catch(ClassNotFoundException e){
2 26 Feb 07 jari 27             System.out.println("ERROR:  Exception loading driver class");
2 26 Feb 07 jari 28         }
2 26 Feb 07 jari 29     }
2 26 Feb 07 jari 30
2 26 Feb 07 jari 31     public static Connection getConnectionOracle() throws SQLException{
2 26 Feb 07 jari 32         String url = "jdbc:oracle:thin:@158.130.47.16:1521:genomics";
2 26 Feb 07 jari 33
2 26 Feb 07 jari 34         String username = "margolia";
2 26 Feb 07 jari 35         String password = "richmond1";
2 26 Feb 07 jari 36
2 26 Feb 07 jari 37         return DriverManager.getConnection(url, username, password);
2 26 Feb 07 jari 38     }
2 26 Feb 07 jari 39
2 26 Feb 07 jari 40     public static void close(ResultSet rs){
2 26 Feb 07 jari 41         try{
2 26 Feb 07 jari 42             rs.close();
2 26 Feb 07 jari 43         }catch(Exception ignored){}
2 26 Feb 07 jari 44     }
2 26 Feb 07 jari 45
2 26 Feb 07 jari 46     public static void close(Statement stmt){
2 26 Feb 07 jari 47         try{
2 26 Feb 07 jari 48             stmt.close();
2 26 Feb 07 jari 49     }catch (Exception ignored){}
2 26 Feb 07 jari 50     }
2 26 Feb 07 jari 51
2 26 Feb 07 jari 52     public static void close(Connection conn){
2 26 Feb 07 jari 53         try{
2 26 Feb 07 jari 54             conn.close();
2 26 Feb 07 jari 55     }catch (Exception ignored){}
2 26 Feb 07 jari 56     }
2 26 Feb 07 jari 57 }

Generated on Thu Jul 20 09:25:16 2023 (UTC) by svndigest 0.11.2pre (dev build 1672)