init.sql

来自「是关于struts+hibernate+spring开发宝典的源代码,希望对大家」· SQL 代码 · 共 10 行

CREATE TABLE PRODUCTS (
          ID INTEGER NOT NULL PRIMARY KEY,
          DESCRIPTION VARCHAR(255),
          PRICE DECIMAL(15,2)
        );

INSERT INTO PRODUCTS (ID, DESCRIPTION, PRICE) VALUES(1, 'Lamp', 5.78);
INSERT INTO PRODUCTS (ID, DESCRIPTION, PRICE) VALUES(2, 'Table', 75.29);
INSERT INTO PRODUCTS (ID, DESCRIPTION, PRICE) VALUES(3, 'Chair', 22.81);