mybatis动态sql语句

方法传过来的是list参数，list里面是对象

void save(List<DepartmentCustom> department);

<insert id="save" parameterType="java.util.List">
    
      insert into tb_department (enterprise_uid, name, 
      parent_id, description) values
      <if test="list!=null">
		<foreach collection="list" item="item" separator="," >
		    (#{item.enterpriseUid},#{item.name},#{item.parentId},#{item.description})
		</foreach>
	  </if> 
  </insert>

自关联查询

<!-- 针对菜单的父子关系，定义的树状结构ResultMap  -->  
   <resultMap  id="menuResultMap"  type="com.awcloud.user.pojo.custom.MenuCustom">    
        <id column="id" property="id" jdbcType="BIGINT" />  
        <result column="name" property="name" jdbcType="VARCHAR" />  
        <result column="menu_code" property="menuCode" jdbcType="VARCHAR" />  
        <result column="parent_id" property="parentId" jdbcType="BIGINT" />  
        <result column="url" property="url" jdbcType="VARCHAR" />  
        <result column="order" property="order" jdbcType="INTEGER" />  
        <result column="type" property="type" jdbcType="INTEGER" />  
        <result column="icon" property="icon" jdbcType="VARCHAR" />  
        <result column="description" property="description" jdbcType="VARCHAR" />  
        <result column="enabled" property="enabled" jdbcType="BIT" />  
            
            
        <!-- 查询子菜单 -->    
        <collection property="children" column="id" select="getChildrenMenus" />    
            
    </resultMap>    
        
  
       <!-- 查询特定menu的所有子菜单，返回menuResultMap -->  
    <select id="getChildrenMenus" parameterType="int" resultMap="menuResultMap">    
        select * from tb_menu where parent_id = #{id}    
    </select>   
      <!-- 查询所有顶级菜单并且带子菜单集合，返回menuResultMap  -->  
    <select id="getTopLevelMenusWithChildren" resultMap="menuResultMap" >    
        select * from tb_menu   where type=1 and (parent_id IS NULL or parent_id=0)  
    </select

>