How to check whether database exists?

Hi,

I have to create a database in mysql. I am able to create that successfully from using JDBC. But before to creating the database, i want to check whether database exists or not? How can i do this check. can any one help me on this.

Please find thesample code

`public class CreateDatabase {  public static void main(String[] args) {
Connection connection = null;
Statement statement = null;
try {
  Class.forName("org.gjt.mm.mysql.Driver").newInstance();
  String url = "jdbc:mysql://localhost/mysql";
  connection = DriverManager.getConnection(url, "username", "password");

  statement = connection.createStatement();
  String hrappSQL = "CREATE DATABASE hrapp";
  statement.executeUpdate(hrappSQL);
} catch (Exception e) {
  e.printStackTrace();
} finally {
  if (statement != null) {
    try {
      statement.close();
    } catch (SQLException e) {
    } // nothing we can do
  }
  if (connection != null) {
    try {
      connection.close();
    } catch (SQLException e) {
    } // nothing we can do
  }
}

}

} `

Thanks, Narayan

View Answers

November 13, 2010 at 5:30 PM

Hi Friend,

You can use the following code:

import java.sql.*;
import java.util.*;
class CheckDatabase{
    public static void main(String[] args) throws Exception{
        ArrayList<String> list=new ArrayList<String>();
        Scanner input=new Scanner(System.in);
        System.out.println("Enter Database name:");
        String database = input.nextLine();
        Class.forName("com.mysql.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306","root","root");
        Statement st = con.createStatement();
        DatabaseMetaData meta = con.getMetaData();
        ResultSet rs = meta.getCatalogs();
        while (rs.next()) {
            String listofDatabases=rs.getString("TABLE_CAT");
            list.add(listofDatabases);
        }
        if(list.contains(database)){
        System.out.println("Database already exists");
            }
            else{
            st.executeUpdate("CREATE DATABASE "+database);
            System.out.println("Database is created");
            }
            rs.close();
        }

    }

Thanks









Related Tutorials/Questions & Answers:
Advertisements

Questions by Category