pass variable from java to SQL IN clause

Question

I have to format a string such that it can be sent to the IN clause of SQL. String s = ('A','B').This string s shud be passed from java to sql.How can this be done

You should know how to do it as you ask a lot of similar questions in the past. — FrVaBe
– FrVaBe, Commented Jan 18, 2011 at 8:32

Miserable Variable · Accepted Answer · 2011-01-18 08:33:08Z

2

I have come across this many times and to the best of my knowledge each element in the set needs to be a separate parameter:

String sql = "select * from customer where city in (?, ?, ?)";
PrepareStatement p = ..;
p.setString("Mumbai");
p.setString("Pune");
p.setString("Bangalore");
...

answered Jan 18, 2011 at 8:33

Miserable Variable

28.8k15 gold badges79 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hage · Accepted Answer · 2011-01-18 08:31:26Z

-1

Simply create the SQL statement and append the string to it

String sql = "SELECT a FROM table WHERE a IN "+s;

Now you can create a SQL Statement from this string. A better way may be to use prepared statements...

answered Jan 18, 2011 at 8:31

hage

6,1933 gold badges36 silver badges46 bronze badges

2 Comments

Tadeusz Kopec for Ukraine Over a year ago

Avoid creating queries with concatenation. It's dangerous. en.wikipedia.org/wiki/SQL_injection

Miserable Variable Over a year ago

PreparedStatements and IN clauses don't play together very well.

Collectives™ on Stack Overflow

pass variable from java to SQL IN clause

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related