jpa uses findby query. If the parameter is empty, it is not used as a condition. What can I do?
this function is similar to where < if test="xx! = null" > column = xx < / if > of mybatis.
for example, I have a findByNameAndAge (String name,Integer age); . When age is empty,
only queries by name, and age is not a condition.
none of the online searches use the findBy model.
Thank you
doesn't seem to have it. Use JdbcTemplate to do it.
most complex queries cooperate with JdbcTemplate to use
if you want to ignore null, you can directly use JPA's sample query, which ignores null values.
I'll show you the code spring data jpa later. Now we mainly use jooq , combined with jdk8 function. Dynamic sql , return primary key, batch, stored procedure call, etc.
if necessary, I will set up a framework for everyone to communicate and learn
Example Matchers mentioned above. You can dynamically construct ExampleMatcher. For more information, please see https://docs.spring.io/spring., and search for Example Matchers keyword chapter