xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMap      

    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"      

    "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<!-- 

机能名: 基本设计 /外派信息

功能说明：员工外派信息一览>

式样书：基本设计_外派信息.xls

 -->

<sqlMap namespace="cn.com.mbp.hr.employee.OutSourcing.orm.OutSourcing">

 

<select id="findOutSourcing">

SELECT outsourcingid,employeeid, outtype, startdate,enddate,destination,deptno

from t_outsourcing

where employeeid=#value#

order by outsourcingid

</select>

 

</sqlMap>