import java.sql.*;
import java.io.*;
class SelectQuery{
public static void main( String argv[] ){
try{
Class.forName ("jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:msaccessdb";
Connection dbcon = DriverManager.getConnection (url, "","");
String queries = "select * from emp";
Statement smnt = dbcon.createStatement( );
ResultSet res = smnt.executeQuery( queries );
boolean more = res.next();
while ( more ){
System.out.println( "Col1: " + res.getInt( "col1" ));
more = res.next();
}
} catch (java.lang.Exception ex) {
System.out.println( "** Error on data select.** " );
ex.printStackTrace ();
}
}
}
|