books.java

这是个简单的在线书店购书系统

package mybox;
import java.sql.*;
public class books extends Sqljavabean{
	private String id;
	private String name;
	private String title;
	private float price;
	private int yr;
	private String description;
	private int saleAmount;
	public String getDescription() {
		return description;
	}
	public void setDescription(String description) {
		this.description = description;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public float getPrice() {
		return price;
	}
	public void setPrice(float price) {
		this.price = price;
	}
	public int getSaleAmount() {
		return saleAmount;
	}
	public void setSaleAmount(int saleAmount) {
		this.saleAmount = saleAmount;
	}
	public String getTitle() {
		return title;
	}
	public void setTitle(String title) {
		this.title = title;
	}
	public int getYr() {
		return yr;
	}
	public void setYr(int yr) {
		this.yr = yr;
	}
	public books(){
		id="";
		name="";
		title="";
		price=0;
		yr=0;
		description="";
		saleAmount=0;
		
	}
	public ResultSet showlm(){
		String strsql="select * from books";
		ResultSet rs=super.executeQuery(strsql);
		return rs;
	}
	public ResultSet serchlm(){
		String strsql="select * from books where id="+this.id;
		ResultSet rs=super.executeQuery(strsql);
		return rs;
	}
}