ibatis - w3toppers.com

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

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 … Read more

Return HashMap in mybatis and use it as ModelAttribute in spring MVC

You want to get a Map<Integer,String> where the Integer is the id and the String is the name. If there were 200 categories in your table, you would want 200 entries in your map, rather than a list of 200 maps. MyBatis can’t quite do that out of the box, but you can use its … Read more

Hibernate, iBatis, Java EE or other Java ORM tool

Let me take a crack at this. First of, I’ve written some on this subject in Using an ORM or plain SQL?. Specifically to address your points: Learning Curve/Ease of Use Ibatis is about SQL. If you know SQL the learning curve for ibatis is trivial. Ibatis does some things on top of SQL such … Read more