问题遇到的现象和发生背景
问题相关代码,请勿粘贴截图
@Select("<script>"
+ "SELECT "
+ "id,"
+ "property_name,"
+ "property_desc,"
+ "input_type,"
+ "input_values,"
+ "gmt_create,"
+ "gmt_modified "
+ "FROM commodity_property a, "
+ "("
+ "SELECT id FROM commodity_property "
+ "<if test='propertyName != null'> "
+ "WHERE property_name like '#{propertyName}%' "
+ "</if>"
+ "LIMIT #{offset}, #{size}) b "
+ "WHERE a.id = b.id"
+ "</script>")
@Results({
@Result(column = "id", property = "id", id = true),
@Result(column = "property_name", property = "propertyName"),
@Result(column = "property_desc", property = "propertyDesc"),
@Result(column = "input_type", property = "inputType"),
@Result(column = "input_values", property = "inputValues"),
@Result(column = "gmt_create", property = "gmtCreate"),
@Result(column = "gmt_modified", property = "gmtModified")
})
List<PropertyDO> listPropertiesByPage(PropertyQuery propertyQuery);
运行结果及报错内容
我的解答思路和尝试过的方法
我想要达到的结果