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>

</mapper>