学习博客：javaweb图书模块的编写---Dao和测试Dao

这是用户功能的dao接口：

package cn.zsp.dao;

import cn.zsp.pojo.Book;

import java.util.List;

public interface BookDao {
    public int addBook(Book book);
    public int deleteBookById(Integer id);
    public int updateBook(Book book);
    public Book queryBookById(Integer id);
    public List<Book> queryBooks();

}

这是实现类继承了basedao：

package cn.zsp.dao.impl;

import cn.zsp.dao.BookDao;
import cn.zsp.pojo.Book;

import java.util.List;

public class BookDaoImpl extends BaseDao implements BookDao {
    @Override
    public int addBook(Book book) {
        String sql="insert into t_book (name,price,author,sales," +
                "stock,img_path)values(?,?,?,?,?,?)";
        return update(sql,book.getName(),book.getPrice(),
                book.getAuthor(),book.getSales(),book.getStock(),
                book.getImgPath());
    }

    @Override
    public int deleteBookById(Integer id) {
        String sql="delete from t_book where id=?";
        return update(sql,id);
    }

    @Override
    public int updateBook(Book book) {
        String sql="update t_book set `name`=? , `author`=? , `price`=? , " +
                "`sales`=? , `stock` =?, `img_path`=? where id=?";
        return  update(sql,book.getName(), book.getAuthor(),
                book.getPrice(),book.getSales(),book.getStock(),
                book.getImgPath(),book.getId());
    }

    @Override
    public Book queryBookById(Integer id) {
        String sql="select `name` , `author` , `price` , `sales` , " +
                "`stock` , `img_path` imgPath from t_book where id=?";
        return queryForOne(Book.class,sql,id);
    }

    @Override
    public List<Book> queryBooks() {
        String sql= "select `name` , `author` , `price` , `sales` , " +
                "`stock` , `img_path` imgPath from t_book ";
        return queryForList(Book.class,sql);
    }
}

测试部分：

package cn.zsp.test;

import cn.zsp.dao.impl.BookDaoImpl;
import cn.zsp.pojo.Book;
import org.junit.Test;

import java.math.BigDecimal;



public class BookDaoTest {
    private BookDaoImpl bookDao=new BookDaoImpl();
    @Test
    public void addBook() {

        System.out.println( bookDao.addBook(new Book(null,"鹏哥的自传",new BigDecimal(999),
                "你鹏哥",30
                ,30, null)));
    }

    @Test
    public void deleteBookById() {

        System.out.println(bookDao.deleteBookById(25));
    }

    @Test
    public void updateBook() {
        bookDao.updateBook(new Book(22,"真*鹏哥的自传",new BigDecimal(999),
                "你鹏哥",30
                ,30, null));
    }

    @Test
    public void queryBookById() {

        System.out.println( bookDao.queryBookById(22));
    }

    @Test
    public void queryBooks() {
        for (Book queryBook:bookDao.queryBooks())
        {
            System.out.println(queryBook);
        }
    }
}