HOW TO CREATE A DATABASE USING MYSQL WITH JDBC PROGRAM

PROGRAM

//STEP 1.

 Import required packages

 import java.sql.*; 

public class JDBCreateDataBase{ 

  // JDBC driver name and database URL  

 static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";    

 static final String DB_URL = "jdbc:mysql://localhost/"; 

   //  Database credentials   

static final String USER = "username";

   static final String PASS = "password";

   public static void main(String[] args) {

    Connection conn = null;  

 Statement stmt = null;

    try{

       //STEP 2: Register JDBC driver 

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

      //STEP 3: Open a connection

      System.out.println("Connecting to database...");

       conn = DriverManager.getConnection(DB_URL, USER, PASS); 

      //STEP 4: Execute a query

      System.out.println("Creating database...");

       stmt = conn.createStatement(); 

            String sql = "CREATE DATABASE ashok";  

    stmt.executeUpdate(sql);    

  System.out.println("Database created successfully...");

    }

catch(SQLException se){ 

     //Handle errors for JDBC  

    se.printStackTrace();   

}catch(Exception e){

       //Handle errors for Class.forName   

   e.printStackTrace();

   }

finally{

       //finally block used to close resources 

     try{

         if(stmt!=null) 

           stmt.close(); 

     }catch(SQLException se2){

      }

    try{ 

        if(conn!=null) 

           conn.close();  

    }catch(SQLException se){ 

        se.printStackTrace(); 

     }

//end finally try

   }

}

//end main

 }