| Title | jaychouchannel Tourism_Management_System 8122bf020d91199eddfff3ee02d1632a70a9a132 SQL Injection |
|---|
| Description | The affected component is `travel/src/main/java/com/controller/CommonController.java`, whose unauthenticated `/cal/{tableName}/{columnName}` and related metadata endpoints forward path variables to `travel/src/main/resources/mapper/CommonDao.xml`. `CommonDao.xml` interpolates the attacker-controlled `table`, `column`, `xColumn`, and `yColumn` values with MyBatis `${...}` expressions, including `SELECT sum(${column}) ... FROM ${table}`. An unauthenticated attacker can inject SQL syntax through `tableName`; for example, `users WHERE SLEEP(5)#` causes the database to evaluate `SLEEP(5)` for user rows. This enables remote database query manipulation and disclosure of application data without a token. |
|---|
| Source | ⚠️ https://github.com/jaychouchannel/Tourism_Management_System/issues/7 |
|---|
| User | sxisboy (UID 100112) |
|---|
| Submission | 07/25/2026 18:22 (1 month ago) |
|---|
| Moderation | 09/06/2026 15:48 (1 month later) |
|---|
| Status | Accepted |
|---|
| VulDB entry | 399443 [jaychouchannel Tourism-Management-System up to 8122bf020d91199eddfff3ee02d1632a70a9a132 CommonDao CommonController.java table/column/xColumn/yColumn sql injection] |
|---|
| Points | 20 |
|---|