Versionsvergleich
Aus ProgrammingWiki
Vergleich: 2010-09-02T19:35:20+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(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, java.sql.ResultSet.CONCUR_READ_ONLY); |
| + | 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); | |
| − | statement.getResultSet(); |
| − | </eval> |
| + | 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> |