JDBC Class.forName(String drivername) Example for MySql Database

Home Tutorial Java Jdbc Jdbcbatch JDBC Class.forName(String drivername) Example for MySql Database

JDBC Class.forName(String drivername) Example for MySql Database
Posted on: October 15, 2010 at 12:00 AM

In this tutorial, we will called the Class.forName(String drivername)that automatically creates an instance of a driver and registers it with the DriverManager.

JDBC Class.forName(String drivername) Example for MySql Database:

In this tutorial, we will called the Class.forName(String drivername)thatautomatically creates an instance of a driver and registers it with the DriverManager. Now we will create a java class JDBCforName.java and store the information like database url, database name, driver name, database user name, database password to create connection with the MySql database server as:


	
	Connection connection = 
	null;

	String url = "jdbc:mysql://192.168.10.13:3306/";

	String dbName = "roseindia_jdbc_tutorial";

	String driverName = 
	"com.mysql.jdbc.Driver";

	String userName = 
	"root";

	String password = "root";

Now we will called the Class.forName(String drivername) method and get the connection as:



Class.forName(driverName).newInstance();
connection = DriverManager.
getConnection(url+dbName, userName, 
password);

The code of the JDBCforName.java is:

import java.sql.*;
public class JDBCforName {

  public static void main(String[] args) {
    Connection connection = null;
      String url = "jdbc:mysql://localhost:3306/";
      String dbName = "roseindia_jdbc_tutorial";
      String driverName = "com.mysql.jdbc.Driver";
      String userName = "root";
      String password = "root";
      try{
        Class.forName(driverName).newInstance();
        connection = DriverManager.getConnection(url+dbName, userName, password);
        System.out.println("java Class.forName(String drivername) Example");
      }
      catch (Exception e){
        e.printStackTrace();
      }
  }
}

Program output:

Download Code

Related Tags for JDBC Class.forName(String drivername) Example for MySql Database:

«Previous Index Next»

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics