CLI SQL: JDBC (3/3)

import java.net.URL;

import java.sql.*;

class jdbc_query {

public static void main(String argv[]) { // usage: java jdbc_query URL ...

try {

Class.forName("jdbc.odbc.JdbcOdbcDriver "); // JDBC-ODBC bridge

String url = argv[0]; // may be user=argv[1]; pwd=argv[2];

Connection con = DriverManager.getConnection(url, …);

Statement stmt = con.createStatement();

ResultSet rs = stmt.executeQuery("select tablename from cat");

while(rs.next()) {

String name = rs.getString("tablename");

System.out.println(name); }

stmt.close();

con.close; } catch(Exception e) {System.out.println(e.getMessage()); }

} // end main } // end class