Java Mysql Connection Example
We are going to discus how to connect MySQL in java. We have been provide some classes and API with which we will make use of the database connection. Database plays an important role in any application which requires to store the data and to fetch the data.
To use a database in Java we requires an API provided by Sun Microsystem named JDBC. A JDBC has various interfaces and classes that we need to use for connecting with the database. We will describe the required classes and interfaces that are used in to connect with the database.
Requirements to connect with the MySQL database in Java
- MySQL should be installed in your computer.
- MySQL connector JAR (should be kept into lib folder).
In this example how to connect the MySQL database with java prommining.
Classes, interfaces and methods of JDBC used in to connect with the databases in Java :
To connect with the database in Java we need following classes, interfaces and methods. These are as follows :
- java.sql.Connection:
- forName(String driver):-
- java.sql.DriverManager:-
- getConnection():
- url:- url specifies the path for connecting the database.
- user:- user specifies the database user.
- password:- Password specifies the password of the
database user.
- close():
Connection is an interface in java.sql package that specifies the connection with specific database. The SQL statement has a executed within the context of the connection interface.
The forName(String driver) is a static method of java.lang.Class class that loads the class at run time. It loads the class and gives an instance of class. It takes a string value as the parameter which specifies the full name of the class. In the database connection this method is used to load the required JDBC driver at run time.
Driver Manager is a class of java.sql package. It controls a set of JDBC driver. Every driver to be registered with class. DriverManager locates the required driver that are loaded at initialization and/or loaded explicitly by the class loader in an application.
This method is overloaded with different parameters in the class DriverManager. This method is used to get the established connection with the specified parameters. For example getConnection(url, user, password).
This methods is a method of Connection interface used for releasing the connection object.
Description of program:
In this example we have created JDBC connection and we use forName("com.mysql.jdbc.driver") and we use JDBC driver Manager than set of database name ,username and password. In this example you can use any java JDBC connection
Example of database connection:-
import java.sql.*; public class Connect { Connection con; public Connection getConnect() { try { Class.forName("com.mysql.jdbc.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/DatabaseName", "root", "root"); } catch (Exception e) { e.printStackTrace(); } return con; } }