| 제목 | jaychouchannel Tourism_Management_System 8122bf020d91199eddfff3ee02d1632a70a9a132 SQL Injection |
|---|
| 설명 | 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. |
|---|
| 원천 | ⚠️ https://github.com/jaychouchannel/Tourism_Management_System/issues/7 |
|---|
| 사용자 | sxisboy (UID 100112) |
|---|
| 제출 | 2026. 07. 25. PM 06:22 (1 월 ago) |
|---|
| 모더레이션 | 2026. 09. 06. PM 03:48 (1 month later) |
|---|
| 상태 | 수락 |
|---|
| VulDB 항목 | 399443 [jaychouchannel Tourism-Management-System 까지 8122bf020d91199eddfff3ee02d1632a70a9a132 CommonDao CommonController.java table/column/xColumn/yColumn SQL 주입] |
|---|
| 포인트들 | 20 |
|---|