Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Jdbc JDBC Connectivity Code In Java

Related Tutorials


 
 

Share on Google+Share on Google+

JDBC Connectivity Code In Java

Advertisement
In this Tutorial we want to describe you a code that helps you in understanding Jdbc Connectivity Code in Java.

JDBC Connectivity Code In Java

     

In this Tutorial we want to describe you a code that helps you in understanding JDBC Connectivity Code in Java. In this program, the code returns you the time set by the driver to connect url and database. For this we have a class JdbcConnectivityCodeInJava and include the main method given by the list of steps are involved -

 In order to know the time required to connect url and database, we import a package java.sql,enables you to connect the url and database. Loading a driver by calling a class.forName ( ),that accept driver class as argument. Once the driver is loaded, you set the time by the driver to connect url and database. The following methods are used to set and get the time by driver -

  DriverManager.setLoginTimeout ( )  - This method set you the time taken by the driver to connect the url and a database in second.

  DriverManager.getLoginTimeout( )  -This method return the time taken by the driver to connect the url and a database in second.

On execution of the code connection login timeout is printed and connection is created.. In case there is an exception occurred  in establishing a connection between database and url in the try block. The catch block check the exception and println print the exception.

JdbcConnectivityCodeInJava.java

import java.sql.*;
public class JdbcConnectivityCodeInJava {
  public static void main(String args[]) {
  Connection con = null;
  String url = "jdbc:mysql://localhost:3306/";
  String db = "komal";
  String driver = "com.mysql.jdbc.Driver";
  String user = "root";
  String pass = "root";
  try {
  Class.forName(driver);
  DriverManager.setLoginTimeout(10);
  System.out.println("Connection Login Timeout : " +
  DriverManager.getLoginTimeout()+" Sec");
  con = DriverManager.getConnection(url + db, user, pass);
  System.out.println("Connection is created....");
  con.close();
  catch (Exception e) {
  System.out.println(e);
  }
  }
}

Output

Connection Login Timeout : 10 Sec
Connection is created....

Download code

Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: November 17, 2008

Related Tutorials

Discuss: JDBC Connectivity Code In Java   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:1
Vishv Deepak
August 27, 2012
JDBC

while registering jdbc driver using DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); my program gives error that unknown symbol symbol :clas jdbc please,tell obout it. thankyou sir
DMCA.com