有没有办法在MySql中将NULL值法作为可选条件？

I'm trying to write a JDBC query with 20 optional search parameters. I would like to know how to make a set of parameters that do not have a value (null) not to be included in the SQL without having too many if/else statements to construct the SQL string manually.I'm trying to write a JDBC query with 20 option