treetable怎么带参数_treetable 用法小例

SELECT id,deptName,deptDesc,parentId, parentName,parentIds,sorts

FROM sys_dept

where delFlag=0and deptName like concat('%',#{dept.deptName},'%')

and parentIds like concat('%',#{dept.parentIds},'%')ORDER BY

parentIds

INSERT INTO sys_dept (

id,

deptName,

deptDesc,

parentId,

parentName,

sorts,

deptCode,

parentIds

)

VALUES

(

#{id,jdbcType=VARCHAR},

#{deptName,jdbcType=VARCHAR},

#{deptDesc,jdbcType=VARCHAR},

#{parentId,jdbcType=VARCHAR},

#{parentName,jdbcType=VARCHAR},

#{sorts,jdbcType=TINYINT},

#{deptCode,jdbcType=VARCHAR},

#{parentIds,jdbcType=VARCHAR}

)

update sys_dept

set

deptName = #{deptName,jdbcType=VARCHAR},

deptDesc = #{deptDesc,jdbcType=VARCHAR},

parentId = #{parentId,jdbcType=VARCHAR},

parentName = #{parentName,jdbcType=VARCHAR},

parentIds = #{parentIds,jdbcType=VARCHAR},

sorts = #{sorts,jdbcType=TINYINT},

deptCode = #{deptCode,jdbcType=VARCHAR}

where id = #{id,jdbcType=VARCHAR}