-3
I am validating the login of a simple system but giving an error does not login I will send you the code of the class and the moment I try to log in.
Lojabd class that validates the user
class that does the login test
error that this generating.
updated error
1
The error already says it all. You can’t make one run SELECT in a executeUpdate. Use a executeQueryin this case. Change your code to:
String query = "SELECT * FROM userloja WHERE email = ? AND senha = ?";
PreparedStatement ps = conectarMysql().prepareStatement(query);
ps.setString(1, loja.getEmail());
ps.setString(2, loja.getSenha());
ResultSet rs = ps.executeQuery();
return rs.isBeforeFirst();
Executes the SQL query in this Preparedstatement Object and Returns the Resultset Object generated by the query.
In free translation:
Executes the SQL query in the Preparedstatement object and returns a Resultset object generated by this query.
take a look at the answer I gave in my own question
still giving error in Return
it does not identify the resultset Return.isBeforeFirst(); the lapada is asking to create a resultset class
I’ve done it and it didn’t work, same mistake
have any way to contact Voce? facebook, wpp, skype sla
sera pq is a bool method?
my comrade I’ve already put the ; never forget to put
I put the print of the question
vlw that I did not know, obg for the help and sorry for the work I gave
0
The problem is that you are not using JDBC correctly. You should use executeQuery instead of executeUpdate to perform Selects.
ResultSet rs = alterar.executeQuery(query);
Here is a more detailed example of how it should be done.
Browser other questions tagged java mysql sql database login
You are not signed in. Login or sign up in order to post.
Please do not post code as image and do the [tour].
– danieltakeshi