Huija BicycleSharingServer SQL Injection Vulnerability in AdminController

A critical SQL injection vulnerability has been identified in Huija BicycleSharingServer versions prior to 7b8a3ba48ad618604abd4797d2e7cf3b5ac7625a. The issue arises in the 'searchAdminMessageShow' function of 'AdminController.java', where the 'Title' parameter is not properly sanitized, allowing for malicious SQL code to be injected. This vulnerability can be exploited remotely, and a public proof-of-concept exploit is available.

Impact

Exploitation of this vulnerability allows for SQL injection, where an attacker can manipulate 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 GET request to the 'admin-admin-searchmessage-show' endpoint with a crafted 'title' parameter that includes SQL injection payloads. The injection point is within the 'AdminMessageDao.selectAdminMessageByTitleLike' method, which is called by 'AdminServiceImpl.getAdminMessageByTitleLike'. The injected SQL payload can be used to exploit the application, as demonstrated by the available proof-of-concept exploit.