MySQL Database connection in Java using Eclipse || Login page Example || English

[@khushalijiyani6397]

So easy and clear to understand. Loved it. Thanks 😊

[@SouravSingh-hu7ff]

i downloaded the jar file and pasted it in the place as show in the video. but the jar file is not visible in the jre system library. So i added the jar file with the help of build path->add external archieve. but it is showing error at String sql="select * from tblogin where Username='"+user.getText()+"' and Password='"+pass.getText().toString()"'";

[@poolcoder1337]

i have the same error

[@meghamakhija6293]

What should i do because there is no ext folder in my C:/programfiles/java/jdk 11.0.6/lib ??? Then where should i paste the mysql connector jar file???

[@traveller4043]

It was a great tutorial . Before JDBC was like hell.

[@sanjai9961]

Thank you for this video what I searched is exactly here

[@carvelbell181]

This is a very good tutorial. I like the way you explained things, very easy to understand. I am grateful for this video, excellent, and keep up the good work.

[@TechnicalBabaji1]

Thank you so much.. please like share and subscribe

[@imrana1719]

i'm using jdk is that jar file applicable for me?

[@LanceKey-rm3ll]

Where do i paste the connector when I do have java file in my program files?

[@wolontong]

where did you get that jar file, lebowski?

[@souvikroy7384]

i love you work ...thank you ....you dont know what satisfaction ou gave me before durga puja holidays

[@TechnicalBabaji1]

Thanku so much.. please share my video so that i can reach to more users

[@hirenprajapati4840]

i export as runnable jar file but there were not showing JOptionPane onclick login . I am using jre1.8.0_271 and jdk-15.0.1

[@sapnachaudhary5967]

At 4:27 when i click on Run it throws an error "Exception in thread "main" java.lang.Error: Unresolved compilation problem: Cannot instantiate the type Runnable" . can you please help me in this.

[@shijinbennyabraham7664]

Sir please help I am also facing the same issue

[@dharanisri2276]

I too got same issue

[@prathamkorade4618]

the mysql-connector.jar file is not showing in jre system lbrary

[@EyBossPusi]

Try to configure the build path

[@CleoxiNhA]

When I was creating JFrame (2:36) I got a big red X and the error beside it "Failed to create the part's controls". And when I clicked on details to see the error I got "java.lang.NullPointerException". What would it be?

[@TechnicalBabaji1]

You should have WindowsBuilder plugin in eclipse then it will work..

[@tanvigharte8823]

Sir, I m getting incorrect username and password message dialogye everytime even I m putting the correct username and password . Why should I do ?

[@abdishakur9]

You a genius my brother

[@hanssama3801]

how can u cross out getText() 8:15 which buttons do i need to click? Never did this and dont even know what i will do but well, how to do it?

[@viyyappan5491]

I am don't have jre folder....only have JDK folder..... where paste this jar file...bro...

[@shubhangiagarwal1714]

Does this work on eclipse neon3?? becoz i was not able to find jframe

[@TechnicalBabaji1]

U will not get even in oxygen.. you have to add form builder plugin then u will get this in any version of eclipse

[@TechnicalBabaji1]

Yes it will work on neon as well

[@shubhangiagarwal1714]

Thanku ....

[@nilesh9686]

This is very important when you are explaining downloaded java project in interview😂😂😂😂

[@anjanajoseph1941]

Thankyou.. it was awesome .. understands really well

[@TechnicalBabaji1]

Thank you so much..

[@ranomtech6463]

I don't Know If any one of you will get an error that com.mysql.jdbc.Driver is Deprecated. But If you do, then just replace com.mysql.jdbc.Driver with com.mysql.cj.jdbc.Driver. I use InteliJ IDEA and I got this Error. Hope this helps you.

[@gujaratfortunegiants8263]

tnx so much.. struggled for past 4 days.. now working.. tnx

[@nilniluzen7013]

i Saw ur video,but one thing I cannot understand, where you find "user.getText",in ur project you dont declare user as avariable or ,interface

[@TechnicalBabaji1]

user is the Object of EditText field I have shown lady in video watch care fully wait i will tell you the exact minute where I hv shown..

[@TechnicalBabaji1]

Watch from 4:10 I have set variable name user

[@sanjayanuwan42]

thanks a lot. you give me a new life

[@rashmin6560]

mine is is jdk12 where should i paste because ext dont exist in lib please do respond soon

[@TechnicalBabaji1]

In jdk 12 you have to import inside ide u can not add directly

[@rashmin6560]

@@TechnicalBabaji1 Thanks alot

[@saistachhipa3053]

i got an error com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'abcdand password is abcd' at line how can i solve this please reply !!!!!!!!!!!

[@TechnicalBabaji1]

You have done sql syntax error please see the sql syntax or you can share code with me I will tell you where you did the mistake.. Thank you

[@saistachhipa3053]

@@TechnicalBabaji1 ohk where can I send you the code ?

[@TechnicalBabaji1]

[e-mail] this is my mail id you can send here

[@saistachhipa3053]

@@TechnicalBabaji1 sure I will send the java code .

[@saistachhipa3053]

@@TechnicalBabaji1 I had send the file please check it out !!

[@mingxuanng9007]

Hi there. Thanks for creating this! I am currently using Eclipse for Enterprise and I can't seem to find the 'Windows Palette' tab. Is there any way which I can find it? Also, I would like users to login and be able to see a list of PDF files that is unique to their Username. Is that possible? Do I have to set up the database myself so that it extracts the right PDF files for each user using the app? Appreciate your assistance!

[@TechnicalBabaji1]

First you have to install plugin windowBuilder to get the window palette tab inside eclipse And for PDF that is also possible and there are many way to do the same thing.. you can create a table for mapping and you can store pdf in db as well as in folder

[@mingxuanng9007]

@@TechnicalBabaji1 Thanks for responding :) I guess I will have to create my own database to store the PDF files and then extract out the relevant ones according to each Username? Is that right? I keep getting this error message: "Access denied for user 'root'@'localhost' (using password: NO)" --> how can I solve this?

[@darkemperor4863]

why i follow your step why always appear message incorrect while my username and my password is correct please give a solution

[@najlaeddah2266]

i get the same error on and on , but i found out that it's for the password field only , and i don't know why , please if you figured out why tell me , thanks .

[@milosvojvodic6263]

how did you enter the 3 example user names and passwords @5:02 ?

[@TechnicalBabaji1]

First create a table then insert.. there is two way to insert the data into MySQL database 1 Insert query 2 phpmyadmin panel First way is used to insert data from application Second way is used when you want to insert data directly into database For the second way u have to click on insert tab of phpmyadmin then one form will appear through which you can insert data.. Thank you keep support us..

[@ruksarsayyed911]

hey i have eclipse oxygen .3a so i cant find jframe file by right clicking the src folder and the .jar file cant be added in the libraries folder is it because of the ver change .

[@TechnicalBabaji1]

You can't find even in Oxygen 2 that is a pluging you have to add in the eclipse

[@ruksarsayyed911]

Technical Babaji I dnt have the version of oxygen. 2 And i just followed ur steps but cant find jframe file and cant even load the.jar file

[@ruksarsayyed911]

Technical Babaji am using the march 18 eclipse oxygen. 3

[@TechnicalBabaji1]

No problem find the appropriate pluging and install in your eclips.. I have installed plugin in eclipses for designing purpose.. you can also do that go to settings and click on add plugin

[@ruksarsayyed911]

thanks for being so kind helping me...can give tutorials on spring rest api python languages too basic will be fine too ;)

[@onkardapake802]

Sir in my eclipse JFrame not found how to add JFrame? Please help

[@TechnicalBabaji1]

Please add plugin windowBuilder plugin in your eclipse

[@notevencloseml]

Very helpful and great tutorial ☺️thanks!!

[@rayaanrizwan947]

I dont have a JRE folder, what should i do?

[@mafiq1102]

where do i paste mysql-connector.jat file if i only have a jdk file?

[@TechnicalBabaji1]

You will not find jre folder from java 10 onwards please watch my latest video.. I have explained there how to do

[@piusonono1406]

​@@TechnicalBabaji1 Tell me about this video... I want to watch it....

[@piusonono1406]

​@@TechnicalBabaji1 where is the link to the latest video please??

[@taufiqueahemad925]

Bhai mera PC Windows10 par operate hota hai usme mysql disk top par nahi dikhrah nahi kahi aur please Bhai kuch suggestions do

[@TechnicalBabaji1]

First u have to install mysql server.. xampp install karlo sab ho jayega .

[@t2kumarashutosh2011]

Owsm vdo...helpful..ty boss

[@TechnicalBabaji1]

Most welcome.. Keep supporting us

[@bennychong1271]

Nice, you make the whole things easier

[@TechnicalBabaji1]

Thanks man..

[@vaishnavivenkat6947]

How did u set username and password for that newly created login page

[@Nikiya_sl]

1:11 what is the jre folder? i don't have it

[@ashfakmalek106]

muje ek app banana h kyaa aap ek video upload kar sakte h ke jisme app icon kese banaye and user id kese create kare like Name,birthdate....

[@TechnicalBabaji1]

Sure .

[@saichaitanya7277]

theme of your browser?

[@chalino228]

what do I must do if I want go to another Java page ?

[@NaveenKumar-zp4sy]

Nice one...

[@techxtreme7630]

Type of error = getText cannot be resolved or is not a field......... Pls help how solve this error

[@betosalavaco9964]

I need install a database server? If yes, how I'll make distribution?

[@TechnicalBabaji1]

Mysql oracle mongodb these are the famous database software... If u want to access database server from remote location then internet connection should be their with public ip private will not work.. and distributed database is a different concept.

[@betosalavaco9964]

@@TechnicalBabaji1 Yeah, now i can see. I'm looking for Embedded database. I can't understand why the people don't speak about them. You could make a video about them, h2, derby, sqlite... they ar too important. Thank you a lot for you awnser

[@TechnicalBabaji1]

My dear friend.. every database has is its own importance.. we can not compare with each other.. but the concept will be same.. Concept wise only two types of database.. schema less and schema full.. When we talk about embedded database like sqlite, It is also schema full database. Now a days every android app using their sqlite database so that they can access offline as well.. bdw thank you so much definitely I will make video on these database

[@betosalavaco9964]

@@TechnicalBabaji1 Yeah, you're right. Thank you!

[@betosalavaco9964]

@@TechnicalBabaji1 sorry for my words, my intent was make a sugestion really sorry

[@anita2053-r1f]

How to get design tab in eclipse? Can u please tellme!

[@TechnicalBabaji1]

Please add plugin windowBuilder then only you will be able to do that.. Please watch my latest video their I have shown how you can do that..

[@fabiocuartas7225]

remember to always close the Statement and the ResultSet as well

[@gireeshpitchuka]

its showing error at String sql="select * from tblogin where Username='"+user.getText()+"' and Password='"+pass.getText().toString()"'"; software is eclicpse juno

[@TechnicalBabaji1]

Please paste error message here

[@crazy_tolstoy]

Great video! Can you make video how to write some result of query into the textbox, or atleast post picture of code in comment? Thanks in advance :D

[@carolineshorts365]

I need help doing this. I’m getting errors

[@hareemsheikh7660]

Ho w your data base will come ?? i cant understand it?

[@TechnicalBabaji1]

Can you tell me the timing so that i can understand

[@karim-kc7yo]

Class.forName("com.mysql.jdbc.Driver"); not working ??

[@TechnicalBabaji1]

First you have to download this driver.. and paste in jre folder..

[@karim-kc7yo]

thank you , solved :)

[@TechnicalBabaji1]

Woow.. I am happy for u also keep share my vdo and subscribe my channel

[@VidishArvind]

ar 2:20 i don't have window builder option? what shall i do

[@TechnicalBabaji1]

This is a plugin you have to add in your ide

[@logavarshan]

Can you tell me what is the name of the song running in background?

[@rajd2919]

i dont have jframe....!!!! is there anyother options...????

[@TechnicalBabaji1]

You can design JFrame from coding as well watch this video it will really help you kzbin.info?o=U&video_id=Wga2DHPxvEA

[@RE-jc7br]

i solve ittttttttttttttttttttttt >> go to this link kzbin.info/www/bejne/pZbWqJmQr5l8jZI follow him for install jframe tool , good lock

[@christianvillanueva723]

hi i dont have JRE what should I do now

[@themiyalumia1383]

class.forName not found how to fix this error

[@rubyboby1084]

How insert a values to use this same techniques...

[@ashishranacs]

.getText() method doesn't show up in suggestions. only showing .getBytes()

[@warrenantes7635]

do you have a tutorial on connecting mysql to JavaFx??

[@TechnicalBabaji1]

Sorry not this time..

I did everything you showed but got "incorrect username or password" even when i typed the correct username and password

[@TechnicalBabaji1]

Here username ans password both are case sensitive

[@TechnicalBabaji1]

If u have still problem then send me database and code snapshot at [e-mail] I will check.

[@chiragpaliwal4961]

did you get the solution if yes please reply

[@mankeshpoonia9682]

I pasted my SQL connector in exe but it does not show my SQL jar in jre system library

[@TechnicalBabaji1]

Restart your ide it will appear..

[@nazlimehrazar8234]

You're the best

[@alliahmendez322]

When I put in the correct username and password its saying incorrect

[@shyqin5705]

hi, may i know where do you get this ? ("jdbc:mysql://localhost:3306/test","root","");

[@TechnicalBabaji1]

This is the syntax Test is my database name and root is my user name of mysql and password is blank by default root is user name of mysql database and password is blank

[@shyqin5705]

@@TechnicalBabaji1 okay but how about the number 3306 ? what the number mean ?

[@TechnicalBabaji1]

3306 is a port number of mysql database..

[@TechnicalBabaji1]

And thanku hope u will subscribe my channel.. and any query u can ask me any time

[@shyqin5705]

ok, thank you so much!@@TechnicalBabaji1

[@nikhilkumar4892]

php my admin site not working????? how to open that site

[@bibashpokhrel]

i am using ubuntu can you help me?

[@roywright8552]

jdk 11 no longer has a jre folder, where do we put the jar?

[@TechnicalBabaji1]

Yes u are write.. in jdk 11 we have to set path for jar file.. Thanku for asking this question

[@TechnicalBabaji1]

If u are using IDE then u can add by clicking on external library it will work...

[@JustinTheVlogger]

You did not explain on how to have a username and password in database.

[@bibashpokhrel]

How to setup in linux Please help me?

[@kushawahapraveen]

Sir how to make a address book by useing java in eclipse

[@anukulkumar219]

I dont have a jre folder in my JAVA

[@TechnicalBabaji1]

That has been removed from java 10 onwards so please watch watch my latest videos

[@CSEtutorials]

Hello. Sir.... I wana to contact u. I m also.... A online tutor for computer science.

[@TechnicalBabaji1]

Dear subscribers, We had gone through your comments and lots of requests for promoting your content on our channel. So, we decided to provide you with a great opportunity to promote your own content by collaborating with us. Nothing to worry it's absolutely free of cost! Don't miss this golden chance of collaboration in a channel of 18k subscriber holder! If you're Interested then directly mail here for more details [e-mail] Regards Technical Babaji kzbin.info/door/Kn7xwxBKZ_H1i6nilMsRQg

[@CSEtutorials]

@@TechnicalBabaji1 yeah... Check your mail...

[@patricksemilla4899]

the video was good but the sound are horrible Please don't use any auto tune

[@johnharoldrugay1024]

hi, i only have java 1.8.0_144, what should i do?

[@TechnicalBabaji1]

No problem u can do db connection

[@sbouribilel2772]

I'm so grateful men keep up

[@barsaranisahoo6675]

how to create database ...pls sir make one video ofthat

[@unclelizard5580]

More specifically, please show how to create one with PHPmyadmin, because I ran into this tutorial assuming I would be learning how to connect to a MySQL database that I created with the command line client.

[@sakenidenov362]

the link to the code is not working

[@manianusha9489]

does this work on eclipse java 2019-06

[@TechnicalBabaji1]

This was on java 8 if u r working on 10 then little bit changes required

[@khinhninmaw9913]

thank you for sharing knowledge sir!

[@TechnicalBabaji1]

Most welcome.. If you have any suggestions u can suggest me.. And also don't forget to share my video..

[@felipe6672]

Excelente me ha ayudado mucho

[@nehacs2010]

And connection please sir i have project submission on Monday please reply fast sir

[@minwun]

much thanks it worked

[@eonerizuwan]

What is the music used here?

[@LeviForWaifu]

A lit tutorial but the audio echo made me laugh

[@CallMe_Kurapika]

ty my bruda

[@rjlopez2682]

how you create tbllogin in testvplease tutorial

[@sahananayak7933]

How to make it full screen??

[@TechnicalBabaji1]

Simple click on maximum option on the runtime

[@arturavetisyan8672]

ist my error((( java.lang.ClassNotFoundException: com.mysql.jdbs.Driver

[@imreezan]

Hi! Don't get me wrong but I'm a beginner and I find you too fast in this video. Please go a little bit slow and avoid the annoying background music please. Thank you

[@geran99]

Thank you so much

[@TechnicalBabaji1]

Most welcome.. please subscribe my channel

[@nikhilkumar4892]

can you please tell me how can i make a table on phpmyadmin clearly

[@rohitkalkar8006]

You have an error in your SQL syntax ye error aa raha hai

[@nehalbaig7875]

I hope you will upload videos related to JavaFX and sql

[@TechnicalBabaji1]

Very soon.

[@nehalbaig7875]

i have been trying for 3 days , will you please help me , that which Sql and Sqlite workbench is easy to use?

[@TechnicalBabaji1]

Yes I m here to help u but in return I need ur support, subscribe my channel share and like my videos...

[@nehalbaig7875]

i have already done sir. Allah bless you too sir.

[@nehalbaig7875]

whenever i learn anything from the channel and its helpful, i try to hit a like button and subscribe too.

[@karlromero8861]

how can it be redirected after the login form to another frame?

[@TechnicalBabaji1]

If condition is satisfy then you can close this or hide this and you can load another frame..

[@karlromero8861]

Technical Babaji what code will i put after JOptionPane because if i put a code on it (else) is having error

[@TechnicalBabaji1]

Give me mail id i Will send code there

[@karlromero8861]

Technical Babaji [e-mail]

[@karlromero8861]

where is it?

[@utsavghosh95]

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database '3306/test' it is created in phpMyAdmin and my xampp is on.

[@TechnicalBabaji1]

You can see the error is syntax error. So u have to correct your syntax

[@utsavghosh95]

@@TechnicalBabaji1 There is more to it. I have checked the syntax and it is correct (same as your tutorial) yet I am unable to establish a connection with the database. Please help.

[@utsavghosh95]

@@TechnicalBabaji1 SELECT * FROM `tblogin`; UserName Password utsav utsgh upu upugh

[@TechnicalBabaji1]

@@utsavghosh95 send me your connection code in my Gmail [e-mail]

[@yasinekanowah]

What about mac os?

[@TechnicalBabaji1]

Sry man.. I m totally un aware of mac os.. I haven't use mac till now

[@yatheekshakotian6569]

Can i get source code pdf please..

[@carlknightcoph9494]

i cant find ext folder

[@TechnicalBabaji1]

That has been removed from java 10 onwards so please watch my latest videos

[@therealwwefan2316]

:face_palm: why are you giving out the sql data base information, say some one does this, they release their jar, all you have to do is open it with a decompiler and you have all their sql information you need, NOT GOOD