java and mysql

[zbiszko]

Hello

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;");

Thanks for any hepl
Zbiszko

 

[Thomas Kellerer]

zbiszko wrote on 15.11.2007 23:59:

Hello

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;");

Try DatabaseMetaData.getCatalogs()

http://java.sun.com/j2se/1.5.0/docs/api/java/sql/DatabaseMetaData.html#getCatalogs()

Btw: when using executeQuery() the statement may not be terminated with a
semicolon. So probably running st.executeQuery("show databases"); would work as
well.

Thomas

 

[Martin Gregorie]

Hello

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;");
>

Now you've got the list in your result set, you need to read through it
a row at a time:

while (rs.next())
{
/* Retrieve and print the columns in this row */
}

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

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