Ibatis/MyBatis select dynamically without need to create any Pojo / Mapper

ibatis mybatis
Rudy picture Rudy · Jul 5, 2011 · Viewed 14.9k times · Source

Is there any way to select/update/delete dynamically using Ibatis/MyBatis?

When I say "dynamically" it means I don't want to create any POJO/DataMapper at all.

Any URL example would be welcomed.

Answer

AngerClown picture AngerClown · Jul 5, 2011

Yes, just set the resultType attribute to map and the table data will be placed into a HashMap of column names to values. If the query returns more than 1 row, the mapped rows will be put into a List. If you want to select a single column, you can get just that value (as String, int, etc) or as a list.

<select id="test1" resultType="map">select * from user</select>
<select id="test2" resultType="map" parameterType="int">
  select * from user where id=#{value}</select>
<select id="test3" resultType="string">select name from user</select>
...
// returns a list of maps
List test = sqlSession.selectList("test1");

// returns a single map
Object map = sqlSession.selectOne("test2", 0);

// returns a list of strings
List names = sqlSession.selectList("test3");

This applies to MyBatis 3; I think you can do something similar in iBatis 2.

Related questions

mybatis IllegalArgumentException: Mapped Statements collection does not contain value

i have many problem with spring e mybatis. This is my spring configuration: i have the same configuration and ComuneMapper.java and ComuneMapper.xml stay in the same folders. but i have however this error Somebody to help meeeee <?…

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

I want to display list of categories in my Jsp page using spring mvc @modelAttribute. In my mapper.xml file is <select id="selectAllCategories" resultMap="BaseResultMap"> select id, name from categories </select> In my Mapper.java …

Read More
Log SQL queries in project using MyBatis and Spring

In my project i have <bean id="ABCSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="ABCDataSource" /> <property name="mapperLocations"> <list> <value>classpath:com/myco/dao/XYZMapper.xml</…

Read More