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

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

select * from tbl_member

</select>

<insert id="insert">

insert into tbl_member values (#{userid},#{userpw},#{username},#{email},now(),'1')

</insert>

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

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

</select>

<update id="update">

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

</update>

<delete id="delete">

delete from tbl_member where userid = #{userid}

</delete>

</mapper>