Java JDBC: Droping database using JDBC Statement Interface

In this article, we will use JDBC API to drop database in MySQL database from Java application (i.e.; using Statement Interface)

 

1. Pre-requisite:

  • Java JDK 1.8.0_77
  • MySQL database 5.5.16
  • Eclipse Luna IDE 4.4.0
  • mysql-connector-java-5.1.38.jar file

 

2. Database parameters :

Let us move on and code an example to connect MySQL database from Java application to drop database using JDBC API. But before that, we will list down required things to connect database

  • database server IP or address (localhost)
  • sever port (3306)
  • username (root)
  • password (root@123)

Note: All (bold/italic) are database values to connect MySQL database

 

3. Droping database using JDBC Statement Interface

  • As we are ready with required things to connect MySQL database from Java application
  • We can use one of the methods from Statement Interface to execute “drop table” SQL query
    1. execute(String sqlQuery);
    2. executeUpdate(String sqlQuery);
    3. executeQuery(String sqlQuery);
  • Let us code a simple example using Statement Interface

DropDatabaseUsingJDBCStatement.java

package in.bench.resources.mysql.db.example;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class DropDatabaseUsingJDBCStatement {

	public static void main(String[] args) {

		// variables
		Connection connection = null;
		Statement statement = null;

		// Step 1: Loading or registering MySQL JDBC driver class
		try {
			Class.forName("com.mysql.jdbc.Driver");
		}
		catch(ClassNotFoundException cnfex) {
			System.out.println("Problem in loading MySQL JDBC driver");
			cnfex.printStackTrace();
		}

		// Step 2: Opening database connection
		try {

			// Step 2.A: Create and get connection using DriverManager
			connection = DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/", "root", "root@123"); 

			// Step 2.B: Creating JDBC Statement 
			statement = connection.createStatement();

			// Step 2.C: Executing SQL & retrieve data into ResultSet
			int sqlQueryResult = statement.executeUpdate(
                                        "DROP DATABASE PLAYER_INFO");

			// output of database creation
			if(0 == sqlQueryResult) {
				System.out.println("Database deleted successfully");
			}
			else {
				System.out.println("Error in deleting database");
			}
		}
		catch(SQLException sqlex){
			sqlex.printStackTrace();
		}
		finally {

			// Step 3: Closing database connection
			try {
				if(null != connection) {

					// cleanup resources, once after processing
					statement.close();

					// and then finally close connection
					connection.close();
				}
			}
			catch (SQLException sqlex) {
				sqlex.printStackTrace();
			}
		}
	}
}

Output:

0 indicates database deleted successfully 

 

4. Download:

 

Read Also:

 

References:

 

Happy Coding !!
Happy Learning !!

Java JDBC: Creating a table using JDBC Statement Interface
Java JDBC: Creating database using JDBC Statement Interface