Mapper interface + Mapper xml

1. BoardMapper 

package com.test.taewon.model.dao;
 
import java.util.List;
 
import org.apache.ibatis.annotations.Param;
 
import com.test.taewon.model.common.Pagination;
import com.test.taewon.model.dto.Board;
 
public interface BoardMapper {
 
    List<Board> selectAll(Pagination pagination);
    void insert(Board board);
    Board select(Board board);
    void delete(Board board);
    void update(Board board);
    void hit(int board);
    void reply(Board board);
    void replyShape(Board board);
//    List<Board> search(@Param("search") String search,@Param("type") String type);
    List<Board> search(@Param("search") String search,@Param("type") String type);
    
    int getBoardListCnt();
}
 

2. CommentMapper

package com.test.taewon.model.dao;
 
import java.util.List;
 
import com.test.taewon.model.dto.Comment;
 
public interface CommentMapper {
    void insert(Comment comment);
    List<Comment> selectAll(int comment);
    void delete(int comment);
}
 

 

1. BoardMapper 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="com.test.taewon.model.dao.BoardMapper">
    <select id="selectAll" resultType="board">
        select * from board 
        order by bGroup desc, bStep asc
        limit #{startList}, #{listSize}
    </select>
    
    <select id="getBoardListCnt" resultType="int">
        select count(*) listCnt 
        from board
    </select>
 
    <insert id="insert" parameterType="board">
        insert into board (bUsername, bTitle, bContent, bDate, bHit, bGroup, bIndent, bStep)
        values (#{bUsername}, #{bTitle}, #{bContent}, now(), 0, 
            (select max(boardId)+1 from board bo), 0, 0)
    </insert>
    
    <select id="select" parameterType="board" resultType="Board">
        select * from board 
        where boardId = #{boardId}
    </select>
    <update id="update" parameterType="board">
        update board
        set bTitle = #{bTitle}, bContent = #{bContent}
        where boardId = #{boardId}
    </update>
    <delete id="delete" parameterType="board">
        delete from board
        where boardId = #{boardId}
    </delete>
    
    <update id="hit" parameterType="int">
        update board
        set bHit = bHit +1
        where boardId = #{boardId}
    </update>
    
    <insert id="reply" parameterType="board">
        insert into board(bUsername, bTitle, bContent, bDate, bHit, bGroup, bIndent, bStep)
        values(#{bUsername}, #{bTitle}, #{bContent}, now(), 0, #{bGroup}, #{bIndent} + 1, #{bStep} +1)
    </insert>
    
    <update id="replyShape" parameterType="board">
        update board 
        set bStep = #{bStep} + 1
        where bGroup = #{bGroup} and bStep > #{bStep}
    </update>
    
    <select id="search" parameterType="map" resultType="board">
<!--     <bind name="result" value="'%' + #{search} + '%'"/> -->
        select * from board
        <trim prefix="where" prefixOverrides="and|or">
            <if test="type==btitle">
                and btitle like concat('%',#{search},'%')
            </if>
            <if test="type==bcontent">
                and bcontent like concat('%',#{search},'%')
            </if>
        </trim>
<!--         where #{type} like concat('%',#{search},'%') -->
<!--         select("*"); -->
<!--         from("board"); -->
<!--         where("#{type} like '%' #{search} '%'"); -->
        
    </select>
</mapper>

3. MemberMapper 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="com.test.taewon.model.dao.MemberMapper">
    
    <select id="checkMember" parameterType="Boardmember" resultType="Boardmember">
        select * from Boardmember
        where username = #{username} and password = #{password}
    </select>
    
    <insert id="registerMember" parameterType="Boardmember">
        insert into boardmember (username, password, email, gender, birthday, joinDate)
        values (#{username}, #{password}, #{email}, #{gender}, #{birthday}, now())
    </insert>
</mapper>