book的增删查改

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 String toString() {
	return "Book [id=" + id + ", bookName=" +bookName + ",description=" +description + ", price=" + price + "]";
}

}

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;

import org.apache.commons.dbcp.BasicDataSourceFactory;

public class DbcpConnection {
//����һ��DataSource����
private static DataSource ds=null;
//�����ִֻ��һ��
static{
try {
//���������ļ�����ȡ
Properties p=new Properties();
FileInputStream in=new FileInputStream(“dbcp.properties”);
p.load(in);
ds=BasicDataSourceFactory.createDataSource§;
} catch (Exception e) {

				e.printStackTrace();
			}
		}
		/*
		 * ��ȡ���Ӷ��?�
		 */
		public static Connection getConnection(){

			Connection conn;
			try {
				conn = ds.getCo