Versionsvergleich
Aus ProgrammingWiki
Vergleich: 2011-01-10T19:18:25+00:00 → 2011-01-10T19:42:35+00:00
<language>Java</language> | |
| − | <eval id="4c7ffb9500d03"> |
| + | <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> |