掌握JDBC的基本操作：对book表中的数据进行增删查找

book表：id int，bookName varchar，price int，description varchar
Book类： id int，bookName String，price int，description String
提示：先创建数据库连接工具类DBUtil类

首先，在cmd创建book表：

如图：

然后创建Book类：
Book.java

package test.entity;

public class Book {
	private int id;
	private String bookName;
	private int price;
	private String description;
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getBookName() {
		return bookName;
	}
	public void setBookName(String bookName) {
		this.bookName = bookName;
	}
	public int getPrice() {
		return price;
	}
	public void setPrice(int price) {
		this.price = price;
	}
	public String getDescription() {
		return description;
	}
	public void setDescription(String description) {
		this.description = description;
	}
	
//	public Book(int id,String bookName,int price,String description) {
//		this.id=id;
//		this.bookName=bookName;
//		this.price=price;
//		this.description=description;
//	}
	
	@Override
	public String toString(){
		return "Book [id=" + id + ", name=" + bookName + ", price=" + price +",description"+description+ "]";
	}//把其他类型的数据转为字符串类型的数据(重写Object中的toString方法,将此对象转换为一个字符串)
	
}

创建数据库连接池：
DbcpConnection.java

package test.dbcp;

import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
import javax.sql.DataSource;

public class DbcpConnection {
	private static DataSource ds=null;
	//类加载只执行一次
	static{
		try {
			//加载配置文件并读取
			Properties p=new Properties()