[IT]/Spring

Spring.MyBatis.DB.Map

givemebro 2021. 5. 27. 11:37
반응형
	<select id="findMemberMapById" resultType="map"
		parameterType="string">
		<include refid="selectMember" />
		where id=#{value}
	</select>
	@Override
	public Map<String,String> findMemberMapById(String id) {
		return template.selectOne("member.findMemberMapById", id);
	}
package test;

import java.util.Map;
import org.kosta.model.MemberDAO;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class TestMyBatis {
	public static void main(String[] args) {
		ClassPathXmlApplicationContext ctx = new ClassPathXmlApplicationContext("spring-config.xml");
		MemberDAO dao = (MemberDAO) ctx.getBean("MemberDAO");
		Map<String, String> map = dao.findMemberMapById("java");
		// MyBatis에서 Map으로 반환할 때는 Key값이 대문
		System.out.println(map.get("ID"));
		System.out.println(map.get("PASSWORD"));
		System.out.println(map.get("NAME"));
		System.out.println(map.get("ADDRESS"));

		ctx.close();
	}
}
반응형