SQL more unknown condition and the unknown query-CodePudding

I want to do such a SQL search queries, consult how to implement, 1. 1 can choose to fill in the data, for example through the drop-down "theme" type choice, to fill in the theme of the related fuzzy search XXX, 2. Also can choose to continue through the drop-down boxes "and or", and then choose the type "the author", continue to fill in the author's fuzzy search XXX, can continue the cycle, seemingly simple SQL cannot be achieved, I use a MYSQL navicat management, springboot + JSP + jpa,; My small white, consult a great god, thanks a lot!

CodePudding user response:

In front of effect must be achieved js,
Then put on the front page of many conditions to the backstage, joining together to form a search string statements, attention to the problem of SQL injection,