How to use Annotations with iBatis (myBatis) for an IN query?

by

I believe the answer is the same as is given in this question. You can use myBatis Dynamic SQL in your annotations by doing the following:

@Select({"<script>",
         "SELECT *", 
         "FROM blog",
         "WHERE id IN", 
           "<foreach item='item' index='index' collection='list'",
             "open='(' separator="," close=")">",
             "#{item}",
           "</foreach>",
         "</script>"}) 
List<Blog> selectBlogs(@Param("list") int[] ids);

The <script> element enables dynamic SQL parsing and execution for the annotation. It must be very first content of the query string. Nothing must be in front of it, not even white space.

Note that the variables that you can use in the various XML script tags follow the same naming conventions as regular queries, so if you want to refer to your method arguments using names other than “param1”, “param2”, etc… you need to prefix each argument with an @Param annotation.

More Related Contents:

  1. Return HashMap in mybatis and use it as ModelAttribute in spring MVC
  2. Which @NotNull Java annotation should I use?
  3. Does Spring @Transactional attribute work on a private method?
  4. How to supply value to an annotation from a Constant java
  5. Hibernate Annotations – Which is better, field or property access?
  6. Why is it not possible to extend annotations in Java?
  7. @Resource vs @Autowired
  8. How to inject a Map using the @Value Spring Annotation?
  9. Why does JPA have a @Transient annotation?
  10. How to map JSON field names to different object field names?
  11. hibernate column name issues
  12. annotation to make a private method public only for test classes [duplicate]
  13. @Transactional(propagation=Propagation.REQUIRED)
  14. How do Java method annotations work in conjunction with method overriding?
  15. Hibernate, iBatis, Java EE or other Java ORM tool
  16. How do annotations like @Override work internally in Java?
  17. How to use Hibernate @Any-related annotations?
  18. Spring annotation-based DI vs xml configuration?
  19. Create Annotation instance with defaults, in Java
  20. How to Iterate through HashMap in MyBatis foreach?
  21. Setting a JPA timestamp column to be generated by the database?
  22. Android Retrofit Parameterized @Headers
  23. RetentionPolicy CLASS vs. RUNTIME
  24. Passing dynamic parameters to an annotation?
  25. Hibernate mapping between PostgreSQL enum and Java enum
  26. how to make a composite primary key (java persistence annotation)
  27. How to write a Java annotation processor?
  28. Java Annotations
  29. How to use an array constant in an annotation
  30. How to disable TestNG test based on a condition

Leave a Comment