Re: java and mysql

From:

=?ISO-8859-1?Q?Arne_Vajh=F8j?= <arne@vajhoej.dk>

Newsgroups:

comp.lang.java.programmer

Date:

Fri, 16 Nov 2007 23:40:53 -0500

Message-ID:

<473e70d3$0$90275$14726298@news.sunsite.dk>

zbiszko wrote:

how can I get all databeses from mysql database?
I was trying such code, but without any results:(

Connection con;
  con = getConnection("jdbc:mysql://localhost:3306", "root",
"pasword");
  Statement st = (Statement) con.createStatement();
  ResultSet rs = st.executeQuery("Show databases;");

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