INSERT INTO form_bo_def (id_, category_id_, category_name_, alias_, description_, support_db_, deployed_, status_, create_by_, create_time_, rev_) VALUES (#{id,jdbcType=VARCHAR}, #{categoryId,jdbcType=VARCHAR} , #{categoryName,jdbcType=VARCHAR},#{alias,jdbcType=VARCHAR}, #{description,jdbcType=VARCHAR}, CAST(#{supportDb} as integer) , CAST(#{deployed} as integer) , #{status,jdbcType=VARCHAR}, #{createBy,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, #{rev,jdbcType=NUMERIC}) SELECT * FROM form_bo_def WHERE id_=#{id} and REV_=#{rev} DELETE FROM form_bo_def WHERE alias_=#{alias} SELECT * FROM form_bo_def WHERE alias_=#{alias,jdbcType=VARCHAR} SELECT d.* from form_definition a,form_meta b ,form_bo_relation c,form_bo_def d where a.DEF_ID_=b.ID_ and b.ID_=c.FORM_ID_ and c.BO_DEF_ID_=d.ID_ and a.FORM_KEY_=#{formKey} and a.IS_MAIN_='Y' SELECT def.* from form_bo_def def LEFT JOIN form_bo_relation relation on def.ID_=relation.BO_DEF_ID_ where relation.form_id_=#{formId} SELECT DISTINCT form.id_,form.name_,form.form_type_,form.def_id_ FROM form_definition form INNER JOIN form_bo_relation rel ON form.DEF_ID_ = rel.FORM_ID_ WHERE rel.BO_DEF_ID_ = #{id} and form.is_main_='Y' SELECT fd.id_ as "id_", fd.name_ as "name_", fd.form_type_ as "form_type_", fd.def_id_ as "def_id_" FROM form_definition fd INNER JOIN form_bo_relation rel ON fd.DEF_ID_ = rel.FORM_ID_ WHERE rel.BO_DEF_ID_ = #{id} and fd.is_main_ = 'Y' SELECT DISTINCT def.id_ AS "defId",ent.id_ AS "id_",ent.name_ AS "name_" FROM form_bo_ent ent INNER JOIN form_bo_ent_relation rel ON rel.ref_ent_id_=ent.id_ INNER JOIN form_bo_def def ON def.id_=rel.bo_defid_ WHERE rel.bo_defid_=#{id} SELECT FORM_ID_ from form_bo_relation where BO_DEF_ID_ in #{item}