resultmap 是用來映射結果集的， resultTyle不同。

<resultMap type="entity.Message" id="MessageResult">
??<id column="id_" jdbcType="INTEGER" property="id" />
??<result column="command" jdbcType="VARCHAR" property="command" />
??<result column="description" jdbcType="VARCHAR" property="description" />
??<result column="content" jdbcType="VARCHAR" property="content" />
?</resultMap>

???? <!-- 指定輸入參數時只能傳遞 一個 -->
???? <!-- #{command} 取得 message 的屬性 -->
???? <!-- where標簽 if條件成立時才會連接 -->
?<select id="queryMessage" parameterType="entity.Message" resultMap="MessageResult">
??select id id_ ,command,description,content from message
??<where>
???<if test="command != null and !&quot;&quot;.equals(command.trim())">
????and COMMAND =#{command}
???</if>
???<if
????test="description != null and !&quot;&quot;.equals(description.trim())">
????and DESCRIPTION like '%' #{description} '%'
???</if>
??</where>
?</select>