mybatis oracle 语句

<sql id="Base_Column_List">
to_char(REPLAYTIME,'yyyy-MM-dd HH24:mi:ss'),  ......

</sql>

<!-- 添加  -->

<insert id="insert" parameterType="com.baidu.model.Demo">
insert into HB_ADVICE
<trim prefix="(" suffix=")" suffixOverrides=","> 
<if test="type != null">TYPE,</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=","> 
<if test="type != null">
#{type,jdbcType=DECIMAL},
</if>
</trim>
</insert>

<!-- 更新 -->
<update id="update" parameterType="com.baidu.model.Demo">
update Table
<set>
<if test="type != null"> 
TYPE = #{type,jdbcType=DECIMAL}, 
</if> 

 ....

</set>
where ID = #{id,jdbcType=DECIMAL}
</update>

<!-- 批量刪除 -->
<delete id="delete" parameterType="java.util.Map">
DELETE FROM Table WHERE ID IN
<foreach collection="ids" item="item" index="index" open="("
separator="," close=")">#{item,jdbcType=DECIMAL}</foreach>
</delete>

<!-- 单一刪除 -->
<delete id="deleteById" parameterType="java.lang.Long">
DELETE from Table
where ID = #{id,jdbcType=DECIMAL}
</delete>

<!-- 查询数据数 -->
<select id="queryByCount" resultType="java.lang.Integer"
parameterType="java.util.Map">
SELECT COUNT(1) FROM HB_ADVICE
<include refid="Page_Where_Clause" />
</select>
<!-- 单个查询 -->
<select id="queryById" resultMap="BaseResultMap" parameterType="java.lang.Long">
select
<include refid="Base_Column_List" />
from HB_ADVICE
where ID = #{id,jdbcType=DECIMAL}
</select>

<!-- 分页查询 -->
<select id="queryByPage" resultMap="BaseResultMap"
parameterType="java.util.Map">
SELECT
<include refid="page_list_Column" />
FROM table
WHERE ROWID IN (
SELECT rid FROM (
SELECT rid,
ROWNUM
AS rn
FROM (
SELECT ROWID
rid FROM HB_ADVICE
<include refid="Page_Where_Clause" />
<![CDATA[ 
ORDER BY ${orderby}
) t1 WHERE
ROWNUM<=#{endIndex,jdbcType=DECIMAL}
) t2 WHERE
rn>#{startIndex,jdbcType=DECIMAL}
)
]]>
ORDER BY ${orderby}
</select>

<!-- 分页查询条件 -->
<sql id="Page_Where_Clause">
<where>
<trim suffixOverrides="AND | OR" prefix="1=1">
<if test="title != null and title !='' ">
AND TITLE LIKE '%' || #{title,jdbcType=VARCHAR} || '%'
</if>
<if test="name != null and ename !='' ">
AND NAME = #{name,jdbcType=VARCHAR}  
</if>
<if test="type != null and type > 0 ">
AND TYPE = #{ype,jdbcType=DECIMAL}
</if>
<if test="flag != null and flag > 0 ">
AND FLAG = #{flag,jdbcType=DECIMAL}
</if>
<if test="deal != null and deal > 0 ">
AND DEAL = #{deal,jdbcType=DECIMAL}
</if>
<if test="begintime != null and begintime !='' ">
<![CDATA[
AND CREATETIME >= to_date(#{begintime,jdbcType=VARCHAR},'YYYY-MM-DD HH24:MI:SS')
]]>
</if>
<if test="endtime != null and endtime !='' ">
<![CDATA[
AND CREATETIME <= to_date(#{endtime,jdbcType=VARCHAR} || ' 23:59:59','YYYY-MM-DD HH24:MI:SS') 
]]>
</if>
</trim>
</where>
</sql>