mybatis

1.order by cast(d.seq as int) asc 

2.<if test="flag!=true">and t.enable='0'</if>

3.

	<!-- 修改记录，单个字段修改-->
	<update id="editField" parameterType="java.util.Map">
		update sys_on set ${fieldName}=${fieldValue} where id = ${id}
	</update>

4.select max(sort) from sys_on

5.

<resultMap id="BaseResultMap" type="com.ee">
	<result column="id" property="id" />
	<result column="created" property="created" />
	<association property="departments" javaType="com.nt">  
            <id column="id" property="id"/>
            <result column="department_name" property="department_name"/>
        </association>
</resultMap>

		select emp.*,d.name as department_name,p.name as position_name from ee as emp 
		left join ment as d on emp.ment = d.id