How to Create Multi User Login Form in java using MySQL Database ? [With Source Code]

Support us on Patreon: / runcodes
This video will show you how you can create multi user login form in java using MySQL database in NetBeans IDE.
Login form in java using MySQL database and NetBeans IDE: • How to Create a Login ...
Login form in java using SQL Server Database and NetBeans IDE: • How to Create Login Fo...
Download MySQL connector: dev.mysql.com/downloads/conne...
Source Code: runcodes.tech/programming/jav...
Login attempt form without database connectivity: • How to Create Login At...
Login attempt limit form using database connectivity: • How to Create Login At...
Create Simple Login Form in Java: • Create Simple Login Fo...
How To Insert Update Delete And Display Data In jTable [Part-2]: • Java And MySQL - How T...
How To Insert Update Delete And Display Data In jTable [Part-1]: • Java And MySQL - How T...
How to Show jTable Selected Row into jTextField in java: • How to Show jTable Sel...
How to Connect jComboBox with Database in java: • How to Connect jComboB...
login form in java using SQL Server and NetBeans IDE: • How to Create Login Fo...
Simple Login form in java using NetBeans IDE: • Create Simple Login Fo...
Send Free SMS using Java part-1[email-to-sms]: • How to Send Free SMS u...
Send Free SMS using Java part-2[email-to-sms]: • How to Send Free SMS u...
Send Free sms using java[SMS API]: • How to Send Free SMS F...
Follow us on Social Media:
Facebook: RunCodesPage
Instagram: runcodes
Twitter: RunCodesTwit
This video is created by Ran and RunCodes own this video. Using of this video on other channels without prior permission will be strictly prohibited. (Embedding to the websites is allowed).. So stop copying and be a responsible people.
#MultiUserLogin #MultiUserLoginJava #javaMultiUserLogin

[@tristisludos3985]

Yo thanks for the video mate, keep up the good work PogChamp

[@ProjectosAIChatbots]

I wish one day to find a video where the person goes straight to the point and not talking too much

[@chaidarsaad8421]

thankyou sir you have done complete my project

[@sanoshjacob115]

thank you very much broo.it help me with my mini project ;;

[@Alukardo11]

Thank you , this help me with my project. i work perfect

[@JyotiChavan-cf8sc]

aapko source code mila kya

[@nptidurg]

Hello Sir, If I want Multi-User Login form in Android Studio using MySQL, Then what to be done?

[@nalakaweerakon5713]

Fantastic. Good job.thanx!

[@jjangjjangman9698]

Thank you so muchhhh! Such a big help. Love yahh ~~

[@ashwaniyadav3661]

Thanks for this video

[@vaishnavikhedakar4619]

Error show could not find or load main class ecops.NewJFrame... How to resolve this error

[@thisaraharshana2168]

Thank you very much sir.

[@KARAOKEQUALITY]

thank you sir

[@bharatthapa9104]

hi there , I want the same feature without selecting user type in log in frame . user jst need to enter their id and password and our program should auto recognize the user type .. How could it be possible ? and thanks for the video..

[@OfficialMinor]

Thank you very much

[@manojchandthaquree7821]

How to integrate it with login and signup page sir

[@Ghadah1]

Thank you !

[@hamidshiaikh3544]

Where is the source code file in your blog I m not getting it I have find

[@RecoverIman01]

Thanks Bro

[@UncleofGeorge]

Dear brother can you help me on using the Java Sphinx library file to use it in my program?

[@RunCodes]

ouch!

[@Smirklaugh]

Thank You

[@vaishnavikhedakar4619]

Plz resolve my error sir , you have an error in your SQL syntax check the manual that corresponds to your MySQL server version for right syntax to use near "ecops" WHERE username='admin' and usertype='admin' at line १

[@RunCodes]

Check your sql query!

[@safaeahmaddouch3454]

what if we are working with JavaFX ? I couldn't matche this code with mine ! could you help me?

[@RunCodes]

Really?

[@fatima1795]

Thank u sir

[@ANSH-xm7ht]

if 2 different users log in they both are directed ti the same page wit same information. my question is how to store the value which was input by the user in the previous form and the new form remembers the value...

[@RunCodes]

stackoverflow.com/questions/9834915/how-to-pass-a-variable-value-from-one-jframe-to-another-jframe-in-netbeans this may help you!

[@makkimalik2594]

i have a Question and want to ask from u

[@ANSH-xm7ht]

@@RunCodes thankyou

[@enderj295]

Thanks Kuys))))

[@anginanyouth6840]

Good Day, is that possible to create multi login user without Combo box? the code can detect if the usertype is admin and it direct to admin jframe and when it is user, it will direct to user? without combobox?

[@RunCodes]

Possible, but its complicated!

[@anginanyouth6840]

@@RunCodes Thank you for a Response and I already made it now.

[@DRealSmiley]

is it required to have combo box to recognize the admin or user?

[@RunCodes]

that’s why we use it!

[@astiginko]

I have an error with DriverManager it says cannot find symbol please help. thanks

[@RunCodes]

write it correctly and import classes, import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet;

[@ADevGaming]

I run and i klick login and write out { parameter index out of range ( 1 > number of parameters, which is 0 )

[@RunCodes]

add value of combobox and see the code carefully.

[@sumaiyar4047]

can you please tell the server you used?

[@RunCodes]

WAMP!

[@resaseptiana755]

Error "AWT-EventQueue-0" java.lang.NullPointerException,,how to fix..??

[@RunCodes]

Check your button code!

[@resaseptiana755]

Ok it's worked,, But I want to add user type on combo button,, so what should I do for this case..??

[@vaishnavikhedakar4619]

How to resolve this error : No suitable driver found for jdbc:mysql://localhost/ecops

[@RunCodes]

add driver library on your library folder! I showed you, watch the full video!

[@motivator962]

It shows me you must configure either the server or JDBC driver

[@RunCodes]

Contact us on facebook!

[@motivator962]

@@RunCodes how

[@shanphofficial39]

why getText Cannot find symbol in my program ?

[@RunCodes]

Send screenshot at facebook.com/TechSupportNep

[@VincentJayBArana]

Me too

[@VincentJayBArana]

Does it have answer lready?

[@MrFred-vy9pi]

I Have a problem at 8:44 . The prepare Statement has an error, what would I do?

[@RunCodes]

Whats the error?

[@tom3704]

@@RunCodes i have an error on this line too, it shows: cannot find symbol symbol method: prepareStatement(String) location variable con of type Connection how can this error be resolved?

[@RunCodes]

PrepareStatement

[@samuelstephen6769]

?Have no idea what you are saying, sorry sir but no offence, I cannot follow your accent. But I know you provided a great tutorial for those who benefited! All the best to you.

[@charleduardnarvaez4259]

you have an error in your sql syntax check the manual that corresponds to your mariadb server version

[@RunCodes]

🤔

[@adelmouhib7472]

thank you su much

[@SanzayThapa]

padera vanex kya

[@chandrasekar-jd1se]

(String query=select *....username=? And password=? )Why ? Is used in code can you answer pls it's urgent

[@RunCodes]

? Is replace by pst.setString(1, yoirvariablename) first ? replace by 1 and so on!

[@SungSiao]

No suitable driver found for jdbc :(

[@RunCodes]

Add myqsl connector for java in your project libraries folder!

[@aishwaryabala3775]

@@RunCodes hi.. Even after adding.. It's like this

[@houdabelabdoun4063]

And if i use two database?

[@RunCodes]

What do you mean?

[@sanoshjacob115]

How to check user name and password if it had n users and passwords in the database

[@RunCodes]

use select query String username=txtUser.getText(); String password=txtPass.getText(); final String queryCheck = "SELECT count(*) from table-name WHERE username= ? and password=?"; final PreparedStatement ps = conn.prepareStatement(queryCheck); ps.setString(1, username); ps.setString(2, password); final ResultSet resultSet = ps.executeQuery(); if(!(resultSet.next())) { //do your things }

[@sempakkadal1654]

Use XAMPP? is work ?

[@RunCodes]

sure

[@RunCodes]

do you like our work? does this tutorial help you? if so, you can support us at www.patreon.com/RunCodes

[@ADevGaming]

whether DriverManager is also added to Java import ??

[@RunCodes]

watch video!

[@ADevGaming]

I run and i klick login and write out { parameter index out of range ( 1 > number of parameters, which is 0 )

[@Attee_Q]

No HD?

[@dilushajayanidu6305]

not working

[@uziee5911]

"else' without if error

[@RunCodes]

Check your code!

[@borgar4357]

this tutorial could be better only if you presented the necessary Library packages FIRST instead of explaining everything FIRST without saying the necessary packages and then only showing the necessary packages when the video is ending. you don't know how much headache and frustration you have done to me because I can't follow the video accordingly because I don't understand WHY can you import the SQL.* and you didn't show that you already added it to your project to begin with. but anyway, the tutorial was great and syntaxes are easy to understand, but wasn't stated the necessary items in the beginning of the video.

[@tharinduwijayarathna]

Thank you very much

[@DimuthuJayanath]

Thanks Bro