Sql injection mitigation

Mitigation of sql injection

String tableName;
switch(PARAM):
  case "Value1": tableName = "fooTable";
                 break;
  case "Value2": tableName = "barTable";
                 break;
  ...
  default      : throw new InputValidationException("unexpected value provided"

Source: cheatsheetseries.owasp.org

Similar codes

0 vote211 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
3 votes272 views1 answer
Delete all content in table mysql
SQL
0 vote225 views1 answer
Select all same column value in sql
SQL
3 votes187 views1 answer
Oracle revoke grant
SQL
2 votes209 views2 answers
Sqlite_busy: database is locked
SQL
0 vote190 views1 answer
Min and max salary and name in sql
SQL
0 vote220 views1 answer
Connecting mySQL to STS
SQL
5 votes186 views1 answer
Mysql get last day of month
SQL
0 vote193 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote220 views1 answer
How to access to mysql without root
SQL