오라클버전 P131 resources/mappers의 memberMapper.xml파일

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

<select id="getTime" resultType="string">
select sysdate from dual
</select>


<insert id="insertMember">

insert into tbl_member (userid, userpw, username, email)
values (#{userid}, #{userpw}, #{username}, #{email})

</insert>


</mapper>