place.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="place" type="cn.kmp.accommodation.domain.Place"/>
	<typeAlias alias="hashmap" type="java.util.HashMap"/>
	
	<select id="getPlaceById" parameterClass="hashmap" resultClass="place">
		SELECT *
		FROM place
		WHERE placeNum=#placeNum#
		AND departmentNum=#departmentNum#
		AND type=#type#
		AND roomNum=#roomNum#
	</select>
	
	<!-- 鏍规嵁monthrent鍗囧簭娲荤殑鎵