CX SQL_Injection @ BookDetail_jsp.java [master]

[ghannamz]

SQL_Injection issue exists @ BookDetail_jsp.java in branch master

The application's RatingAction method executes an SQL query with executeUpdate, at line 884 of BookDetail_jsp.java. The application constructs this SQL query by embedding an untrusted string into the query without proper sanitization. The concatenated string is submitted to the database, where it is parsed and executed accordingly.
The attacker would be able to inject arbitrary data into the SQL query, by simply altering the user input paramName, which is read by the getParam method at line 168 of BookDetail_jsp.java. This input then flows through the code to the database server, without sanitization.
This may enable an SQL Injection attack.

Severity: High
CWE:89
Vulnerability details and guidance
Checkmarx
Lines: 169

---

Code (Line #169):

    String param = req.getParameter(paramName);

---