How to use an arraylist as a prepared statement parameter [duplicate]

by

You may want to use setArray method as mentioned in the javadoc below:

http://docs.oracle.com/javase/6/docs/api/java/sql/PreparedStatement.html#setArray(int, java.sql.Array)

Sample Code:

PreparedStatement pstmt = 
                conn.prepareStatement("select * from employee where id in (?)");
Array array = conn.createArrayOf("VARCHAR", new Object[]{"1", "2","3"});
pstmt.setArray(1, array);
ResultSet rs = pstmt.executeQuery();

More Related Contents:

  1. ArrayList with 2 dimensions [closed]
  2. How to avoid “ConcurrentModificationException” while removing elements from `ArrayList` while iterating it? [duplicate]
  3. Java: Insert multiple rows into MySQL with PreparedStatement
  4. How to create a Multidimensional ArrayList in Java?
  5. Java ArrayList – how can I tell if two lists are equal, order not mattering?
  6. list.clear() vs list = new ArrayList(); [duplicate]
  7. make arrayList.toArray() return more specific types
  8. List versus ArrayList as reference type?
  9. Distinction between the capacity of an array list and the size of an array
  10. Remove Item from ArrayList
  11. How to create an 2D ArrayList in java? [duplicate]
  12. In Java 8, why is the default capacity of ArrayList now zero?
  13. mysql prepared statement error: MySQLSyntaxErrorException
  14. Java ArrayList replace at specific index
  15. What is a List vs. an ArrayList? [duplicate]
  16. Remove objects from an ArrayList based on a given criteria
  17. Most efficient way to see if an ArrayList contains an object in Java
  18. Load arrayList data into JTable
  19. Using contains on an ArrayList with integer arrays
  20. ArrayList contains case sensitivity
  21. What is the Simplest Way to Reverse an ArrayList?
  22. PreparedStatements and performance
  23. Create an ArrayList with multiple object types?
  24. Java ArrayList Contain always return false although it contain the same value
  25. Sorting ArrayList of Objects by Object attribute
  26. Converting an ArrayList into a 2D Array
  27. Create an array of ArrayList elements
  28. ArrayList Generic without Type
  29. Iterate ArrayList in JSP
  30. Passing ArrayList of string arrays from one activity to another in android

Leave a Comment