Java and MySql Delete database if exists

Question

I am building a Java application where I am giving admin to reset the database. When the user chooses to reset the database, I want to reset all the contents of the database. For this I want to drop the database and then create database with new tables. I want to know the code to implement execution of drop query if a database exists by a particular name.

Answer 1

First, you have to check if the database exists or not and then use conditional branching to drop database if it exists.

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

  if(databaseName.equals("library")) {

  System.out.print("yes");

  Statement stmt = connection.createStatement();

      

      String sql = "DROP DATABASE library";

      stmt.executeUpdate(sql);

  }

}