MemberMapper.xml > SPRING1

본문 바로가기

사이트 내 전체검색

뒤로가기 SPRING1

MemberMapper.xml

페이지 정보

작성자 관리자 작성일 24-08-06 09:05 조회 87 댓글 0

본문

<?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.pkt.mapper.MemberMapper">


<select id="idOk" resultType="int">

select count(*) from member where useremail = #{useremail}

</select>


<insert id="create">

insert into member (useremail, userpw, username, connecttype, emailresult, phone1, phone2, phone3, signdate, zipcode, zipcode1, zipcode2, zipcode3, zipcode4) 

values (#{useremail},#{userpw},#{username},#{connecttype},#{emailresult},#{phone1},#{phone2},#{phone3},now(),#{zipcode},#{zipcode1},#{zipcode2},#{zipcode3},#{zipcode4})

</insert>


</mapper>

댓글목록 0

등록된 댓글이 없습니다.


Copyright © dancePKT. All rights reserved.
PC 버전으로 보기