통계 & 데이터 그리고 이야기

com.ja.freeboard.mapper_MemberSQLMapper.java 본문

카테고리 없음

com.ja.freeboard.mapper_MemberSQLMapper.java

NoMadikia 2020. 5. 19. 15:14
728x90
반응형
SMALL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
package com.ja.freeboard.mapper;
 
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
 
import com.ja.freeboard.vo.MemberVo;
 
public interface MemberSQLMapper {
 
    @Select("SELECT FB_Member_seq.nextval FROM DUAL")
    public int createKey();
    
    @Insert("INSERT INTO FB_Member VALUES(#{member_no},#{member_id},#{member_pw},#{member_nick},#{member_sex},SYSDATE)")
    public void insert(MemberVo vo);
    
    @Select("SELECT * FROM FB_Member m, FB_member_auth a WHERE m.member_no = a.member_no AND m.member_id = #{member_id} AND m.member_pw = #{member_pw} AND a.auth_certification = 'Y'")
    public MemberVo selectByIdAndPw(MemberVo xxx);
    
    @Select("SELECT * FROM FB_Member WHERE member_no = #{no}")
    public MemberVo selectByNo(int no);
    
    @Select("SELECT * FROM FB_Member WHERE member_id = #{id}")
    public MemberVo selectById(String id);
    
}
 
 
 
 
 
 
 
cs
728x90
저작자표시 비영리 변경금지 (새창열림)
Comments