You need to import required classes/interfaces from java.sql.* package which acts as a bridge between Java application and database. We write a class ( JDBCMySQLConnection) defining database connection configuration statements and methods to make JDBC connect to MySQL database.įollowing steps are involved in JDBC MySQL connection. If you are a newbie, refer this link on getting started with Java and Eclipse. Create a new Java Project and name it as “ JDBCMySQLSample“.Create the following tables inside this database.įoreign key references department(dept_id).Create a database in MySQL and name it as “ jdbcdb“.This JDBC MySQL example uses a sample database “ jdbcdb” which contains the following table Unzip the connector to a safe location on your computer which contains MySQL Connector/J JAR. This tutorial uses JDBC MySQL connector 5.1 version. The Java MySQL connector JAR can be downloaded from.MySQL Connector/J is the official MySQL JDBC driver.These files must be in our classpath (which is explained later under Configure JDBC Driver in Eclipse) otherwise we will get some class-not-found-exceptions indicating that the driver was not found on the classpath. This connector is typically delivered with the product in a jar or zip file or available in the provider’s website. To reach the database using JDBC we need a JDBC driver from the database provider in our case – MySQL. The JDBC database Connector provides access to the database. A database specific driver is required for each database which implements the JDBC API. JDBC API mostly consists of interfaces which work independently of any database. Refer this tutorial on MySQL for creating database and tables, inserting data into tables, etc. This Java database application uses MySQL as sample database.This MySQL JDBC example requires MySQL database to be installed.

Alternatively, you can use any Integrated Development Environment (IDE) (such as Eclipse, NetBeans, etc). You can code and run a Java program using a simple text editor (such as Notepad) and use command prompt to run the program. Refer the links to install Java in Windows, Ubuntu. Make sure you have Java SE installed in you computer. The JDBC classes are contained in the Java package java.sql and javax.sql.įollow the steps to setup a JDBC development environment with which you can compile and run JDBC MySQL example. It provides methods for querying and updating data in a database. Java Database Connectivity (JDBC) is a Java-based data access technology that defines how a client may access a database.

Mysql jdbc url example