Login for java not authenticating access for mysql database

Question

I've set up a gui that has a login interface and a database which stores usersnames and passwords, but when im trying to login on the gui its giving me invalid login even when i put in the exact data from my database.

if resultset return username/password, check the letters cases, because equals("string") is case sensitive function. — Harmeet Singh Taara
– Harmeet Singh Taara, Commented Oct 4, 2013 at 13:55

Siva · Accepted Answer · 2013-10-04 13:04:52Z

1

Change your Sql Statement as

select userName,password from person where userName = ? and password = ?

instead of

   select userName from person where userName = ? and password = ?

UPDATE

Infact you no need to check again username and password in java code, your query itself will tells you he/she is valid or not

answered Oct 4, 2013 at 13:04

Siva

1,9401 gold badge17 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Login for java not authenticating access for mysql database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related