family.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="family" type="cn.kmp.accommodation.domain.Family"/>
	<!-- 鏍规嵁familyNum鏉ヨ幏寰梖amily -->
	<select id="getFamilyByFamilyNum" parameterClass="int" resultClass="family">
		SELECT *
		FROM family
		WHERE familyNum=#familyNum#
	</select>
	<!-- 鏍规嵁familyNum鏉ヨ幏寰梖amily -->
	
	<!-- 鏍规嵁瀛︾敓鍙疯幏寰梖amily -->
	<select id="getFamilyByStudentNum" parameterClass="int" resultClass="family">
		SELECT *
		FROM family
		WHERE studentNum=#studentNum#
	</select>
	<!-- 鏍规嵁瀛﹀彿鑾峰緱family -->
	
	<!-- 娣诲姞family-->
	<insert id="insertFamily" parameterClass="family">
		INSERT INTO family
		VALUES(#familyNum#,#studentNum#,#name#,#relationship#,#phoneNumber#,#street#,#city#,#postcode#)
	</insert>
	<!-- 娣诲姞family -->
	
	<!-- 鏍规嵁familyNum鍒犻櫎family -->
	<delete id="deleteFamilyByFamilyNum" parameterClass="int">
		DELETE FROM family
		WHERE familyNum=#familyNum#
	</delete>
	<!-- 鏍规嵁familyNum鍒犻櫎family -->
	
	<!-- 鏍规嵁studentNum鍒犻櫎family -->
	<delete id="deleteFamilyByStudentNum" parameterClass="int">
		DELETE FROM family
		WHERE studentNum=#studentNum#
	</delete>
	<!-- 鏍规嵁studentNum鍒犻櫎family -->
	
	<!--鏇存柊familyBYFamilyNum-->

	<update id="updateFamilyByFamilyNum" parameterClass="family">
		UPDATE family
		SET studentNum=#studentNum#,
		name=#name#,
		relationship=#relationship#,
		phoneNumber=#phoneNumber#,
		street=#street#,
		city=#city#,
		postcode=#postcode#
		WHERE familyNum=#familyNum#
	</update>
	<!-- 鏇存柊familyBYFamilyNum -->

	<!-- 鏇存柊familyBYstudentNum -->
	
	<update id="updateFamilyByStudentNum" parameterClass="int">
		UPDATE family
		SET familyNum=#familyNum#,
		name=#name#,
		relationship=#relationship#,
		phoneNumber=#phoneNumber#,
		street=#street#,
		city=#city#,
		postcode=#postcode#
		WHERE studentNum=#studentNum#
	</update>
	<!-- 鏇存柊familyBYstudentNum -->
</sqlMap>