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

[@sanoshjacob115]

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

[@chaidarsaad8421]

thankyou sir you have done complete my project

[@jjangjjangman9698]

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

[@Alukardo11]

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

[@JyotiChavan-cf8sc]

aapko source code mila kya

[@nalakaweerakon5713]

Fantastic. Good job.thanx!

[@ashwaniyadav3661]

Thanks for this video

[@nptidurg]

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

[@thisaraharshana2168]

Thank you very much sir.

[@vaishnavikhedakar4619]

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

[@KARAOKEQUALITY]

thank you sir

[@OfficialMinor]

Thank you very much

[@Ghadah1]

Thank you !

[@enderj295]

Thanks Kuys))))

[@RecoverIman01]

Thanks Bro

[@hamidshiaikh3544]

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

[@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..

[@manojchandthaquree7821]

How to integrate it with login and signup page sir

[@Smirklaugh]

Thank You

[@fatima1795]

Thank u sir

[@UncleofGeorge]

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

[@RunCodes]

ouch!

[@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!

[@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.

[@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

[@safaeahmaddouch3454]

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

[@RunCodes]

Really?

[@DRealSmiley]

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

[@RunCodes]

that’s why we use it!

[@sumaiyar4047]

can you please tell the server you used?

[@RunCodes]

WAMP!

[@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.

[@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;

[@charleduardnarvaez4259]

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

[@RunCodes]

🤔

[@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

[@SanzayThapa]

padera vanex kya

[@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..??

[@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!

[@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

[@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?

[@adelmouhib7472]

thank you su much

[@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

[@sempakkadal1654]

Use XAMPP? is work ?

[@RunCodes]

sure

[@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
}

[@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.

[@houdabelabdoun4063]

And if i use two database?

[@RunCodes]

What do you mean?

[@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 )

[@uziee5911]

"else' without if error

[@RunCodes]

Check your code!

[@dilushajayanidu6305]

not working

[@Attee_Q]

No HD?

[@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.

[@RunCodes]

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

[@DimuthuJayanath]

Thanks Bro

[@tharinduwijayarathna]

Thank you very much