Java-database connection Java-MySQL connection (2): JDBC driver acquisition method (for MySQL) and data connection preparation / September 2017

Get JDBC driver (for MySQL)-database connection

In order to connect to MySQL, you need to prepare a JDBC driver that supports MySQL. It is provided by the MySQL website.

You can download it from the URL below. http://dev.mysql.com/downloads/connector/

When you access the above URL, you will find a link called "Connector / J". Clicking this will take you to the Download Connector / J page. Follow the steps below to download the JDBC driver that supports MySQL.


Select Platform: Platform Independent. The download will start. Downloaded files are usually saved in the download folder on Windows. Open Windows Explorer (Windows button + E button). Open the download folder. Make sure that the following files are saved: mysql-connector-java-x.x.xx.zip

Right-click on mysql-connector-java-x.x.xx.zip. Select "7-Zip-> Extract to mysql-connector-java-x.x.xx ".

When mysql-connector-java-x.x.xx.zip is unzipped, a mysql-connector-java-x.x.xx folder is created. Open the mysql-connector-java-x.x.xx folder. Make sure you have "mysql-connector-java-x.x.xx-bin.jar".


The following are the above remarks.


Java-database connection / Java-MySQL connection ① Overview of JDBC and JDBC driver (2) JDBC driver acquisition method (for MySQL) and data connection preparation ③-1 How to set CLASSPATH in environment variable ③-2 How to set CLASSPATH to Eclipse build busLoad JDBC driverConnect to database (MySQL) to search table information and display search results


Recommended Posts

Java-database connection Java-MySQL connection (2): JDBC driver acquisition method (for MySQL) and data connection preparation / September 2017
Java-database connection Java-MySQL connection ①: JDBC and JDBC driver overview / September 2017
Java-database connection Java-MySQL connection ④: JDBC driver loading / September 2017
Java-database connection Java-MySQL connection ⑤: Connect to the database (MySQL) to search table information and display search results / September 2017
[About JDBC that connects Java and SQL]
Java-database connection Java-MySQL connection ①: JDBC and JDBC driver overview / September 2017
[For beginners] ○○. △△ in Ruby (ActiveRecord method, instance method, data acquisition)