Re: java and mysql

zbiszko wrote:


Code:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class ShowDatabases {
     public static void main(String[] args) throws Exception {
         Class.forName("com.mysql.jdbc.Driver");
         Connection con =
DriverManager.getConnection("jdbc:mysql://localhost/Test", "root", "");
         Statement stmt = con.createStatement();
         ResultSet rs1 = stmt.executeQuery("SHOW DATABASES");
         while(rs1.next()) {
             System.out.println(rs1.getString(1));
         }
         rs1.close();
         ResultSet rs2 = stmt.executeQuery("SELECT SCHEMA_NAME FROM
INFORMATION_SCHEMA.SCHEMATA");
         while(rs2.next()) {
             System.out.println(rs2.getString(1));
         }
         rs2.close();
         ResultSet rs3 = con.getMetaData().getCatalogs();
         while(rs3.next()) {
             System.out.println(rs3.getString(1));
         }
         rs3.close();
         con.close();
     }
}

Arne