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



Home Java Beginners MYSQL Java Connector Library

 
 

Share on Google+Share on Google+

MYSQL Java Connector Library

Advertisement
MYSQL Java Connector Library: Steps to download the Mysql JDBC connector to establish a connection between your Java program and Mysql Database Server.

Where to download the MYSQL Java Connector Library and get the jar file

This article discuss 'how to connect Java and MYSQL using MYSQL connector' in Java. The article will give you view on downloading and installing MYSQL Java connector library into your Java application folder.

MYSQL Java connector library is required to establish a connection in between your Java application and MYSQL database. Downloading Java SDK and MYSQL server is not sufficient to create a database application in Java. You will also required a MYSQL Java Connector Library for using MYSQL server in your application.

MYSQL Java Connector Library or MySQL Connector/J is a native Java driver, which is required to converts JDBC calls into the network protocol that is further used by the MySQL database. Basically, a MySQL Connector/J is the official JDBC driver for MySQL required for connecting Java and MYSQL Database Server. You can download your copy of MYSQL Java Connector Library from the MYSQL official website.

http://dev.mysql.com/downloads/connector/j/ or

http://www.mysql.com/products/connector/

MYSQL Java Connector Library or Mysql JDBC connector is simply a Jar file that need to be copied in to your project folder. Given below are the few steps to help you setting the Mysql JDBC connector.

As you know that the JDBC driver doesn't required any installation. All you need to do is to provide the location of the file to the Java Command, whenever you starts your program. Java command is as given below:

java -cp myapp.jar;D:\classpath\mysql-connector-java-5.1.22-bin.jar MyMain

Or to add it inside your NetBeans or any other project, simply add the jar file in the "Libraries" section of your project.

  • Right click on your project in your project explorer and click on properties.
  • Go to libraries -> add jar file and choose .jar file you want to import.
  • Now, your jar file must be installed to your project classpath.
Advertisements

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: December 20, 2013

Related Tutorials

Discuss: MYSQL Java Connector Library  

Post your Comment


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