因为在SSM 框架中 一些SQL语句用的十分多,就会把这些sqlID的字段定义成枚举值
public interface SqlId { public String SQL_SELECT_COUNT = "selectCount"; public String SQL_SELECT = "select"; public String SQL_SELECT_BY_ID = "selectById"; public String SQL_UPDATE_BY_ID = "updateById"; public String SQL_UPDATE_BY_ID_SELECTIVE = "updateByIdSelective"; public String SQL_DELETE = "delete"; public String SQL_DELETE_BY_ID = "deleteById"; public String SQL_INSERT = "insert"; }
映射文件中也是需要ID就是这些枚举值
<!-- 查询 --> <select id="select" resultMap="BaseResultMap" parameterType="java.util.Map"> select <include refid="Base_Column_List"/> from t_common_ad <include refid="Base_Where_Clause"/> </select> <!-- 查询 --> <select id="selectShowAd" resultMap="BaseResultMap" parameterType="java.util.Map"> select <include refid="Base_Column_List"/> from t_common_ad WHERE bundle_id = #{bundleId,jdbcType=VARCHAR} and position = #{position,jdbcType=VARCHAR} and platform = #{platform,jdbcType=VARCHAR} and end_time > #{date,jdbcType=TIMESTAMP} and start_time <= #{date,jdbcType=TIMESTAMP} </select>