BoardAttachMapper.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.mapper.BoardAttachMapper">
	
	<insert id="insert" parameterType="org.joonzis.domain.BoardAttachVO">
		INSERT INTO tbl_attach(uuid, uploadPath, fileName, fileType, bno)
		VALUES(
			#{uuid},
			#{uploadPath},
			#{fileName},
			'',
			#{bno}
		)
	</insert>
	<delete id="delete">
	 	delete from tbl_attach where uuid=#{uuid}
	</delete>
	
	<select id="findByBno" resultType="org.joonzis.domain.BoardAttachVO">
			SELECT * FROM tbl_attach where bno=#{bno} 
	</select>
	<delete id="deleteAll">
		delete tbl_attach where bno=#{bno}
	</delete>
	
</mapper>