java图书馆添加与删除_图书管理插入、修改、删除、查询

Book.java

package com.jdbc;

public class Book {

private String id;

private String name;

private String author;

private Double price;

private String press;

public String getId() {

return id;

}

public void setId(String id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getAuthor() {

return author;

}

public void setAuthor(String author) {

this.author = author;

}

public Double getPrice() {

return price;

}

public void setPrice(Double price) {

this.price = price;

}

public String getPress() {

return press;

}

public void setPress(String press) {

this.press = press;

}

@Override

public String toString() {

return "Book [id=" + id + ", name=" + name + ", author=" + author + ", price=" + price + ", press=" + press

+ "]";

}

}

BookDao.java

package com.jdbc;

import java.util.List;

public interface BookDao {

/*update() 方法 */

// 向数据库中增加图书

public int addBook(Book b);

// 更新数据库中的图书

public int updateBook(Book b);

// 删除数据库中的图书

public int deleteBook (int id);

/*query() 方法 */

// 通过 id 查询图书信息

public Book findBookById(int id);

// 查询所有图书信息

public List findAllBook();

}

BookDaoImpl.java

package com.jdbc;

import java.util.List;

import org.springframework.jdbc.core.BeanPropertyRowMapper;

import org.springframework.jdbc.core.JdbcTemplate;