mybatis【多对一，一对多】的增删改查sql写法参考。

<mapper namespace="cn.itsource.mapper.DepartmentMapper">
	<!-- 保存部门 -->
	<insert id="save" parameterType="Department" useGeneratedKeys="true"
		keyProperty="id" keyColumn="id">
		insert into
		t_department(sn,name,manager_id,parent_id,dirPath,state,tenant_id)
		values(#{sn},#{name},#{manager.id},#{parent.id},#{dirPath},#{state},#{tenant.id})
	</insert>

	<!-- 修改部门 -->
	<update id="update" parameterType="Department">
		update t_department set
		sn=#{sn},name=#{name},manager_id=#{manager.id},
		parent_id=#{parent.id},dirPath=#{dirPath},state=#{state},tenant_id=#{tenant.id}
		where id=#{id}
	</update>

	<!-- 删除部门 -->
	<delete id="remove" parameterType="long">
		delete from t_department where
		id=#{id}
	</delete>

	<!-- 通过部门id获取部门 -->
	<select id="loadById" parameterType="long" resultType="Department">
		select * from
		t_department where d.id = #{id}
	</select>

	<!-- 获取所有部门 -->
	<select id="loadAll" resultType="Department">
		select * from t_department