Might be problem in your mySql, the above code is working fine.
first you check for connection u geeting or not.

thanks
rajanikant

Hi,


I am sending you code for displaying all table name from database.

package javacode;

import java.sql.*;

public class DisplayTablename{

public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://192.168.10.211:3306/";;
String dbName = "amar";
String userName = "amar";
String password = "amar123";
System.out.println("Listing all table name in Database!");
System.out.println("Welcome");
try{
Class.forName(driver);
Connection con=DriverManager.getConnection(url+dbName,userName,password);
System.out.println("Connect to database!");
try{
DatabaseMetaData dbm = con.getMetaData();
String[] types = {"TABLE"};
ResultSet rs = dbm.getTables(null,null,"%",types);
System.out.println("Table name:");
System.out.println("SDKH!3");
while (rs.next()){
String table = rs.getString("TABLE_NAME");
System.out.println(table);
con.close();
}
}
catch (SQLException s){
System.out.println("No any table in the database");
}
}
catch (Exception e){
e.printStackTrace();
}
}
}


------------------------------------------------


Visit for more information.

http://www.roseindia.net/jdbc/

Thanks.

Amardeep