user.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="User">

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

	<insert id="insertUser" parameterClass="User">
		insert into
		User1(uid,username,password)
		values
		(#uid#,#username#,#password#)
	</insert>

	<insert id="inserUserBySequence" parameterClass="User">
		<selectKey resultClass="int" keyProperty="uid">
			SELECT @@IDENTITY AS uid
		</selectKey>
		insert into
		User1(uid,username,password)
		values
		(#uid#,#username#,#password#)
	</insert>

	<select id="selectUserByName" parameterClass="String"
		resultClass="User">
		select uid,username,password
		from User1
		where username =
		#username#
	</select>

</sqlMap>