TestHSQLDB

Wiki-Quelltext dieser Seite.

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

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();
</eval>