티스토리 뷰

Spring

Mybatis mapper.xml 예시

어니부뇽 2019. 7. 23. 10:34
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="Test">

	<resultMap type="com.spring.member.vo.MemberVo" id="memberMap">		 
		<result property="m_id" column="M_ID" javaType="string" />
		<result property="m_name" column="M_NAME" javaType="string" />
		<result property="m_pw" column="M_PW" javaType="string" />
		<result property="email" column="EMAIL" javaType="string" />
		<result property="login_cnt" column="LOGIN_CNT" javaType="int" />
	</resultMap>
	
	<select id="List" statementType="CALLABLE"
		parameterType="hashmap" resultType="com.spring.member.vo.MemberVo">
 		{ CALL PKG_MEMBERS.SELECT_MEMBERS(
 			#{ m_id, mode=IN, jdbcType=VARCHAR },
 			#{ m_name, mode=IN, jdbcType=VARCHAR },
 			#{ email, mode=IN, jdbcType=VARCHAR },
 			#{ result, 	mode=OUT, jdbcType=CURSOR, javaType=ResultSet,
			resultMap=memberMap }
 		)}
	</select>
	
</mapper>
댓글
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
링크
TAG
more
«   2025/07   »
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31
글 보관함