pWHi52DP

1public abstract class Furniture {
2
3    private String furnishing;
4    private String board;
5    private String wood;
6    private double mass;
7    private int price;
8    private int shippingPrice;
9
10}
11	
12public final class Dresser extends Furniture {
13
14    private int width;
15    private int length;
16    private int height;
17    private int drawers;
18
19}
20	
21CREATE TABLE furnitures (
22    index INTEGER NOT NULL AUTO_INCREMENT,
23    furnishing VARCHAR(255) NOT NULL,
24    board VARCHAR(255) NOT NULL,
25    wood VARCHAR(255) NOT NULL,
26    mass FLOAT(5,2) NOT NULL,
27    price INTEGER NOT NULL,
28    shipping_price INTEGER NOT NULL,
29    PRIMARY KEY (index)
30)
31
32CREATE TABLE IF NOT EXISTS dressers (
33    index INTEGER NOT NULL
34    width INTEGER NOT NULL
35    length INTEGER NOT NULL
36    height INTEGER NOT NULL
37    drawers INTEGER NOT NULL
38    PRIMARY KEY (index)
39    FOREIGN KEY (index) REFERENCES furniture (index)
40)
41	
42String query =
43"SELECT furniture.board, furniture.wood, furniture.mass, " +
44"furniture.price, furniture.shipping_price, " +
45"dresser.width, dresser.length, dresser.height, dresser.drawers " +
46"FROM furniture, dresser " +
47"WHERE " +
48"furniture.index = dresser.index";