[resources]user_query.xml

<sqlMap namespace="user">

<typeAlias alias="user" type="com.javadigital.ykheo.model.UserInfo" />

<select id="find_userinfo" parameterClass="user" resultClass="user">

select * from p_userinfo

where 1=1

<dynamic prepend="AND">

<isNotNull>user_id = #user_id#</isNotNull>

</dynamic>

<dynamic prepend="AND">

<isNotNull>user_name = #user_name#</isNotNull>

</dynamic>

</select>

<insert id="insert_userinfo" parameterClass="user">

insert into p_userinfo(user_id, user_pass, user_name, user_address, 

user_phone, user_email, user_sex, user_age)

values(#user_id#, #user_pass#, #user_name#, #user_address#, 

#user_phone#, #user_email#, #user_sex#, #user_age#)

</insert>

<update id="update_userinfo" parameterClass="user">

update p_userinfo set user_pass="#user_pass#", user_name="#user_name#", 

user_address="#user_address#", user_phone="#user_phone#",

user_email="#user_email#", user_sex="#user_sex#",user_age="#user_age#"

where user_id=#user_id#

</update>

<delete id="delete_userinfo" parameterClass="user">

delete p_userinfo where user_id=#user_id#

</delete>

</sqlMap>