| Title | erzhongxmu JEEWMS 3.7 SQL Injection |
|---|
| Description | JEEWMS v3.7 WvGiNoticeController /search (出货通知/outbound notice 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 (WvGiNoticeController.lists, line 102):
hql = hql + " and omNoticeId like '%" + searchstr + "%'" + " or imCusCode like '%" + searchstr + "%'";
A request with searchstr=' or 1=1 or '1'='1 returns ALL wv_gi_notice rows instead of the filtered set (verified live: normal request with searchstr=OM001 returns 1 record, injected request returns all 3 records in the response JSON "obj" array).
Additionally, the username parameter is only compared against the assignTo field when it is not empty, so any authenticated low-privilege user can enumerate records that do not belong to them.
PoC:
GET /wvGiNoticeController/search.do?username=test&searchstr=' or 1=1 or '1'='1 -> all records returned in "obj"
GET /wvGiNoticeController/search.do?username=test&searchstr=OM001 -> only matching record
Vulnerable code: src/main/java/com/zzjee/wmapi/controller/WvGiNoticeController.java:102 |
|---|
| Source | ⚠️ https://github.com/erzhongxmu/JEEWMS |
|---|
| User | Lib0gus (UID 101005) |
|---|
| Submission | 09/04/2026 11:28 (2 months ago) |
|---|
| Moderation | 10/11/2026 09:59 (1 month later) |
|---|
| Status | Duplicate |
|---|
| VulDB entry | 959609 |
|---|
| Points | 0 |
|---|