guestbook.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.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>