| Title | erzhongxmu JEEWMS 3.7 SQL Injection |
|---|
| Description | 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 |
|---|
| Source | ⚠️ https://github.com/erzhongxmu/JEEWMS |
|---|
| User | HYap (UID 101011) |
|---|
| Submission | 09/04/2026 11:40 (1 month ago) |
|---|
| Moderation | 10/11/2026 10:04 (1 month later) |
|---|
| Status | Accepted |
|---|
| VulDB entry | 416559 [erzhongxmu JEEWMS up to 2026.09.27-W39 WmSttInGoodsController.java WmSttInGoodsController.list searchstr sql injection] |
|---|
| Points | 20 |
|---|