Versionsvergleich

Aus ProgrammingWiki

Vergleich: 2010-09-02T19:31:33+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("dbc:hsqldb:meineDB", "sa", "");
−
statement = connection.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, java.sql.ResultSet.CONCUR_READ_ONLY);
+
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);
−
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>