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