/* $Id: Select.java,v 2.1 1998/10/25 17:04:56 borg Exp $ */
import java.net.URL;
import java.sql.*;
import java.util.*;

/**
 * Last modified $Date: 1998/10/25 17:04:56 $
 * @version $Revision: 2.1 $
 */
class Select {
    public static void main(String argv[]) {
	try {
	    String url = "jdbc:msql://carthage.imaginary.com:1114/test";
	    Properties p = new Properties();
	    ResultSetMetaData meta;
	    Connection con;
	    Statement stmt;
	    ResultSet rs;
	    
	    p.put("user", "borg");
	    Class.forName("com.imaginary.sql.msql.MsqlDriver");
	    // ここで接続が確立される。
	    con = DriverManager.getConnection(url, "borg", "");
	    stmt = con.createStatement();
	    rs = stmt.executeQuery("SELECT * from test ORDER BY test_id");
	    meta = rs.getMetaData();
	    System.out.println("Got results:");
	    while(rs.next()) {
		int a= rs.getInt("test_id");
		String str = rs.getString("test_val");

		System.out.print("\ttest_id= " + a);
		System.out.println("/str= '" + str + "'");
	    }
	    stmt.close();
	    DatabaseMetaData dbmd = con.getMetaData();
	    rs = dbmd.getTables(null, null, null, null);
	    while( rs.next() ) {
		System.out.println("Table: " + rs.getString("TABLE_NAME"));
	    }
	    con.close();
	}
	catch( Exception e ) {
	    System.out.println(e.getMessage());
	    e.printStackTrace();
	}
    }
}