图书购物系统(jsp)

package bookshop; import java.sql.*; import bookshop.*; public class Book{ protected String isbn; //书的ISBN编号 protected String title; //书名 protected float price; //价格 protected int buynum; //购买数量 public Book(String _isbn, int _buynum) { try { DBSQLManager dbsm = new DBSQLManager(); String sql="SELECT ISBN,TITLE,PRICE FROM bookinfo WHERE ISBN='"+_isbn+"'"; dbsm.setSqlStr(sql); dbsm.executeQuery(); ResultSet rs = dbsm.getRs(); rs.next(); isbn = _isbn; title = rs.getString("TITLE"); price = rs.getFloat("PRICE"); buynum = _buynum; dbsm.close(); } catch (Exception e) { System.out.println(e.toString()); } } public void setIsbn(String newIsbn) { this.isbn = newIsbn; } public String getIsbn() { return isbn; } public void setTitle(String newTitle) { this.title = newTitle; } public String getTitle() { return title; } public void setPrice(float newPrice) { this.price = newPrice; } public float getPrice() { return price; } public void setBuynum(int newBuynum) { this.buynum = newBuynum; } public int getBuynum() { return buynum; } };