What are the main steps in java to make JDBC connectivity?

There are following steps required to create a new Database using JDBC application: 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. Register the JDBC driver . Requires that you initialize a driver so you can open a communications channel with the database. 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. Execute a query . Requires using an object of type Statement for building and submitting an SQL statement to the database. Clean up the environment . Requires explicitly closing all database resources versus relying on the JVM's garbage collection. Original link: http://www.tutorialspoint.com/jdbc/jdbc-create-database.htm

http://www.java2novice.com/jdbc/create-connection/