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