Skip to content

GitLab

  • Menu
Projects Groups Snippets
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • H holdingk
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 0
    • Issues 0
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 4
    • Merge requests 4
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Package Registry
    • Infrastructure Registry
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • knitting
  • holdingk
  • Merge requests
  • !1625

Merged
Created Sep 15, 2026 by wangzp@wangzpOwner0 of 5 tasks completed0/5 tasks

H-13:分页排序列白名单,禁止 ORDER BY 注入

  • Overview 0
  • Commits 15
  • Changes 72

分页/导出排序列中央白名单,禁止原始字符串交给 PageHelper,关闭全工程唯一 SQL 注入面。叠在 H-12 上。

Summary

  • OrderBySanitizer:标识符语法 + DynamicSqlSupport 列集;语法非法 400,未知列回退 id
  • PageInfo.getOrderBy / PageUtil.wrapperPage / SortColumn 只产出消毒后的 ORDER BY
  • 维修记录 sum()、机台状态多列、花型统计别名改可信旁路

Test plan

  • orderNo/createTime 仍可排序;不传仍为 id DESC
  • payload(id); SELECT 1--、IF()、多列)返 400,SQL 不含 payload
  • 未知标识符回退 id,不打 Unknown column
  • 维修记录按转数/重量聚合排序;机台状态列表;花型统计分页
  • OrderBySanitizerTest 7 例

无 Maven 升版、无 Flyway。方案:钉钉 H-13

Assignee
Assign to
Reviewer
Request review from
Time tracking
Source branch: hotfix/h13-orderby-injection