how to set placeholders in like statement query

Question

I am creating a PreparedStatement with SQL which have a like statement, and I am setting the placeholders using setString(), method, but it does not give any error or fetch any records. When I run the query direct at database by setting arguments in like statements then I get results, so I think there may be any other way to put place holders in sql, I am doing like below:

select name from employee where name like ?

I also tried:

select name from employee where name like (?)

and set parameters using setString() method but I did not get any results.

Please help what is wrong in it

See http://stackoverflow.com/questions/2857164/cannot-use-a-like-query-in-a-jdbc-prepared-statement — Zaki, Sep 29 '11 at 13:47

score 2 · Answer 1 · answered Sep 29 '11 at 13:41

2

this is an example from API:

PreparedStatement pstmt = con.prepareStatement("UPDATE EMPLOYEES
                                     SET SALARY = ? WHERE ID = ?");
   // set the first (?)
   pstmt.setBigDecimal(1, 153833.00)
   // set the second (?)
   pstmt.setInt(2, 110592)

you can see more in : http://download.oracle.com/javase/1.4.2/docs/api/java/sql/PreparedStatement.html

answered Sep 29 '11 at 13:41

rkmax

17,633
23
91
176

is it also same for like statement – agarwal_achhnera Sep 29 '11 at 13:48

score 1 · Accepted Answer · edited May 23 '17 at 12:17

1

It is the way by which you used it first. If you need another post which explains this, please see:

Cannot use a LIKE query in a JDBC PreparedStatement?

edited May 23 '17 at 12:17

Community

1
1

answered Sep 29 '11 at 14:27

James Jithin

10,183
5
36
51

how to set placeholders in like statement query

2 Answers2