티스토리 뷰
<?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>
'Spring' 카테고리의 다른 글
Interceptor를 사용한 로그인 처리 (0) | 2019.08.02 |
---|---|
Spring Mybatis Oracle 설정하기 (0) | 2019.07.23 |
Spring uft-8 encoding 설정 (web.xml) (0) | 2019.07.23 |
Spring 프로젝트 생성하기(Legacy X) (0) | 2019.07.17 |
댓글