book.java

JSP+SQL应用开发网上书店系统,采用BMP模式开发

package hell;


 import java.sql.*;
 import hell.*;
 import java.math.*;
public class Book {
   protected String bookId;
   protected String bookName;
   protected String bookAuthor;
   protected String bookDetail;
   protected float bookMoney;
   protected int buynum;
  public Book(String _bookId,int _buynum) {
    try
    {
     DBSQLManager dbsm=new DBSQLManager();
     String sql="SELECT BookId,BookName,BookAuthor,BookDetail,BookMoney FROM BookList WHERE BookId='"+_bookId+"'";
     dbsm.setSqlStr(sql) ;
     dbsm.executeQuery();
     ResultSet rs=dbsm.getRs() ;
     rs.next() ;
     bookId=_bookId;
     bookName=rs.getString("BookName") ;
     bookAuthor=rs.getString("BookAuthor") ;
     bookDetail=rs.getString("BookDetail") ;
     bookMoney=rs.getFloat("BookMoney") ;
     buynum=_buynum;
     dbsm.clse() ;
    }
    catch(Exception e){
    System.out.println(e.toString() ) ;
    }
  }
public void setBookId(String newbookId){
  this.bookId=newbookId;
  }
public String getBookId(){
  return bookId;
  }
public void setBookName(String newbookName){
  this.bookName=newbookName;
  }
public String getBookName(){
  return bookName;
  }
public void setBookAuthor(String newbookAuthor){
  this.bookAuthor=newbookAuthor;
  }
public String getBookAuthor(){
  return bookAuthor;
  }
  public void setBookDetail(String newbookDetail){
    this.bookDetail=newbookDetail;
    }
  public String getBookDetail(){
    return bookDetail;
    }
  public void setBookMoney(float newbookMoney){
       this.bookMoney=newbookMoney;
       }
  public float getBookMoney(){
       return bookMoney;
       }
  public void setBuynum(int newbuynum){
             this.buynum=newbuynum;
             }
  public int getBuynum(){
             return buynum;
             }
}