xml文件:
#模糊查询匹配 <select id="getListTaskName" resultType="String"> SELECT TASK_NAME FROM TB_TASKID_HQL WHERE TASK_NAME LIKE '%${taskName}%' AND IS_DELETE = 0 </select>
#遍历一个列表中在数据库中共有几条记录 <select id="isTableIdExistence" parameterType="java.util.List" resultType="Integer"> SELECT COUNT(TASK_ID) FROM TB_TASKID_HQL <where> <if test="allTaskIds != null"> TASK_ID IN <foreach collection="allTaskIds" item="item" open="(" separator="," close=")"> #{item} </foreach> </if> AND IS_DELETE=0 </where> </select>
#删除指定id记录 <delete id="delectDagRecord"> DELETE FROM TB_DAG_INFO WHERE DAG_ID = #{dagId} </delete>
#往数据库插入一条数据 <insert id="insertDagRecord"> INSERT INTO TB_DAG_INFO (DAG_ID,DAG_NAME,DAG_CONTENT,DAG_TYPE) VALUES (#{dagId}, #{dagName}, #{dagContent}, #{dagType}) </insert>
#查询数据库中是否有此条记录 <select id="getDagIdCount" resultType="Integer"> SELECT COUNT(DAG_ID) FROM TB_DAG_INFO WHERE DAG_ID = #{dagId} </select>
筛选搜索,名字模糊匹配,附加其他条件 <select id="getDependenceTask" resultMap="TaskRecord"> SELECT * FROM TB_TASKID_HQL <if test="taskOwner != null and taskOwner !='' or taskType !=null and taskType !='' or taskName !=null and taskName !=''"> WHERE <if test="taskName !=null and taskName !=''"> TASK_NAME LIKE '%${taskName}%' AND </if> <if test="taskType !=null and taskType !=''"> TASK_TYPE = #{taskType} AND </if> <if test="taskOwner !=null and taskOwner !=''"> TASK_OWNER = #{taskOwner} AND </if> IS_DELETE = 0 </if> </select>
#筛选出数据库中状态不等于0和不等于1之外的多条数据【注意:不等号的表达】 <select id="getOtherDagIdList" resultType="String"> SELECT DAG_ID FROM TB_DAG_INFO WHERE DAG_STATUS <![CDATA[<>]]> 0 AND DAG_STATUS <![CDATA[<>]]> 1 OR DAG_STATUS = NULL AND IS_DELETE = 0 </select>
#更新数据库中的某些状态 <update id="upTableBasicPublish"> UPDATE TB_TABLE_BASIC SET PUBLISH = #{publish} WHERE ID = #{taskId} AND IS_DELETE = 0 </update>
java开发常用语法【xml文件】
最新推荐文章于 2021-12-26 20:53:20 发布