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 |
* DSqlHandler.java |
2 |
26 Feb 07 |
jari |
5 |
* |
2 |
26 Feb 07 |
jari |
* Created on February 25, 2002, 1:28 PM |
2 |
26 Feb 07 |
jari |
7 |
*/ |
2 |
26 Feb 07 |
jari |
8 |
|
2 |
26 Feb 07 |
jari |
9 |
import java.sql.Connection; |
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 |
* @author Adam Margolin |
2 |
26 Feb 07 |
jari |
* @author Raktim Sinha |
2 |
26 Feb 07 |
jari |
18 |
*/ |
2 |
26 Feb 07 |
jari |
19 |
|
2 |
26 Feb 07 |
jari |
20 |
public class DSqlHandler { |
2 |
26 Feb 07 |
jari |
21 |
|
2 |
26 Feb 07 |
jari |
22 |
Connection connection; |
2 |
26 Feb 07 |
jari |
23 |
|
2 |
26 Feb 07 |
jari |
/** Creates new DExperimentData */ |
2 |
26 Feb 07 |
jari |
25 |
public DSqlHandler() { |
2 |
26 Feb 07 |
jari |
26 |
} |
2 |
26 Feb 07 |
jari |
27 |
|
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 boolean saveItem(String sql){ |
2 |
26 Feb 07 |
jari |
32 |
Statement statement = null; |
2 |
26 Feb 07 |
jari |
33 |
|
2 |
26 Feb 07 |
jari |
34 |
int result = 0; |
2 |
26 Feb 07 |
jari |
35 |
try{ |
2 |
26 Feb 07 |
jari |
36 |
connection = ConnectionFactory.getConnection("",""); |
2 |
26 Feb 07 |
jari |
37 |
statement = connection.createStatement(); |
2 |
26 Feb 07 |
jari |
38 |
result = statement.executeUpdate(sql); |
2 |
26 Feb 07 |
jari |
39 |
}catch(Exception e){ |
2 |
26 Feb 07 |
jari |
40 |
e.printStackTrace(); |
2 |
26 Feb 07 |
jari |
41 |
}finally{ |
2 |
26 Feb 07 |
jari |
42 |
try{ |
2 |
26 Feb 07 |
jari |
43 |
if(statement != null){ |
2 |
26 Feb 07 |
jari |
44 |
statement.close(); |
2 |
26 Feb 07 |
jari |
45 |
} |
2 |
26 Feb 07 |
jari |
46 |
if(connection != null){ |
2 |
26 Feb 07 |
jari |
47 |
connection.close(); |
2 |
26 Feb 07 |
jari |
48 |
} |
2 |
26 Feb 07 |
jari |
49 |
}catch(SQLException sqle){ |
2 |
26 Feb 07 |
jari |
50 |
sqle.printStackTrace(); |
2 |
26 Feb 07 |
jari |
51 |
} |
2 |
26 Feb 07 |
jari |
52 |
} |
2 |
26 Feb 07 |
jari |
53 |
return(result == 1); |
2 |
26 Feb 07 |
jari |
54 |
} |
2 |
26 Feb 07 |
jari |
55 |
|
2 |
26 Feb 07 |
jari |
56 |
public boolean saveItemTestServer(String sql){ |
2 |
26 Feb 07 |
jari |
57 |
Statement statement = null; |
2 |
26 Feb 07 |
jari |
58 |
|
2 |
26 Feb 07 |
jari |
59 |
int result = 0; |
2 |
26 Feb 07 |
jari |
60 |
try{ |
2 |
26 Feb 07 |
jari |
61 |
connection = ConnectionFactory.getConnectionTestServer(); |
2 |
26 Feb 07 |
jari |
62 |
statement = connection.createStatement(); |
2 |
26 Feb 07 |
jari |
63 |
result = statement.executeUpdate(sql); |
2 |
26 Feb 07 |
jari |
64 |
}catch(Exception e){ |
2 |
26 Feb 07 |
jari |
65 |
e.printStackTrace(); |
2 |
26 Feb 07 |
jari |
66 |
}finally{ |
2 |
26 Feb 07 |
jari |
67 |
try{ |
2 |
26 Feb 07 |
jari |
68 |
if(statement != null){ |
2 |
26 Feb 07 |
jari |
69 |
statement.close(); |
2 |
26 Feb 07 |
jari |
70 |
} |
2 |
26 Feb 07 |
jari |
71 |
if(connection != null){ |
2 |
26 Feb 07 |
jari |
72 |
connection.close(); |
2 |
26 Feb 07 |
jari |
73 |
} |
2 |
26 Feb 07 |
jari |
74 |
}catch(SQLException sqle){ |
2 |
26 Feb 07 |
jari |
75 |
sqle.printStackTrace(); |
2 |
26 Feb 07 |
jari |
76 |
} |
2 |
26 Feb 07 |
jari |
77 |
} |
2 |
26 Feb 07 |
jari |
78 |
return(result == 1); |
2 |
26 Feb 07 |
jari |
79 |
} |
2 |
26 Feb 07 |
jari |
80 |
|
2 |
26 Feb 07 |
jari |
81 |
public ResultSet fetchItemsOracle(String sql){ |
2 |
26 Feb 07 |
jari |
82 |
try{ |
2 |
26 Feb 07 |
jari |
83 |
connection = OracleConnectionFactory.getConnectionOracle(); |
2 |
26 Feb 07 |
jari |
84 |
|
2 |
26 Feb 07 |
jari |
85 |
Statement statement = connection.createStatement(); |
2 |
26 Feb 07 |
jari |
86 |
|
2 |
26 Feb 07 |
jari |
87 |
ResultSet rs = statement.executeQuery(sql); |
2 |
26 Feb 07 |
jari |
88 |
|
2 |
26 Feb 07 |
jari |
89 |
return rs; |
2 |
26 Feb 07 |
jari |
90 |
|
2 |
26 Feb 07 |
jari |
91 |
}catch(Exception e){ |
2 |
26 Feb 07 |
jari |
92 |
e.printStackTrace(); |
2 |
26 Feb 07 |
jari |
93 |
return null; |
2 |
26 Feb 07 |
jari |
94 |
} |
2 |
26 Feb 07 |
jari |
95 |
} |
2 |
26 Feb 07 |
jari |
96 |
|
2 |
26 Feb 07 |
jari |
97 |
/** |
2 |
26 Feb 07 |
jari |
* Raktim |
2 |
26 Feb 07 |
jari |
* Trial Version of Driver used. |
2 |
26 Feb 07 |
jari |
* Max queries = 25 |
2 |
26 Feb 07 |
jari |
* @param sql |
2 |
26 Feb 07 |
jari |
* @return |
2 |
26 Feb 07 |
jari |
103 |
*/ |
2 |
26 Feb 07 |
jari |
104 |
public ResultSet fetchItemsCSV(String sql){ |
2 |
26 Feb 07 |
jari |
105 |
try{ |
2 |
26 Feb 07 |
jari |
106 |
connection = ConnectionFactory.getConnectionCSV(); |
2 |
26 Feb 07 |
jari |
107 |
|
2 |
26 Feb 07 |
jari |
108 |
Statement statement = connection.createStatement(); |
2 |
26 Feb 07 |
jari |
109 |
|
2 |
26 Feb 07 |
jari |
110 |
ResultSet rs = statement.executeQuery(sql); |
2 |
26 Feb 07 |
jari |
111 |
|
2 |
26 Feb 07 |
jari |
112 |
return rs; |
2 |
26 Feb 07 |
jari |
113 |
|
2 |
26 Feb 07 |
jari |
114 |
}catch(Exception e){ |
2 |
26 Feb 07 |
jari |
115 |
e.printStackTrace(); |
2 |
26 Feb 07 |
jari |
116 |
return null; |
2 |
26 Feb 07 |
jari |
117 |
} |
2 |
26 Feb 07 |
jari |
118 |
} |
2 |
26 Feb 07 |
jari |
119 |
} |