| | |
| | | }
|
| | | if (value instanceof Double)
|
| | | {
|
| | | return new BigDecimal((Double) value);
|
| | | return BigDecimal.valueOf((Double) value);
|
| | | }
|
| | | if (value instanceof Integer)
|
| | | {
|
| | |
| | | // 路径为文件且不为空则进行删除
|
| | | if (file.isFile() && file.exists())
|
| | | {
|
| | | file.delete();
|
| | | flag = true;
|
| | | flag = file.delete();
|
| | | }
|
| | | return flag;
|
| | | }
|
| | |
| | | /**
|
| | | * 定义常用的 sql关键字
|
| | | */
|
| | | public static String SQL_REGEX = "select |insert |delete |update |drop |count |exec |chr |mid |master |truncate |char |and |declare ";
|
| | | public static String SQL_REGEX = "and |extractvalue|updatexml|exec |insert |select |delete |update |drop |count |chr |mid |master |truncate |char |declare |or |+|user()";
|
| | |
|
| | | /**
|
| | | * 仅支持字母、数字、下划线、空格、逗号、小数点(支持多个字段排序)
|
| | |
| | | public SysConfig selectConfig(SysConfig config);
|
| | |
|
| | | /**
|
| | | * 通过ID查询配置
|
| | | * |
| | | * @param configId 参数ID
|
| | | * @return 参数配置信息
|
| | | */
|
| | | public SysConfig selectConfigById(Long configId);
|
| | |
|
| | | /**
|
| | | * 查询参数配置列表
|
| | | *
|
| | | * @param config 参数配置信息
|
| | |
| | | @Override
|
| | | public int updateConfig(SysConfig config)
|
| | | {
|
| | | SysConfig temp = configMapper.selectConfigById(config.getConfigId());
|
| | | if (!StringUtils.equals(temp.getConfigKey(), config.getConfigKey()))
|
| | | {
|
| | | redisService.deleteObject(getCacheKey(temp.getConfigKey()));
|
| | | }
|
| | |
|
| | | int row = configMapper.updateConfig(config);
|
| | | if (row > 0)
|
| | | {
|
| | |
| | | </where>
|
| | | </select>
|
| | |
|
| | | <select id="selectConfigById" parameterType="Long" resultMap="SysConfigResult">
|
| | | <include refid="selectConfigVo"/>
|
| | | where config_id = #{configId}
|
| | | </select>
|
| | | |
| | | <select id="checkConfigKeyUnique" parameterType="String" resultMap="SysConfigResult">
|
| | | <include refid="selectConfigVo"/>
|
| | | where config_key = #{configKey} limit 1
|