takecourse.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="takeCourse" type="cn.kmp.accommodation.domain.TakeCourse"/>
	<typeAlias alias="student" type="cn.kmp.accommodation.domain.Student"/>
	<typeAlias alias="course" type="cn.kmp.accommodation.domain.Course"/>
	<typeAlias alias="hashmap" type="java.util.HashMap"/>
 	
	<select id="getStudentsByCourseNum" parameterClass="int" resultClass="student">
		SELECT s.*
		FROM takeCourse t,student s
		WHERE courseNum=#courseNum#
		AND s.studentNum=t.studentNum
	</select>
	
	<select id="getCoursesByStudentNum" parameterClass="int" resultClass="course">
		SELECT c.*
		FROM takeCourse t,course c
		WHERE studentNum=#studentNum#
		AND c.courseNum=t.courseNum
	</select>
	<select id="getTakeCourseByStudentNum" parameterClass="int" resultClass="takeCourse">
		SELECT *
		FROM takeCourse
		WHERE studentNum=#studentNum#
	</select>
	<insert id="insertTakeCourse" parameterClass="takeCourse">
		INSERT INTO takeCourse(	courseNum,
								studentNum,
								semester,
								schoolYear)
		VALUES( #courseNum#,
				#studentNum#,
				#semester#,
				#schoolYear#)
	</insert>
	<delete id="deleteTakeCourseByKey" parameterClass="hashmap">
	 DELETE FROM takeCourse
	 WHERE studentNum=#studentNum#
	 AND courseNum=#courseNum#
	 AND schoolYear=#schoolYear#
	 AND semester=#semester#
	</delete>
	<update id="updateTakeCourseByStudentNum" parameterClass="takeCourse">
		UPDATE takeCourse
		SET courseNum=#courseNum#,
			schoolYear=#schoolYear#,
			semester=#semester#
		WHERE studentNum=#studentNum#
	</update>

</sqlMap>