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.

Ads

Tutorials   
Change Column Name in MySQL Java Mysql Connection Example JDBC Example with MySQL Jdbc Mysql Connection String Jdbc Mysql Connection Url Getting Column Names from a database table in Java Count Rows from a Database Table JDBC Example with MySQL Write Text File to Table Inserting Image in Database Table Insert Data in Table Using Stored Procedure Copy One Database Table to Another Copy Table in a MySQL Database Set Timestamp by using the Prepared Statement Set Time by using the Prepared Statement Set Date by using the Prepared Statement Prepared Statement Set Big Decimal Set byte, short and long data types by using the Prepared Statement Set Data Types by using Prepared Statement Using the Prepared Statement Twice Deleting Records using the Prepared Statement Count Records using the Prepared Statement Inserting Records using the Prepared Statement Update Records using Prepared Statement Select Records Using Prepared Statement Prepared Statement With Batch Update Statement Batch Update Prepared Statement Set Object Cross Join Tables in a Specific Database Join tables with the NATURAL RIGHT JOIN operation Join tables with the NATURAL LEFT JOIN operation Join tables in the specific database Delete a Column from a Database Table Delete a Specific Row from a Database Table Deleting All Rows from a Database Table Sum of Column in a Database Table Arrange a Column of Database Table Arrange a Column of Database Table Remove Unique Column in Database Table Make Unique Column in Database Table Change Column Name of a Table Adding a New Column Name in Database Table Retrieving All Rows from a Database Table Inserting values in MySQL database table Retrieving Tables from a Database Deleting a Table from Database Description of Database Table Creating a MySQL Database Table to store Java Types Creating a Database Table Creating a Database in MySQL
Ads

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:
  • 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.

  • forName(String driver):-
  •  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.

  • java.sql.DriverManager:-
  • 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.

  • getConnection():
  • 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).

    • 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():
  • 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;
	}
}

Download Source Code

Advertisements

Share on Google+Share on Google+

Java Mysql Connection Example

Posted on: July 6, 2013 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: Java Mysql Connection Example  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads