You may also want to download MySQL Workbench - a graphical tool for working with MySQL databases. MySQL ( download MySQL Community Server 5.6.12).PrerequisitesTo begin, make sure you have the following pieces of software installed on your computer: Understand the principal JDBC interfaces and classesġ.

Although the target database system is MySQL, but the same technique can be applied for other database systems as well because the query syntax used is standard SQL which is supported by all relational database systems.We will learn how to do insert, query, update and delete database records by writing code to manage records of a table Users in a MySQL database called SampleDB. These CRUD operations are equivalent to the INSERT, SELECT, UPDATE and DELETE statements in SQL language. This JDBC tutorial is going to help you learning how to do basic database operations (CRUD - Create, Retrieve, Update and Delete) using JDBC (Java Database Connectivity) API. Right click the corresponding server and select run SQL Select the corresponding file SQL File to run the relevant SQL File to build a database or tableĤ、Java Use in jdbc Connect to the database in the server import java.

Select the save location to save the database SQL file （ The database is built inside SQL sentence ） Insert a method to import the built table ：Īfter selecting the corresponding database, right-click dump as SQL file, choice “ Structure and data ” or “ structure ” Open Navicat, stay “ Connect ” Choose from MySQL openĬopy to IP Paste the address to the host, The connection name can be set at will, Click OK to connect to the database in the server Password setting related problems and solutions 3、 Connect NavicatĬomplete mysql After the installation and setting of, you can connectĪnd enter the password, Connect mysql The serverįind the public network in the server information IP And copy When modifying the initial password, be careful not to be too simple, Otherwise, an error will be reported 4、Java Use in jdbc Connect to the database in the serverġ、 Open the remote connection in the server （ Take Alibaba cloud for example ）Ģ、 Use yum download mysql And complete the basic settings.2、 Use yum download mysql And complete the basic settings.1、 Open the remote connection in the server （ Take Alibaba cloud for example ）.

Mysql jdbc do not close connection