public interface SystemParameterMapper {

    int deleteByPrimaryKey(Integer id);

    int insert(SystemParameterDO record);

    SystemParameterDO selectByPrimaryKey(Integer id);//不使用注解

    List<SystemParameterDO> selectAll();

    int updateByPrimaryKey(SystemParameterDO record);

    SystemParameterDO getByParamID(@Param("paramID") String paramID);//使用注解

}

<select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">

    select id, paramID, paramContent, paramType, memo

    from wh_system_parameter

    where id = #{id,jdbcType=INTEGER}

  </select>

<select id="getByParamID"  resultMap="BaseResultMap">

    select id, paramID, paramContent, paramType, memo

    from wh_system_parameter

    where paramID = #{paramID}

  </select>