Java书城项目第四阶段：图书模块，java入门编程题目

return update(sql, id);

}

@Override

public int updateBook(Book book) {

String sql = “update 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 id , name , author , price , sales , stock , img_path imgPath from book where id = ?”;

return queryForOne(Book.class, sql, id);

}

}

3.3 编写BookDaoImpTest测试类

---

在IDEA中，在对应的接口上点击ctrl+shift+t，可以直接生成测试类。

import sharm.dao.BookDao;

import sharm.dao.impl.BookDaoImp;

import sharm.pojo.Book;

import java.math.BigDecimal;

import static org.junit.Assert.*;

public class BookDaoTest {

//多态 左边是接口，右边是实现类

private BookDao bookDao = new BookDaoImp();

@Test

public void queryBooks() {

for (Book queryBook : bookDao.queryBooks()) {

System.out.println(queryBook);

}

}

@Test

public void addBook() {

bookDao.addBook(new Book(null,“坚持”, “sharm”, new BigDecimal(13),13,0,null));

}

@Test

public void deleteBookById() {

bookDao.deleteBookById(3);

}

@Test

public void updateBook() {

bookDao.updateBook(new Book(4,“人生”, “sharm”, new BigDecimal(9999),1100000,0,null));

}

@Test

public void queryBookById() {

System.out.println( bookDao.queryBookById(4));

}

}

4 编写Service服务层

=================================================================================

4.1 编写BookService接口

---

import sharm.pojo.Book;

import java.util.List;

/**

• 此时Service的业务层的具体业务刚好与Dao层相同

*/

public interface BookService {

public List queryBooks();

public void addBook(Book book);

public void deleteBookById(Integer id);

public void updateBook(Book book);