servlets struts hibernate spring maven java
 

JDBC - Create Database Example



<

This instructional exercise gives a precedent on the most proficient method to make a Database utilizing JDBC application. Prior to executing the accompanying precedent, ensure you have the accompanying set up −

  • You ought to have administrator benefit to make a database in the given pattern. To execute the accompanying model, you have to supplant the username and password with your genuine client name and password.

  • Your MySQL or whatever database you are utilizing, is up and running.

Required Steps

The following advances are required to make another Database utilizing JDBC application −

  • Import the packages: Requires that you incorporate the bundles containing the JDBC classes required for database programming. Regularly, utilizing import java.sql.* will suffice.

  • Register the JDBC driver: Requires that you introduce a driver so you can open a correspondences channel with the database.

  • Open a connection: Requires utilizing the DriverManager.getConnection() strategy to make a Connection object, which speaks to a physical association with the database server.

    To make another database, you need not give any database name while getting ready database URL as referenced in the beneath example.

  • Execute a query: Requires utilizing an object of sort Statement for building and presenting a SQL articulation to the database.

  • Clean up the earth . Requires unequivocally shutting all database assets as opposed to depending on the JVM's waste collection.

Sample Code

Copy and past the accompanying model in JDBCExample.java, aggregate and keep running as pursues −

//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 made successfully..."); 

}catch(SQLException se){ 

//Handle mistakes for JDBC 

se.printStackTrace();
}catch(Exception e){ 

//Handle blunders for Class.forName 

e.printStackTrace(); 

}finally{ 

//at long last square 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 at long last try 

}//end try 

System.out.println("Goodbye!"); 

}//end main 

}//end JDBCExample

Now, let us order the above precedent as pursues −

C:\>javac JDBCExample.java 

C:\>

When you run JDBCExample, it creates the accompanying outcome −

C:\>java JDBCExample 

Connecting to database... 

Creating database... 

Database made successfully... 

Goodbye! 

C:\>






© Javacodegeeks © 2019 - 2019
All Right Reserved and you agree to have read and accepted our term and condition.

Python 3