2021-08-02苞米豆读取列表

1.实体类book

package com.pro.domain;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;

@TableName("book")
public class Book {
    @TableId(type = IdType.AUTO)
    @TableField("bookId")
    private Long bookId;
    private String bookName;
    private Long categoryId;
    private String subTitle;
    private String author;
    private String cover;
    private String description;
    private float evaluationScore;
    private Integer evaluationQuantity;

    @Override
    public String toString() {
        return "Book{" +
                "bookId=" + bookId +
                ", bookName='" + bookName + '\'' +
                ", categoryId=" + categoryId +
                ", subTitle='" + subTitle + '\'' +
                ", author='" + author + '\'' +
                ", cover='" + cover + '\'' +
                ", description='" + description + '\'' +
                ", evaluationScore=" + evaluationScore +
                ", evaluationQuantity=" + evaluationQuantity +
                '}';
    }

    public Long getBookId() {
        return bookId;
    }

    public void setBookId(Long bookId) {
        this.bookId = bookId;
    }

    public String getBookName() {
        return bookName;
    }

    public void setBookName(String bookName) {
        this.bookName = bookName;
    }

    public Long getCategoryId() {
        return categoryId;
    }

    public void setCategoryId(Long categoryId) {
        this.categoryId = categoryId;
    }

    public String getSubTitle() {
        return subTitle;
    }

    public void setSubTitle(String subTitle) {
        this.subTitle = subTitle;
    }

    public String getAuthor() {
        return author;
    }

    public void setAuthor(String author) {
        this.author = author;
    }

    public String getCover() {
        return cover;
    }

    public void setCover(String cover) {
        this.cover = cover;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public float getEvaluationScore() {
        return evaluationScore;
    }

    public void setEvaluationScore(float evaluationScore) {
        this.evaluationScore = evaluationScore;
    }

    public Integer getEvaluationQuantity() {
        return evaluationQuantity;
    }

    public void setEvaluationQuantity(Integer evaluationQuantity) {
        this.evaluationQuantity = evaluationQuantity;
    }
}

---

2.BookDao接口

package com.pro.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

public interface BookDao extends BaseMapper {
}

---

3.BookService

package com.pro.service;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.pro.domain.Book;

public interface BookService {
    /**
     * 分页
     * @param page
     * @param rows
     * @return
     */
    public IPage<Book> pageing(Integer page, Integer rows);
}

BookServiceImpl

package com.pro.service;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.pro.dao.BookDao;
import com.pro.domain.Book;
import org.springframework.beans.factory.annotation.Autowired;

public class BookServiceImpl implements BookService {

    @Autowired
    private BookDao bookDao;

    @Override
    public IPage<Book> pageing(Integer page, Integer rows) {
        Page<Book> p = new Page< >(page, rows);
        QueryWrapper<Object> queryWrapper = new QueryWrapper<>();
        IPage<Book> bookPage = bookDao.selectPage(p, queryWrapper);
        return bookPage;
    }
}

---

4.BookServiceTest

package com.pro.service;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.pro.domain.Book;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import java.util.List;



@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = {"classpath:applicationContext.xml"})
public class BookServiceTest {

    @Autowired
    private BookService bookService;

    @Test
    public void pageing() {
        IPage<Book> bookIPage = bookService.pageing(1,2);
        List<Book> bookList = bookIPage.getRecords();
        for (Book book:bookList
             ) {
            System.out.println(book);
        }
        System.out.println(bookIPage.getPages());
        System.out.println(bookIPage.getTotal());
        System.out.println(bookIPage.getCurrent());
        System.out.println(bookIPage.getSize());
    }
}

写完service之后 及得要写个test类来测试是否能取到值