Java and MySql: Delete database if exists

0 votes
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.
Aug 27 in Java by Reshma
35 views

1 answer to this question.

0 votes

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

  }

}
answered Aug 27 by Varun

Related Questions In Java

0 votes
1 answer

Java and MySql: Delete database if exists

First, you have to check if the ...READ MORE

answered Sep 30 in Java by Kiran
39 views
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by parth295
• 4,640 points
197 views
0 votes
1 answer

How to connect Java to MySql Database?

Make sure you have the MySQL jdbc ...READ MORE

answered Sep 30 in Java by Shyam
44 views
0 votes
1 answer

How to create database in MySql using Java?

First, you will have to create connection ...READ MORE

answered Sep 30 in Java by Shri
35 views
0 votes
1 answer

Accessing connection from different class in Java / MySQL?

You should just instantiate DoComms with every ...READ MORE

answered Nov 14, 2018 in Database by nirvana
• 3,060 points
40 views
0 votes
2 answers

MySQL "Could not create connection to database serve" error

When I am trying to connect netbeans ...READ MORE

answered Apr 14 in Database by anonymous

edited Apr 15 by Kalgi 2,111 views
0 votes
1 answer

How to connect Java to MySql Database?

This will work: try { ...READ MORE

answered Aug 27 in Java by John
53 views
0 votes
1 answer

How to create database in MySql using Java?

First, you will have to create connection ...READ MORE

answered Aug 27 in Java by Juni
33 views
0 votes
1 answer

Java and MySql: Check if database exists

You can get the list of databases ...READ MORE

answered Aug 27 in Java by Kunal
72 views
0 votes
1 answer

Java and MySql: Check if database exists

You can get the list of databases ...READ MORE

answered Sep 30 in Java by Tina
53 views