MemberMapper.xml > SPRING1

• 목록

<?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="com.pkt.mapper.MemberMapper">

<insert id="create">

insert into tbl_member (userid, userpw, username, email, regdate) 

values (#{userid},#{userpw},#{username},#{email},now())

</insert>

<select id="login" resultType="com.pkt.model.MemberVO">

select * from tbl_member where userid = #{userid} and userpw = #{userpw}

</select>

<select id="read" resultType="com.pkt.model.MemberVO">

select * from tbl_member where userid = #{session_id}

</select>

<update id="update">

update tbl_member set userpw = #{userpw}, username = #{username}, email = #{email}  where userid = #{userid}

</update>

<select id="idOk" resultType="int">

select count(*) from tbl_member where userid = #{userid}

</select>

</mapper>