book.java

一个网上购书系统

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;
	}
};