Java Reference
In-Depth Information
Class.forName(jdbcDriver);
DriverManager.registerDriver(new JdbcOdbcDriver());
}
catch(ClassNotFoundException e){
reportException(e.getMessage());
}
catch(SQLException e){
reportException(e.getMessage());
}
}
public String[][] executeQuery(String SQLQuery){
Vector dataSet = new Vector();
String url = urlRoot+dbName;
try {
Connection con = DriverManager.getConnection(url);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(SQLQuery);
ResultSetMetaData md = rs.getMetaData();
int nColumns = md.getColumnCount();
while(rs.next()){
String[] rowData = new String[nColumns];
for(int i=0;i<nColumns;i++){
rowData[i] = rs.getObject(i+1).toString();
}
dataSet.addElement(rowData);
}
con.close();
}
catch(SQLException e){
reportException(e.getMessage());
}
String[][] records = new String[dataSet.size()][];
