myBatis的增删改查以及动态查询

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">


<mapper namespace="dao.IUserDao">
<select id="countAll" resultType="int">
<!-- 这里的SQL结尾不能加分号，否则报"ORA-00911错误" -->
  SELECT count(*) FROM users
</select>  
<select id="queryByUserId"   parameterType="Integer" resultType="entity.User">
<!-- 这里的SQL结尾不能加分号，否则报"ORA-00911错误" -->
  SELECT * FROM users where id=#{id}
</select>

<insert id="addUser" parameterType="entity.User">
<selectKey keyProperty="id" resultType="int" order="BEFORE">
select seq_userId.nextval from dual
</selectKey>
insert  into users(id,name,password)
values(#{id},#{name},#{passWord})
</insert>
<update id="upterUser" parameterType="entity.User">
update users
<set>
<if test="name!=null">
name=#{name},
</if>
<if test="passWord>0">
password=#{passWord},
</if>
</set>
where id=#{id}
</update>
<select id="queryUserIf"   parameterType="entity.User" resultType="entity.User">
<!-- 这里的SQL结尾不能加分号，否则报"ORA-00911错误" -->
  select * from users  
  <where>
  <if test="id>0">
  and id=#{id}
  </if>
  <if test="name!=null">
  and name=#{name}
  </if>
  <if test="passWord!=null">
  and password=#{passWord}
  </if>
 
  </where>
 

</select>

<delete d="countAll" resultType="int">
delete  users whrer id=1；
</delete>

 </mapper>