New Page 1

//----------------------------------------------------------------------------
// Module: SimpleSelect.java
// Description: Test program for ODBC API interface. This java application
// will connect to a JDBC driver, issue a select statement
// and display all result columns and rows
// Product: JDBC to ODBC Bridge
//----------------------------------------------------------------------------
import java.net.URL;
import java.sql.*;
class SimpleSelect {
public static void main (String args[]) {
String url = "jdbc:odbc:deneme";
String query = "SELECT * FROM BOLGE";
try {
// jdbc-odbc köprü sürücüsünü yükle
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
DriverManager.setLogStream(System.out);
Connection con = DriverManager.getConnection (url, "KUTPRJ", "is4356ht");
checkForWarning (con.getWarnings ());
DatabaseMetaData dma = con.getMetaData ();
//System.out.println("\nConnected to " + dma.getURL());
//System.out.println("Driver " + dma.getDriverName());
//System.out.println("Version " +dma.getDriverVersion());
//System.out.println("");
Statement stmt = con.createStatement ();
ResultSet rs = stmt.executeQuery (query);
dispResultSet (rs);
rs.close();
stmt.close();
con.close();
}
catch (SQLException ex) {
System.out.println ("\n*** SQLException caught ***\n");
while (ex != null) {
System.out.println ("SQLState: " +ex.getSQLState ());
System.out.println ("Message: " + ex.getMessage ());
System.out.println ("Vendor: " +ex.getErrorCode ());
ex = ex.getNextException ();
System.out.println ("");
}
}
catch (java.lang.Exception ex) {
ex.printStackTrace ();
}
}
private static boolean checkForWarning (SQLWarning warn) throws SQLException
{
boolean rc = false;
if (warn != null) {
System.out.println ("\n *** Warning ***\n");
rc = true;
while (warn != null) {
System.out.println ("SQLState: " +warn.getSQLState ());
System.out.println ("Message: " +warn.getMessage ());
System.out.println ("Vendor: " +warn.getErrorCode ());
System.out.println ("");
warn = warn.getNextWarning ();
}
}
return rc;
}
private static void dispResultSet (ResultSet rs)
throws SQLException
{
int i;
ResultSetMetaData rsmd = rs.getMetaData ();
int numCols = rsmd.getColumnCount ();
//for (i=1; i<=numCols; i++) {
// if (i > 1) System.out.print(",");
// System.out.print(rsmd.getColumnLabel(i));
// }
System.out.println("");
boolean more = rs.next ();
while (more) {
for (i=1; i<=numCols; i++) {
if (i > 1) System.out.print(",");
System.out.print(rs.getString(i));
}
System.out.println("");
more = rs.next ();
}
}
}