[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();
}
}
반응형