Mysql, select and java?

Question

MySQL

there is a request:

Boolean b;
statement.execute("SELECT LOGIN FROM testtable WHERE LOGIN='Admin'");

if the string "Admin" is in the table then the variable b becomes true otherwise false.
How to implement?

Answer 1

Boolean b = statement.executeQuery("SELECT EXISTS (SELECT * FROM testtable WHERE LOGIN='Admin' LIMIT 1)").getBoolean(1);