在spring中配置ibatis 03_xml配置

UserEntity.xml

 

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

	<resultMap id="result" class="com.iss.beans.UserBean">
	    <result property="userId" column="user_id"/>
		<result property="userName" column="user_name"/>
		<result property="password" column="user_password"/>
		<result property="age" column="age"/>
		<result property="birthday" column="birthday"/>
		<result property="registTime" column="regist_time"/>
	</resultMap>
	
	<resultMap id="result1" class="com.iss.beans.UserBean">
	    <result property="userId" column="user_id"/>
		<result property="userName" column="user_name"/>
	</resultMap>

	<!-- 添加用户 -->
	<insert id="insertUser">
		<![CDATA[
			INSERT INTO t_user(user_id,user_name,user_password,age,birthday,regist_time) 
			VALUES(#userId#,#userName#,#password#,#age#,#birthday#,#registTime#)
		]]>
	</insert>
	<!-- 查看特定用户 -->
	<select id="queryUserById" parameterClass="long" resultMap="result">
		<![CDATA[
			SELECT * FROM t_user WHERE user_id=#value#
		]]>
	</select>
	<select id="userCount" resultClass="int">
		<![CDATA[  
            SELECT count(user_id) FROM t_user   
        ]]>  
	</select>
	
	<update id="updateUser">
		update t_user  
		set user_name=#userName#,user_password=#password#,age=#age# 
		where user_id=#userId#
	</update>
	<delete id="deleteUser">
		delete from t_user where user_id=#userId#
	</delete>
	
	<parameterMap class="java.util.HashMap" id="loginMap">
		<parameter property="userName" javaType="java.lang.String" 
					jdbcType="VARCHAR" mode="IN"/>
					
		<parameter property="password" javaType="java.lang.String" 
					jdbcType="VARCHAR" mode="IN"/>
					
		<parameter property="FLAG" javaType="java.lang.Integer" 
					jdbcType="INTEGER" mode="OUT"/>
	</parameterMap>
	<!-- 调用存储过程 -->
	<procedure id="loginProcedure" parameterMap="loginMap" 
				resultClass="java.lang.Integer">
		{call proc_login(?,?,?)} 
	</procedure>
	
	<select id="queryAllUser1" resultMap="result1">
		select user_id,user_name from t_user
	</select>
	
</sqlMap>