Example #1
0
 public String[][] describePoint(LinePoint point) {
   Database db = model.getDb();
   if (db == null) {
     appendToHistory("Cannot describe point because no database is selected.\n");
     return null;
   }
   String query = "SELECT * FROM " + db.getTableName() + " WHERE ";
   ArrayList<String> keyNames = point.getKeyNames();
   ArrayList<String> keyValues = point.getKeyValues();
   String[][] array = null;
   for (int i = 0; i < keyNames.size(); i++) {
     if (i != 0) {
       query += " && ";
     }
     try {
       query += keyNames.get(i) + "=" + Double.valueOf(keyValues.get(i));
     } catch (NumberFormatException e) {
       query += keyNames.get(i) + " like '" + keyValues.get(i) + "'";
     }
   }
   appendToHistory(query + "\n");
   try {
     ResultSet result = model.queryDb(query);
     ResultSetMetaData md = result.getMetaData();
     int numCols = md.getColumnCount();
     array = new String[numCols][2];
     while (result.next()) {
       for (int i = 0; i < numCols; i++) {
         array[i][0] = md.getColumnName(i + 1);
         try {
           array[i][1] = String.valueOf(result.getDouble(i + 1));
         } catch (SQLException e) {
           array[i][1] = result.getString(i + 1);
         }
         if (result.wasNull()) {
           array[i][1] = "null";
         }
       }
     }
   } catch (DbConnectionException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
   } catch (QueryException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
   } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
   }
   return array;
 }