mapper.xml文件的sql

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"mybatis-3-mapper.dtd">
<mapper namespace="dao.IentryDAO">
<resultMap type="entry" id="stuMap">
<id column="EDOC_ENTRY_ID" property="edoc_entry_id" />
<result column="TITLE" property="title" />
<result column="CATEGORYID" property="category_Id" />
<result column="SUMMARY" property="summary" />
<result column="UPLOADUSER" property="uploaduser" />
<result column="CREATEDATE" property="createdate" />
<result column="CREATPRGNM" property="cretprgnm" />
<result column="BOOK_FALG" property="book_falg" />
<result column="UP_DATE" property="update" />
<result column="UP_PRGNM" property="up_prgnm" />
<result column="LOAN_COUN" property="loan_count" />
</resultMap>
<resultMap type="dao.IcategoryDAO" id="category">
<id column="CATEGORY_ID" property="id" />
<result column="CATEGORY_NAME" property="name" />
<result column="CATEGORY_CODE" property="" />
</resultMap>
<!--添加 并生成自增ID -->
<insert id="addbook" parameterType="entry" useGeneratedKeys="true">
<selectKey keyProperty="EDOC_ENTRY_ID" resultType="java.lang.String" order="BEFORE">
SELECT substr('00000000' || SEQUENCE.NEXTVAL,-8) FROM DUAL
</selectKey>
INSERT INTO
EDOC_ENTRY(EDOC_ENTRY_ID,CATEGORYID,TITLE,SUMMARY,UPLOADUSER,CREATEDATE,CREATPRGNM,BOOK_FALG,UP_DATE,UP_PRGNM,LOAN_COUN)
VALUES(#{EDOC_ENTRY_ID},#{stu.category_Id},#{stu.title},#{stu.summary},#{stu.uploaduser},#{stu.createdate},#{stu.cretprgnm},#{stu.book_falg},#{stu.update},#{stu.up_prgnm},#{stu.loan_count})
</insert>
<!-- 修改 -->
<update id="update">
UPDATE EDOC_ENTRY SET
CATEGORYID=#{stu.category_Id},TITLE=#{stu.title},SUMMARY=#{stu.summary},UPLOADUSER=#{stu.uploaduser},BOOK_FALG=#{stu.book_falg},UP_DATE=#{stu.update},UP_PRGNM=#{stu.up_prgnm}
where EDOC_ENTRY_ID=#{stu.edoc_entry_id}
</update>
<!--删除 -->
<delete id="delete">
DELETE FROM EDOC_ENTRY WHERE EDOC_ENTRY_ID=#{edoc_entry_id}
</delete>
<!--状态 修改 -->
<update id="startStop">
UPDATE EDOC_ENTRY SET
BOOK_FALG=#{stu.book_falg},UP_DATE=#{stu.update},UP_PRGNM=#{stu.up_prgnm},LOAN_COUN=#{stu.loan_count}
where EDOC_ENTRY_ID=#{stu.edoc_entry_id}
</update>
<!--根据id查询实体 -->
<select id="findById" resultMap="stuMap">
SELECT EDOC_ENTRY_ID,CATEGORYID,TITLE,SUMMARY,UPLOADUSER,BOOK_FALG,LOAN_COUN FROM ENTRY_CATEGORY WHERE 1=1
<if test="edoc_entry_id!=null and edoc_entry_id!=''">
AND EDOC_ENTRY_ID=#{edoc_entry_id}
</if>
</select>
<!--联想 -->
<select id="getbookList" resultMap="stuMap">
SELECT DISTINCT TITLE FROM ENTRY_CATEGORY WHERE CATEGORY_CODE='XIANDAI'
<if test="title!=null and title!=''" >
AND TITLE LIKE '%'||#{title}||'%'
<!-- AND TITLE LIKE CONCAT(CONCAT('%',#{title}),'%') -->
</if>
</select>
<!--下拉列表 唐-->
<select id="findSql" resultMap="stuMap">
SELECT DISTINCT CATEGORY_ID, CATEGORY_NAME FROM EDOC_CATEGORY WHERE CATEGORY_CODE='XIANDAI'
order by CATEGORY_ID DESC
</select>
<!-- 分页查询一览列表 唐 -->
<select id="queryByPage" resultMap="stuMap,category" >
SELECT EDOC_ENTRY_ID,TITLE,SUMMARY,UPLOADUSER,CATEGORY_NAME,BOOK_FALG,LOAN_COUN FROM ENTRY_CATEGORY WHERE CATEGORY_CODE='XIANDAI'
<if test="stu.title!=null and stu.title!=''" >
<!-- AND TITLE LIKE '%'||#{stu.title}||'%' -->
AND TITLE LIKE CONCAT(CONCAT('%',#{stu.title}),'%')
</if>
order by EDOC_ENTRY_ID DESC
</select>

</mapper>