TestHSQLDB

Wiki-Quelltext dieser Seite.

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

connection = java.sql.DriverManager.getConnection("jdbc:hsqldb:.", "sa", "");
statement = connection.createStatement();

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);
r = statement.getResultSet();
m = r.getMetaData();
col = m.getColumnCount();

while (r.next()) {
 s = "";
 for (int i = 1; i <= col; i++) {
   s += r.getString(i)+"|";
   if (r.wasNull()) s += "(null)"+"|";
 }
 System.out.println(s);
}

</run>