sql-member.xml > SPRINGBOOT

• 목록

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

<!-- parameterType 생략 가능 -->

<insert id="insertMember">

insert into t_member values (#{id},#{pass},#{name},#{email},#{phone},#{signdate},'1')

</insert>

<select id="selectMemberDetail" resultType="web.dto.MemberDto">

<![CDATA[

select * from t_member where id=#{id} and pass=#{pass}

]]>

</select>

<select id="sessionMemberDetail" resultType="web.dto.MemberDto">

<![CDATA[

select * from t_member where id=#{sessionid}

]]>

</select>

<update id="updateMember">

<![CDATA[

update t_member set 

pass = #{pass},

name = #{name},

email = #{email},

phone = #{phone} 

where 

id = #{id}

]]>

</update>

</mapper>