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);//使用注解
}
跟映射的xml
<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>
区别是:使用注解可以不用加parameterType