?
而在sqlmap中$是用来替换变量的
?
<?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="com.soft.dao">
?<typeAlias alias="user" type="com.soft.model.User"/>
?<resultMap? id="ResultMap" class="user">
??? <result column="id" property="id" jdbcType="VARCHAR"/>
??? <result column="username" property="userName" jdbcType="VARCHAR"/>
??? <result column="password" property="passWord" jdbcType="VARCHAR"/>
?</resultMap>
?
?? <!-- 查询方法 -->
? <select id="selectUserById" resultMap="ResultMap" parameterClass="String">
?? select id,username,userpassword from t_sys_user
?? where? id=#value#
? </select>
?
? <select id="selectUserByparam" resultMap="ResultMap" parameterClass="user">
???? select id,username,userpassword from t_sys_user
???? where 1=1
???? <isNotNull property="id" prepend="AND">
????????? id = #id:VARCHAR#
???? </isNotNull>
???? <isNotNull property="userName" prepend="AND">
???????? username = #userName:VARCHAR#
???? </isNotNull>
???? <isNotNull property="passWord" prepend="AND">
??????? password = #passWord:VARCHAR#
???? </isNotNull>
? </select>
????
?<!-- 插入方法 -->
?<insert id="inserUser" parameterClass="user">
??? insert into t_sys_user(id,username,password)
??? values(#id:VARCHAR#,#userName:VARCHAR#,#passWord:VARCHAR#)
?</insert>
?
?<!-- 删除方法 -->
?<delete id="deleteById" parameterClass="String">
???? delect from t_sys_user where id=#value#
?</delete>
?
??<!-- 修改方法 -->
?<update id="updatUserByparam" parameterClass="user">
??? update t_sys_user
??? <dynamic prepend="set">
??? <isNotNull prepend="," property="username">
?????? username = #username:VARCHAR#
??? </isNotNull>
??? <isNotNull prepend="," property="password">
?????? password= #password:VARCHAR#
??? </isNotNull>
??? </dynamic>
??? where id=#id:INTEGER#
?</update>
?
?<update id="updateUser" parameterClass="user">
???? update t_sys_user
??????? set
??????????? username = #username:VARCHAR#,
??????????? password = #password:VARCHAR#
???? where? id = #id:INTEGER#
?</update>
</sqlMap>