java - Code throws SEVERE: No value specified for parameter 1 excetion -

i trying find list of items database throws exception. code , error following , field types correct.

code

     system.out.println("2");       try {            ps = con.preparestatement("select * users name = ?);"          resultset r = ps.executequery();         ps.setstring(1, "jack");         resultset result = ps.executequery();         ....         } catch (sqlexception e) {             system.err.println(e.getmessage());             system.out.println(e.getstacktrace());         } 

output

info: 2 severe: no value specified parameter 1 info: [ljava.lang.stacktraceelement;@6520c5b 

you're calling resultset r = ps.executequery(); before setting parameters on preparedstatement. typo when coding method since have similar line below setting parameters on preparedstatement.

ps = con.preparestatement(...); //comment line // resultset r = ps.executequery(); ps.setstring(1, "1"); //... resultset result = ps.executequery(); 

not directly related question, better if use logger instead of plain system.out.println calls in code. maintain code providing better messages logs.