呃呃呃呃呃呃

// 假设你已经有了DBCP的配置和DBUtils的QueryRunner
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

// ... 其他必要的导入 ...

public class BookDao {
    private static final String SELECT_ALL_BOOKS = "SELECT * FROM books";
    private static final String DELETE_BOOK = "DELETE FROM books WHERE book_id = ?";

    private QueryRunner runner;

    public BookDao(DataSource dataSource) {
        this.runner = new QueryRunner(dataSource);
    }

    public List<Book> getAllBooks() throws SQLException {
        return runner.query(SELECT_ALL_BOOKS, new BeanListHandler<>(Book.class));
    }