MemberMapper.xml > SPRING1

<?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>