How to connect MySql database in java using eclipse || MySql jdbc connection in eclipse

in this video we are going to create jdbc connection with mySQL database for this open your clips go to file new create a Java project Java budget next add the project name my project finish Source 70 right click on Project create a new class jdbc example write the main method now let's write the first step there are steps to connect the database I'm going to write the first step step one establish the connection using the first step as register the driver for this use class dot for name method which is going to take a string value and double quotes you can write com Dot MySQL Dot here now comes the package name that is CJ connector jar dot jdbc now the class name is driver now semicolon now you can see an error it's an exception add throws declaration throws class node form now let's see the second step and the second step we are going to establish the connection step two create the connection or establish the connection we are going to use the connection interface connections here and then PCT i1 is equals to driver manager class dot get connection write the URL jdbc colon MySQL colon foreign [Music] [Music] let me just scroll this root and the password is also root then just let me go and import the connection interface it's giving me an exception I'm just going to click and then add import Java dot SQL now I'm getting a couple time exception just add the throws declaration that will be an SQL exception now just let me write system.print element and connection I'm just going to write a connection establish I'll create it so that when I run this our console is displayed with connection created save it Ctrl s then now let's run a code just right click run as run Java application as you can see we are getting an exception cluster found as I have not added this driver so copy striver go to your Chrome just paste it Ctrl V Space download enter now the first side they've got my support go to go to archives you can see as this is the installer connector we don't need this I'm going to archives 8.0.3 version there is no windows I'm just going to type that form independent and then the second one 4.9 M download okay it's going to go showing folder now right click extract files I'm going to extract more files I'm just going to use uh let me document okay let's go and check um did modified or let's scroll down and here it is MySQL connector be in this chat now go to the clips and then go to your project right click build a path configure build path go to libraries modular plug click on modular path and you can go and external jar it was in my documents my SQL MySQL connector then open then apply enclosed now we are having a reference library jar bicycle connector now let's run known as Java application you can see connection created thank you

Channel: Ranko Junction

Views: 68,219

Keywords: #JDBC, #Connection, #mysql, #database, #eclipse, #connectivity, #jdbctutorial, education, learning, viral, technology, video, software, softwaredeveloper, programmer, programming, code, coding, easy, learn, java, spring, springtutorial, eclipse, create, file

Id: _WrEwxVBZ8M

Length: 8min 26sec (506 seconds)

Published: Thu Jun 08 2023