staff.xml.svn-base

数据库系统教材中附录的课程设计accomodation宿舍管理系统源码

<?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">
<sqlMap>
	<typeAlias alias="staff" type="cn.kmp.accommodation.domain.Staff"/>
	<typeAlias alias="hashmap" type="java.util.HashMap"/>
	
	<select id="getAllStaffs" resultClass="staff">
		SELECT *
		FROM staff
	</select>
	
	<select id="getStaffByStaffNum" parameterClass="int" resultClass="staff">
		SELECT *
		FROM staff
		WHERE staffNum=#staffNum#
	</select>
	
	<select id="getStaffsByName" parameterClass="hashmap" resultClass="staff">
		SELECT *
		FROM staff
		WHERE fname=#fname#
		AND lname=#lname#
	</select>
	
	<!-- 鑾峰彇鎵