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); }
ausführen
