<?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>
