<?xml version="1.0" encoding="UTF-8"?> <mapper namespace="com.sxt.mapper.MenuMapper"> <resultMap id="BaseResultMap" type="com.sxt.domain.Menu"> <id column="id" jdbcType="INTEGER" property="id" /> <result column="pid" jdbcType="INTEGER" property="pid" /> <result column="title" jdbcType="VARCHAR" property="title" /> <result column="href" jdbcType="VARCHAR" property="href" /> <result column="spread" jdbcType="INTEGER" property="spread" /> <result column="target" jdbcType="VARCHAR" property="target" /> <result column="icon" jdbcType="VARCHAR" property="icon" /> <result column="available" jdbcType="INTEGER" property="available" /> </resultMap> <sql id="Base\_Column\_List"> id, pid, title, href, spread, target, icon, available </sql> \<!-- 查询所有菜单 --> <select id="queryAllMenu" resultMap="BaseResultMap"> select <include refid="Base\_Column\_List" /> from sys\_menu </select> </mapper> - - - - - -