블로그 이미지

calendar

1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30
  • total
  • today
  • yesterday
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>

posted by 천상의날개