(3) IUserMapper 인터페이스 와 UserMapper.xml 생성

 

# IUserMapper.java

package com.example.login.repository;
 
import java.util.List;
 
import org.apache.ibatis.annotations.Mapper;
 
import com.example.login.vo.UserVO;
 
@Mapper
public interface IUserMapper {
    
    //회원정보 등록
    void insert(UserVO vo);
    
    //아이디 중복확인
    int checkId(String id);
    
    //회원 탈퇴
    void delete(String id);
    
    //회원정보 조회
    UserVO getUser(String id);
    
    //회원정보 전체조회
    List<UserVO> getAllUser();
}
 

 

 

# UserMapper.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.example.login.repository.IUserMapper">
 
<resultMap id="UserMap" type="com.example.login.vo.UserVO">
    <result property="id" column="id"/>
    <result property="password" column="password"/>
    <result property="name" column="name"/>
    <result property="joinDate" column="join_date"/>
</resultMap>
 
 
    <insert id="insert">
        insert into login_user(id,password,name)
        values(#{id},#{password},#{name});
    </insert>
    
    <select id="checkId" resultType="int">
        select count(*)
        from login_user
        where id=#{id};
    </select>
    
    <delete id="delete">
        delete from login_user
        where id = #{id};
    </delete>
    
    <select id="getUser" resultMap="UserMap">
        select *
        from login_user
        where id=#{id};
    </select>
    
    <select id="getAllUser" resultMap="UserMap">
        select *
        from login_user
    </select>
    
    
</mapper>