sql-reply.xml > SPRINGBOOT

• 목록

<?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="web.mapper.ReplyMapper">

<select id="replyList" resultType="web.dto.ReplyDto">

select * from t_reply where bno = #{bno} order by rno desc

</select>

<insert id="replyInsert">

insert into t_reply 

(bno,replytext,replyer) 

values 

(#{bno},#{replytext},#{replyer})

</insert>

<update id="replyUpdate">

update t_reply set replytext = #{replytext}, updatedate = now() where rno = #{rno}

</update>

<delete id="replyDelete">

delete from t_reply where rno = #{rno}

</delete>

<select id="listPage" resultType="web.dto.ReplyDto">

select * from t_reply where bno = #{bno} order by rno desc limit #{cri.pageStart}, #{cri.perPageNum}

</select>

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

select count(bno) from t_reply where bno =#{bno}

</select>

</mapper>