상세 컨텐츠

본문 제목

자바 Spring selectList, selectOne

IT분야 (IT sector)

by Sherlockhomes 2015. 2. 27. 17:32

본문

728x90
반응형



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

728x90

관련글 더보기