TIP/SPRING

mapper.xml

devjjin 2018. 10. 10. 19:50

src/main/resources/mappers/memberMapper.xml


memberMapper.xml


1
2
3
4
5
6
7
8
9
10
11
12
<?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="memberMapper">
    <insert id="insertMember">
        INSERT INTO MEMBER(userId, userPw, userName, userEmail)
VALUES(#{userId},#{userPw},#{userName},#{userEmail})
    </insert>
</mapper>
 
cs
 cs



MemberDAOImpl


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
package kr.co.silver;
 
import javax.inject.Inject;
 
import org.apache.ibatis.session.SqlSession;
import org.springframework.stereotype.Repository;
 
@Repository // DAO라고 명시
public class MemberDAOImpl implements MemberDAO {
 
    
    @Inject    ///의존관계를 자동으로연결==@Autowired
    private SqlSession sqlSession;
    
    private static final String namespace= "memberMapper";
    
    @Override
    public void insertMember(MemberVO vo) {
        sqlSession.insert(namespace+".insertMember", vo);
             //mapper의 namespce.id 
    }
}
cs