author | Markus Bröker <mbroeker@largo.dyndns.tv> |
Sun, 19 Jul 2009 19:43:46 +0200 | |
changeset 100 | a6d2add085d7 |
child 123 | 07b2c0b991af |
permissions | -rw-r--r-- |
100
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
1 |
package org.homelinux.largo.app; |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
2 |
|
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
3 |
import org.homelinux.largo.sql.client.DBClient; |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
4 |
|
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
5 |
public class App { |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
6 |
public static void main (String args[]) { |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
7 |
try { |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
8 |
DBClient db = new DBClient ( |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
9 |
"org.apache.derby.jdbc.EmbeddedDriver", |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
10 |
"jdbc:derby:clubstatistik", |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
11 |
null, null |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
12 |
); |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
13 |
|
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
14 |
db.query ("select * from euroleague order by team"); |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
15 |
|
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
16 |
while (db.hasNext ()) { |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
17 |
System.out.println (db.getColumn (1)); |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
18 |
} |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
19 |
|
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
20 |
db.close (); |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
21 |
} catch (Exception e) { |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
22 |
e.printStackTrace (); |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
23 |
} |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
24 |
} |
a6d2add085d7
Apache Derby Examples...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
25 |
} |