Hello Everyone! Today in this video I am going to step by step guide you How To connect to MySQL8.0.28 database in NetBeans12.6 IDE using Database Services tool , so you can work with and manage MySQL databases right inside NetBeans without having to use an external program like MySQL Workbench or MySQL Command Line Client .
In details , you will learn :-
Download MySQL JDBC driver -
Make connection to a MySQL database
Create a new table -
Update data in a table -
Execute SQL statements Line Client
And I suppose that you're using these software programs : -
Java Development Kit ( JDK ) -
Apache NetBeans IDE -
MySQL Community server
How to connect Java application with MySQL using NetBeans steps:-
1. Downloading MySQL JDBC driver
2.Extract and open the downloaded file. There will be a file named mysql-connector-java-8.0.28.jar (version number may be different).
3.Create a MySQL database.
4. Configuring the NetBeans project
Open NetBeans and create a new project by
Clicking File -New Project
From the Choose Project window, select Java-Java Application and click next.
Choose a project name and click Finish.
Expand the project folder and Right-click on Libraries.
Select Add JAR/Folder.
Select mysql-connector-java-8.0.28jar and click open. Now you will see the jar file listed under Libraries.
Go to Window-Services.
Right-click on Databases and select New Connection.
Click Add and select mysql-connector-java-8.0.28 connectivi.jar file. From Driver drop-down, select MySQL (Connector/J driver). Click Next.
In the Customize Connection window, replace the Database name with the one you have created for the application. If you have not created a database, leave it as it is.
Click Test Connection.
If you get a Connection Succeeded message, you have connected your application with the MySQL database.
►Top Online Courses Tutorial for Beginners by Sudhir Sir :
How to download mysql 8.0.28
• How to install MYSQL Server and Workb...
how to download netbeans 12.6
• How to install java NetBeans IDE Late...
about mysql workbench
• How to create database in MySQL Workb...
about mysql client server
• Create Database and Table in MYSQL
-------------------------------------------------------------------------------
Timestamp
00:00 Introduction
01:22 Mysql Conector/J Driver Downloading
02:14 Unzip driver
03:12 Create database
03:56 Create table
05:08 Connecting Mysql and Netbeans
05:55 Create new project
07:07 Load Driver
09:00 Code writing✍️
11:14 run project
-------------------------------------------------------------------------------
►Like And Subscribe
-------------------------------------------------------------------------------
►Video tag
#DatabaseConnectivity
#connectnetbeansAndMysql
#databaseConnection
#netbeans
#mysql8
#mysqlserver
#mysqlworkbench
#javaprogramming
#javatutorial
#mysqldatabase
#connectMysqlNetbens
#netbenas12.6
Connect mysql and java NetBeans
Connect mysql and java NetBeans
Database connectivity in java
Database connectivity in netbeans12.6
How to connect MySQL8.0.28 and NetBeans12.6
How to connect mysql database in java using NetBeans
Mysql8.0.28
java database connectivity
java database connectivity tutorial
java jdbc complete tutorial
java jdbc connection mysql
java jdbc mysql
java jdbc project
jdbc connection in java mysql
jdbc in java
jdbc tutorial
what is jdbc connection in java
what is database connectivity
How to create MySQL database in NetBeans