Java array passed to SQL where clause
Posted on 2016-10-29
I have something like this:
ResultSet rs = stmt.executeQuery("SELECT lid, basistime, value FROM fcstheight WHERE lid = 'ASTF1' ORDER BY basistime");
I need to put pass in a Java Array (or, ArrayList?) for the WHERE clause. That array would have many lid's
Can something help me an with an example? Would I use a "IN" clause somehow?