JDBC - Create Database Example

(Create your own DataBases)

This tutorial provides an example on how to create a Database using JDBC application. Before executing following example, make sure you have the following in place:

• You should have admin privilege to create a database in the given schema. To execute the following example you need to replace username and password with your actual user name and password.
• Your MySQL or whatever database you are using is up and running.

Required Steps:

There are following steps required to create a new Database using JDBC application:

1. Import the packages . Requires that you include the packages containing the JDBC classes needed for database programming. Most often, using import java.sql.* will suffice.
2. Register the JDBC driver . Requires that you initialize a driver so you can open a communications channel with the database.
3. Open a connection . Requires using the DriverManager.getConnection() method to create a Connection object, which represents a physical connection with datbase server.
   To create a new database, you need not to give any database name while preparing database URL as mentioned in the below example.
4. Execute a query . Requires using an object of type Statement for building and submitting an SQL statement to the database.
5. Clean up the environment . Requires explicitly closing all database resources versus relying on the JVM's garbage collection.

Sample Code:

Copy and past following example in JDBCExample.java, compile and run as follows:

//STEP 1. Import required packages import java.sql.*; public class JDBCExample { // 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 STUDENTS"; 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){ }// nothing we can do try{ if(conn!=null) conn.close(); }catch(SQLException se){ se.printStackTrace(); }//end finally try }//end try System.out.println("Goodbye!"); }//end main }//end JDBCExample

Now let us compile above example as follows:

C:\>javac JDBCExample.java C:\>

When you run JDBCExample, it produces following result:

C:\>java JDBCExample Connecting to database... Creating database... Database created successfully... Goodbye! C:\>