How to Iterate through HashMap in MyBatis foreach?

by

this is an example in my project and it works fine

<select id="getObject" parameterType="Map" resultType="hashmap">    
    select * from TABL where 
    <foreach  collection="dataMap"  index="key" item="value"  open=""  separator=" and "  close="">
        #{key}=#{value}
    </foreach>
</select>

More Related Contents:

  1. MyBatis Batch Insert/Update For Oracle
  2. MyBatis executing multiple sql statements in one go, is that possible?
  3. String variable in java to get and store the json array in table column
  4. Select fields from two tables with Speedment
  5. How do I get a result across 2 tables
  6. Why does the foreach statement not change the element value?
  7. How to call a stored procedure from Java and JPA
  8. right syntax to use near ‘?’
  9. Running a .sql script using MySQL with JDBC
  10. Prevent SQL injection attacks in a Java program
  11. Java Date – Insert into database
  12. Most efficient conversion of ResultSet to JSON?
  13. How can you call custom database functions with Hibernate?
  14. Last iteration of enhanced for loop in java
  15. LINQ for Java tool [closed]
  16. SQL prepared statement how to select via multiple possible menu selections?
  17. Class.forName(JDBC_DRIVER) no longer needed?
  18. Is there any good dynamic SQL builder library in Java? [closed]
  19. How can I detect a SQL table’s existence in Java?
  20. How to prevent SQL Injection with JPA and Hibernate?
  21. How does primitive array work with new for each loop in Java?
  22. Having a Column name as Input Parameter of a PreparedStatement
  23. Java – Storing SQL statements in an external file [closed]
  24. Can I have H2 autocreate a schema in an in-memory database?
  25. How to pass an Integer Array to IN clause in MyBatis
  26. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  27. Java JDBC connection status
  28. Is MERGE an atomic statement in SQL2008?
  29. Hibernate Issue : Foreign key must have same number of columns as referenced primary key
  30. Does JPA support mapping to sql views?

Leave a Comment