Mini-Tmall SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in Mini-Tmall versions prior to 2025-02-11. The issue arises in the 'select' function of 'ProductMapper.java', where the 'orderBy' parameter can be manipulated to execute arbitrary SQL commands. This vulnerability can be exploited remotely.

Impact

Exploitation of this vulnerability allows for SQL injection, where an attacker can interfere with the application's database queries. This could lead to unauthorized data access, data manipulation, or in some cases, executing administrative operations on the database.

Reproduction

To reproduce this vulnerability, send a request to the '/tmall/product/0/20' endpoint, including a crafted 'orderBy' parameter that exploits the SQL injection flaw. The 'orderBy' parameter should be manipulated to alter the SQL query execution, taking advantage of the application's SQL query handling.