student.xml

ibatis + sqlserver 学生成绩管理

<?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="Student">

	<typeAlias alias="Student" type="bean.Student" />

	<insert id="insertStudent" parameterClass="Student">
		insert into
		Student(sid, sname, sex, age, comment)
		values
		(#sid#,#sname#,#sex#,#age#,#comment#)
	</insert>

	<insert id="inserStudentBySequence" parameterClass="Student">
		<selectKey resultClass="int" keyProperty="sid">
			SELECT @@IDENTITY
			as sid 
		</selectKey>
		insert into
		Student(sid, sname, sex, age, comment)
		values
		(#sid#,#sname#,#sex#,#age#,#comment#)
	</insert>

	<delete id="deletStudentById" parameterClass="String">
		delete
		from Student
		where sid=#sid#
	</delete>

	<update id="updateStudentById" parameterClass="Student">
		update Student
		set
		sname=#sname#,
		sex=#sex#,
		comment=#comment#,
		age=#age#
		where sid=#sid#
	</update>

	<select id="selectAllStudents" resultClass="Student">
		select * from Student
	</select>

	<select id="selectAllStudentById" parameterClass="String"
		resultClass="Student">
		select sid,sname,sex,age,comment
		from Student
		where
		sid=#sid#
	</select>

	<select id="selectStudentByName" parameterClass="String"
		resultClass="Student">
		select sid,sname,sex,age,comment
		from Student
		where sname
		like '%$sname$%'
	</select>

</sqlMap>