SELECT b.name, b.author, b.publisher, b.price, b.image_name AS imageName, b.description FROM book b WHERE b.category_id = ( SELECT c.id FROM category c WHERE c.name = #{bookType} ) LIMIT #{page, jdbcType=INTEGER, javaType=int}, 10 limit 是偏移量 按单位计数,10、20、30
MyBatis不支持分页查询
于 2024-03-02 14:29:26 首次发布