Operand should contain 1 column(s) in java [duplicate]

Question

String  sql = "SELECT (Employee_name, Password) FROM employee WHERE (Employee_name = '"+name+"'  AND Password = '"+password+"')";

and getting the following exception in JSP java.sql.sqlexception insert operand should contain 1 column(s)

Please help.

Answer 1

Correct way is

String  sql = "SELECT Employee_name, Password FROM employee WHERE Employee_name = '"+name+"'  AND Password = '"+password+"'";

You can keep () for where clause but not in select list. This is what happens in your case

mysql> select (firstname,email) from users limit 1 ;
ERROR 1241 (21000): Operand should contain 1 column(s)