How to pass an Integer Array to IN clause in MyBatis

by

The myBatis User Guide on Dynamic SQL has an example on how to use a foreach loop to build the query string, which works for lists and arrays.

Prior to release 3.2 you had to use xml configuration to use dynamic sql, with newer versions it should also be possible to use dynamic sql in annotations.

<select id="selectPostIn" resultType="domain.blog.Post">
    SELECT *
    FROM POST P
    WHERE ID in
    <foreach item="item" index="index" collection="list"
             open="(" separator="," close=")">
        #{item}
    </foreach>
</select>

More Related Contents:

  1. Why is spawning threads in Java EE container discouraged?
  2. .war vs .ear file
  3. why business logic should be moved out of JSP?
  4. Where are compiled JSP Java (*__jsp.java) files?
  5. How to read request.getInputStream() multiple times
  6. Please explain about insertable=false and updatable=false in reference to the JPA @Column annotation
  7. @PreUpdate and @Prepersist in hibernate/JPA (using session)
  8. What are Shadow Variables in Java? [duplicate]
  9. How to convert map to url query string?
  10. Hibernate bidirectional @ManyToOne, updating the not owning side not working
  11. JPA map collection of Enums
  12. Get the server port number from tomcat without a request
  13. How to save state when extending UIComponentBase
  14. is there a standard way to define a JDBC Datasource for Java EE containers?
  15. Correct usage of Stateful Beans with Servlets
  16. Return HashMap in mybatis and use it as ModelAttribute in spring MVC
  17. Autowiring in Spring bean (@Component) created with new keyword
  18. Questions every good Java/Java EE Developer should be able to answer? [closed]
  19. Where can I find a list of all the reference implementations for Java EE 6? [closed]
  20. Difference between a “jta-datasource” and a ” resource-local ” datasource?
  21. Testing against Java EE 6 API
  22. What is meant by abstract=”true” in spring?
  23. no sqljdbc_auth in java.library.path
  24. How to store a file on a server(web container) through a Java EE web application?
  25. Java EE authentication: how to capture login event?
  26. Recommendations for java captcha libraries [closed]
  27. How can I manually load a Java session using a JSESSIONID?
  28. JAX-WS vs. JAX-RPC
  29. Which technologies does Tomcat support?
  30. Why do we use web.xml? [closed]

Leave a Comment