iBatis Oracle

<?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="UserBean" type="com.wv1124.beans.UserBean" />

	<resultMap id="beanRet" class="UserBean">
		<result property="id" column="id" />
		<result property="name" column="name" />
		<result property="password" column="password" />
	</resultMap>
	
	<parameterMap class="UserBean" id="beanMap">
<!--		<parameter property="id" jdbcType="VARCHAR" nullValue=""/>-->
		<parameter property="name" jdbcType="VARCHAR" nullValue=""/>
		<parameter property="password" jdbcType="VARCHAR" nullValue=""/>
	</parameterMap>

	<select id="queryAll" resultMap="beanRet" parameterClass="string">
		select * from t_user where id = #id#
	</select>
	
	<insert id="insert" parameterMap="beanMap"><!-- seq_user.nextval -->
		insert into t_user(id, name, password) values(seq_user.nextval, ?, ?)
	</insert>
</sqlMap>