본문 바로가기

TIP/SPRING

mapper.xml

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


'TIP > SPRING' 카테고리의 다른 글

web.xml(3.0)한글 처리 포함  (0) 2018.10.10
mybatis test 코드  (0) 2018.10.10
mysql db연결 테스트  (0) 2018.10.10
pom.xml 최종  (0) 2018.10.10
mybatis-config.xml  (0) 2018.10.10