2011. 5. 31. 13:37
카테고리 없음
<?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="connector.project.mapper.LoginMapper">
<cache />
<select id="getIdAndPermission" parameterType="hashmap" resultType="org.apache.commons.collections.map.CaseInsensitiveMap" >
<![CDATA[
SELECT a.id as employee_id,b.permission_cd as permission
FROM employee a,executive b
WHERE 1=1 AND
a.employee_no = b.employee_no AND
a.id = #{id} and
a.password = #{pw}
]]>
</select>
</mapper>