I'm having a run-time error (exception) in my program, the specified exception is mentioned below:

Question

"com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'username' in 'where clause' ". the specified line of code is : String query = "select * from register_info where username='"+username+"' and password= '"+password+"'"; please help....

Answer 1

did you run the query from the rdbms command line ???? get that working first

if that works then you do in fact have the correct column name...

my next guess is that you have to escape the single quote character \'

String query = "select * from register_info where username = \'" + username + "\' and password = \'" +

password + \'";