Java and MySql Check if database exists

Question

What is the code in java to check if a database exists in Mysql exists or not?

Answer 1

You can get the list of databases from the MetaData of the Database.

Class.forName("com.mysql.cj.jdbc.Driver");

         Connection con = DriverManager.getConnection("jdbc:mysql://localhost/mysql?user=root&password=edureka");

ResultSet resultSet = connection.getMetaData().getCatalogs();

//iterate each catalog in the ResultSet

while (resultSet.next()) {

  // Get the database name, which is at position 1

  String databaseName = resultSet.getString(1);

System.out.print(databaseName);

}

Hope this helps!

Check out Java certification course to become certified expert.

Thanks!

Comments

In the database URL what is the database name i should provide?or is there some trick I don't know.

---

Hey, @There,

A JDBC URL provides a way of identifying a database so that the appropriate ... After the driver is loaded, an application must specify the correct database connection URL to connect.

The server and port specify the hostname (or IP address) and port number where the server is listening for requests and databaseName is the name of the database you want to connect to. The URLAttributes can be either Derby embedded or network client attributes.