ibatis

<?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 namespace="detail">

	<typeAlias type="com.wykcw.model.ExamDetail" alias="ExamDetail"/>
	<typeAlias type="com.wykcw.model.Examination" alias="Examination"/>
 	<select id="queryByExam" parameterMap="ExaminationMap" resultClass="ExamDetail">
 		select detail_No,subject_No from t_exam_detail
 			where action_Type=1 and exam_No=(select exam_No from t_examination where practice_No=#practice_No# and user_No=#user_No#) LIMIT 1
 	</select>
 	
	 <update id="updateDeatilSelected" parameterClass="ExamDetail" >
	  	update t_exam_detail set selected=#selected#,action_Type=#action_Type# where detail_No=#detail_No#
	 </update>
</sqlMap>