member.xml

<?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="org.joonzis.mybatis.mapper.member">

	<insert id="insert_join" parameterType="org.joonzis.vo.MVO">
		INSERT INTO MEMBER_T
		VALUES(
			member_seq.nextval,
			#{mid},
			#{mpw},
			#{mname},
			#{mtel},
			#{mage},
			sysdate
		)
	</insert>
	<select id="select_member_ck" parameterType="org.joonzis.vo.MVO" resultType="int">
		SELECT COUNT(*) FROM MEMBER_T WHERE MID=#{mid} AND MPW=#{mpw}
	</select>
	<select id="select_member" parameterType="org.joonzis.vo.MVO" resultType="org.joonzis.vo.MVO">
		SELECT * FROM MEMBER_T WHERE MID=#{mid} AND MPW=#{mpw}
	</select>
</mapper>