selectOne, selectList

출처: http://stackoverflow.com/questions/6582034/ibatis-mybatis-select-dynamically-without-need-to-create-any-pojo-mapper

<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");