MySQL Workbench will popup a dialog, to show you the DDL statement to create a new schema, just click Apply button.Ĭlick Finish button to complete the schema creation step. To load the sample database, you can do the following steps:Ĭlick Create a new schema icon in the toolbar.Įnter the name of the schema, mysqljdbc, and click apply button You can download the sample database via the following link:

candidate_skills: the pivot table links between candidates & skills.

candidates: stores candidate data such as first name, last name, date of birth (dob), phone, and email.

There are three tables in the sample database. The following illustrates the database diagram: We will use a sample database named mysqljdbc for the sake of demonstration. Once the install process completes, you can find the JAR file that you will include into your Java application as the screen below: Load MySQL JDBC sample database Third, double-click on installation file to install the MySQL Connector/J. You can choose your platform specified in the Select Platform drop-down list. Second, select your appropriate platform. Download and install MySQL Connector/Jįirst, go to the Download Connector/J page on website. Third, once the installation completes, you can launch it by double click on the NetBeans IDE icon. You just have to click Next button until it completes.

Second, double-click on the installation file, and go through the process. It takes few minutes to complete the download. To download and install NetBeans IDE with JDK, you follow the steps below:įirst, you need to go to Oracle Java download page and click on the NetBeans with JDK download button. Download and install MySQL Connector/J.ĭownload and install NetBeans IDE with JDK.Oracle provides also provide use NetBeans IDE and JDK in one installation file, so you just need to download one and install both JDK and NetBeans. We choose NetBeans IDE because it’s easy to install and simple to use. You can use any Java IDE such as Eclipse or IntelliJ, which is also fine.

Download and install JDK if it is not available on your local machine.

To set up the development environment, you need to: It also illustrates how to load a sample database into MySQL for practicing in the subsequent tutorials. This tutorial shows you how to setup development environment that helps you work with MySQL and JDBC.

Mysql jdbc