| 제목 | erzhongxmu JEEWMS 3.7 SQL Injection |
|---|
| 설명 | JEEWMS v3.7 WmSttInGoodsController (上架/putaway PDA interface) concatenates user-supplied searchstr parameters directly into HQL queries without parameterization, allowing authenticated attackers to alter query logic and access all data records.
Vulnerable code (WmSttInGoodsController.list, line 540):
hql = hql + " and binId like '%" + searchstr + "%'";
A request with searchstr=' or 1=1 or '1'='1 returns ALL wm_stt_in_goods rows instead of the filtered set (verified live: normal request with searchstr=BIN01 returns 2 records, injected request returns all 3 records in the response JSON "obj" array, bypassing the intended binId/position filter).
PoC:
GET /wmSttInGoodsController.do?username=test&searchstr=' or 1=1 or '1'='1 -> all records returned in "obj"
GET /wmSttInGoodsController.do?username=test&searchstr=BIN01 -> only matching records
Vulnerable code: src/main/java/com/zzjee/wm/controller/WmSttInGoodsController.java:540 |
|---|
| 원천 | ⚠️ https://github.com/erzhongxmu/JEEWMS |
|---|
| 사용자 | HYap (UID 101011) |
|---|
| 제출 | 2026. 09. 04. AM 11:40 (1 월 ago) |
|---|
| 모더레이션 | 2026. 10. 11. AM 10:04 (1 month later) |
|---|
| 상태 | 수락 |
|---|
| VulDB 항목 | 416559 [erzhongxmu JEEWMS 까지 2026.09.27-W39 WmSttInGoodsController.java WmSttInGoodsController.list searchstr SQL 주입] |
|---|
| 포인트들 | 20 |
|---|