| 제목 | Soarkey StudentManagement e08f7f1d5015af407aa4cca0ada3dea189b4937e SQL Injection |
|---|
| 설명 | The affected request path is the `course_ranking` action in `code/src/service/AdminDao.java` at lines 499-525, which forwards the untrusted `cno` parameter into `code/src/dao/CourseDao.java`. `CourseDao.course_ranking(String cno)` at lines 151-156 builds the SQL statement by concatenating `cno` directly into `... and cno = '"+cno+"' order by grade desc;` before execution. Because no parameter binding or validation is applied, an attacker can inject arbitrary SQL conditions and UNION clauses through `cno`. This allows retrieval of unintended rows and exfiltration of data from other tables such as `user`, including usernames, plaintext passwords, and privilege levels. |
|---|
| 원천 | ⚠️ https://github.com/Soarkey/StudentManagement/issues/33 |
|---|
| 사용자 | soulinda (UID 99812) |
|---|
| 제출 | 2026. 07. 16. PM 06:37 (1 월 ago) |
|---|
| 모더레이션 | 2026. 08. 30. AM 10:00 (1 month later) |
|---|
| 상태 | 수락 |
|---|
| VulDB 항목 | 397120 [Soarkey StudentManagement/学生信息管理系统 까지 e08f7f1d5015af407aa4cca0ada3dea189b4937e CourseDao.java CourseDao.course_ranking cno SQL 주입] |
|---|
| 포인트들 | 20 |
|---|