<?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.guestbook">
<!-- 1.전체 검색 -->
<select id="select_all" resultType="org.joonzis.ex.GuestbookVO">
SELECT * FROM GUESTBOOK ORDER BY IDX DESC
</select>
<!-- 2.회원 추가 -->
<insert id="insert" parameterType="org.joonzis.ex.GuestbookVO">
insert into GUESTBOOK values(guestbook_seq.nextval, #{writer}, #{email}, #{pw}, #{filename}, #{title},#{content} ,sysdate)
</insert>
<!-- 한개의 데이터 검색-->
<select id="select_One" parameterType="int" resultType="org.joonzis.ex.GuestbookVO">
select * from GUESTBOOK where idx=#{idx}
</select>
<!-- 방명록 삭제 -->
<delete id="delete" parameterType="int">
DELETE FROM GUESTBOOK WHERE idx=#{idx}
</delete>
<!-- 방명록 수정 -->
<update id="update" parameterType="org.joonzis.ex.GuestbookVO">
update GUESTBOOK set email=#{email}, title=#{title}, content=#{content} where idx=#{idx}
</update>
</mapper>
