TestHSQLDB

<eval id="4c7ffb9500d03"> Class.forName("org.hsqldb.jdbcDriver").newInstance();</eval>

connection = java.sql.DriverManager.getConnection("dbc:hsqldb:meineDB", "sa", ""); statement = connection.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, java.sql.ResultSet.CONCUR_READ_ONLY);

sql = "DROP TABLE Place IF EXISTS;"; sql+= "CREATE TABLE Place (Code INTEGER,Name VARCHAR(255));"; sql+= "CREATE INDEX iCode ON Place (Code);"; sql+= "DROP TABLE Customer IF EXISTS;"; sql+= "CREATE TABLE Customer (Nr INTEGER,Name VARCHAR(255),Place INTEGER);"; sql+= "CREATE INDEX iNr ON Customer (Nr);";

sql+= "INSERT INTO Place VALUES (4900,'Langenthal');"; sql+= "INSERT INTO Place VALUES (8000,'Zurich');"; sql+= "INSERT INTO Place VALUES (3000,'Berne');"; sql+= "INSERT INTO Place VALUES (1200,'Geneva');"; sql+= "INSERT INTO Place VALUES (6900,'Lugano');";

sql+= "INSERT INTO Customer VALUES (1,'Meier',3000);"; sql+= "INSERT INTO Customer VALUES (2,'Mueller',8000);"; sql+= "INSERT INTO Customer VALUES (3,'Devaux',1200);"; sql+= "INSERT INTO Customer VALUES (4,'Rossi',6900);"; sql+= "INSERT INTO Customer VALUES (5,'Rickli',3000);"; sql+= "INSERT INTO Customer VALUES (6,'Graf',3000);"; sql+= "INSERT INTO Customer VALUES (7,'Mueller',4900);"; sql+= "INSERT INTO Customer VALUES (8,'May',1200);"; sql+= "INSERT INTO Customer VALUES (9,'Berger',8000);"; sql+= "INSERT INTO Customer VALUES (10,'D''Ascoli',6900);"; sql+= "INSERT INTO Customer VALUES (11,'Padruz',1200);"; sql+= "INSERT INTO Customer VALUES (12,'Hug',4900);"; sql+= "SELECT * FROM Customer;";

statement.execute(sql); statement.getResultSet();