电商

1.  select里面resultMap可以直接引用上面的 resultMap id="BaseResultMap"

<resultMap id="BaseResultMap" type="com.mmall.pojo.User" >
  <constructor >
    <idArg column="id" jdbcType="INTEGER" javaType="java.lang.Integer" />
    <arg column="username" jdbcType="VARCHAR" javaType="java.lang.String" />
  </constructor>
</resultMap>

<select id="selectLogin" resultMap="BaseResultMap" parameterType="map" >
  select
  <include refid="Base_Column_List"/>
  from mmall_user
  where username = #{username,jdbcType=VARCHAR}
  AND password = #{password,jdbcType=VARCHAR}
</select>