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..
?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.
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...
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 १
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 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?
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 }
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.
![How to Create Quiz Application in Java Using MySQL Database? [Part-2] [With Source Code]](http://i.ytimg.com/vi/NTMVo-5YymY/mqdefault.jpg)
![How to Create Quiz Application in Java Using MySQL Database? [Part-2] [With Source Code]](/img/tr.png)
![How to Create User Registration Form in java using MySQL Database? [With Source Code]](http://i.ytimg.com/vi/79QlZYPOLpw/mqdefault.jpg)
I wish one day to find a video where the person goes straight to the point and not talking too much
Yo thanks for the video mate, keep up the good work PogChamp
thankyou sir you have done complete my project
thank you very much broo.it help me with my mini project ;;
Thank you , this help me with my project. i work perfect
aapko source code mila kya
do you like our work?
does this tutorial help you?
if so, you can support us at www.patreon.com/RunCodes
Thank you so muchhhh! Such a big help. Love yahh ~~
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..
Where is the source code file in your blog I m not getting it I have find
How to integrate it with login and signup page sir
is it required to have combo box to recognize the admin or user?
that’s why we use it!
?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.
Thanks Kuys))))
Fantastic. Good job.thanx!
pst = con.prepareStatement(query); is error why?
Whats the error?
Thank you very much sir.
Thank you !
Hello Sir, If I want Multi-User Login form in Android Studio using MySQL, Then what to be done?
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...
stackoverflow.com/questions/9834915/how-to-pass-a-variable-value-from-one-jframe-to-another-jframe-in-netbeans this may help you!
i have a Question and want to ask from u
@@RunCodes thankyou
what if we are working with JavaFX ?
I couldn't matche this code with mine !
could you help me?
Really?
I run and i klick login and write out { parameter index out of range ( 1 > number of parameters, which is 0 )
add value of combobox and see the code carefully.
thank you sir
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 १
Check your sql query!
Thank you very much
Thanks for this video
you have an error in your sql syntax check the manual that corresponds to your mariadb server version
🤔
Thank You
Thanks Bro
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?
Possible, but its complicated!
@@RunCodes Thank you for a Response and I already made it now.
I Have a problem at 8:44 . The prepare Statement has an error, what would I do?
Whats the error?
@@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?
PrepareStatement
No suitable driver found for jdbc :(
Add myqsl connector for java in your project libraries folder!
@@RunCodes hi.. Even after adding.. It's like this
And if i use two database?
What do you mean?
why getText Cannot find symbol in my program ?
Send screenshot at facebook.com/TechSupportNep
Me too
Does it have answer lready?
I have an error with DriverManager it says cannot find symbol please help. thanks
write it correctly and import classes,
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
(String query=select *....username=? And password=? )Why ? Is used in code can you answer pls it's urgent
? Is replace by pst.setString(1, yoirvariablename) first ? replace by 1 and so on!
How to resolve this error : No suitable driver found for jdbc:mysql://localhost/ecops
add driver library on your library folder! I showed you, watch the full video!
Dear brother can you help me on using the Java Sphinx library file to use it in my program?
ouch!
How to check user name and password if it had n users and passwords in the database
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
}
Error "AWT-EventQueue-0" java.lang.NullPointerException,,how to fix..??
Check your button code!
Ok it's worked,, But I want to add user type on combo button,, so what should I do for this case..??
can you please tell the server you used?
WAMP!
It shows me you must configure either the server or JDBC driver
Contact us on facebook!
@@RunCodes how
whether DriverManager is also added to Java import ??
watch video!
I run and i klick login and write out { parameter index out of range ( 1 > number of parameters, which is 0 )
thank you su much
Use XAMPP? is work ?
sure
padera vanex kya
not working
"else' without if error
Check your code!
No HD?
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.
Error show could not find or load main class ecops.NewJFrame...
How to resolve this error
Thank you very much
Thank u sir
Thanks Bro