--- a/javadb/org/homelinux/largo/app/App.java
+++ b/javadb/org/homelinux/largo/app/App.java
@@ -1,20 +1,51 @@
package org.homelinux.largo.app;
+import java.util.List;
+import java.sql.SQLException;
import org.homelinux.largo.sql.client.DBClient;
public class App {
public static void main (String args[]) {
+ DBClient db = null;
+ int i = 0;
+
try {
- DBClient db = new DBClient ();
+ db = new DBClient ();
+ List<String> list = db.getTables ();
+
+ System.out.println ("TABLES IN THE CURRENT DATABASE");
+ for (String s : list) {
+ System.out.printf ("[%04d] %s%n", i++, s);
+ }
+ System.out.println ();
+
+ list = db.getColumns("EUROLEAGUE");
+ System.out.println ("COLUMN NAMES IN THIS TABLE");
+ for (String s : list) {
+ System.out.printf ("%s ", s);
+ }
+ System.out.printf ("%n%n");
+
+ i = db.update ("delete from euroleague where bonus>0");
+ System.out.printf ("Deleted: %3d lines%n", i);
db.query ("select * from euroleague order by team");
while (db.hasNext ()) {
- System.out.println (db.getColumn (1));
+ System.out.println (db.getColumn ("team"));
}
-
- db.close ();
+ } catch (SQLException sqle) {
+ System.out.println ("SQLException: " + sqle.getMessage());
} catch (Exception e) {
e.printStackTrace ();
+ } finally {
+ try {
+ if (db != null) {
+ System.out.println ("Disconnecting from database...");
+ db.disconnect();
+ }
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
}
}
}