mybatis 也是要写 if 差别在于写在设定而已 然而设定难以除错和补全
"需要根据参数是否为空" 这个写函数包起来就好(当然三元运算更丑一点) lambda 都可以 为空就拼接空字串 只是看你要不要写的完整 随便一个范例
MyStatement s = QueryCreator.create(
"select * from user where status = 1",
QueryCreator.ifNotNull(
"name", name,
"email", email,
"address", address
)
)

生成"select * from user where status = 1 where name = ? and email = ? and address = ?" PreparedStatement 再带入参数而已