@@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?
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...
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..
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?
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 }
?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.
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
Thank you , this help me with my project. i work perfect
aapko source code mila kya
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
thankyou sir you have done complete my project
thank you very much broo.it help me with my mini project ;;
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
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
pst = con.prepareStatement(query); is error why?
Whats the error?
is it required to have combo box to recognize the admin or user?
that’s why we use it!
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
what if we are working with JavaFX ?
I couldn't matche this code with mine !
could you help me?
Really?
Hello Sir, If I want Multi-User Login form in Android Studio using MySQL, Then what to be done?
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.
why getText Cannot find symbol in my program ?
Send screenshot at facebook.com/TechSupportNep
Me too
Does it have answer lready?
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..
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!
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 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;
Thank you so muchhhh! Such a big help. Love yahh ~~
can you please tell the server you used?
WAMP!
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!
And if i use two database?
What do you mean?
Thank you very much sir.
Dear brother can you help me on using the Java Sphinx library file to use it in my program?
ouch!
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..??
It shows me you must configure either the server or JDBC driver
Contact us on facebook!
@@RunCodes how
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
}
(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!
?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.
Fantastic. Good job.thanx!
thank you sir
Use XAMPP? is work ?
sure
Thank you very much
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 )
Thanks for this video
Thank you !
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.
not working
padera vanex kya
Thanks Bro
Thank You
"else' without if error
Check your code!
Thanks Kuys))))
No HD?
thank you su much
do you like our work?
does this tutorial help you?
if so, you can support us at www.patreon.com/RunCodes
Error show could not find or load main class ecops.NewJFrame...
How to resolve this error
Thank you very much
Thanks Bro
Thank u sir