예제 #1
0
 private void updateDataBaseName(String newName) {
   db = controllersDBH.getWritableDatabase();
   if (db != null) {
     Cursor cursor = db.rawQuery("SELECT name FROM Controllers", null);
     if (cursor.moveToFirst()) {
       boolean exists = false;
       do {
         if (newName.equals(cursor.getString(0))) exists = true;
       } while (cursor.moveToNext());
       Cursor cursorGroup =
           db.rawQuery(
               "SELECT group1, group2, group3, group4 FROM Controllers WHERE mac='"
                   + deviceMac
                   + "'",
               null);
       boolean existsGroup = false;
       if (cursorGroup.moveToFirst()) {
         do {
           for (int i = 0; i < 4; i++)
             if (newName.equals(cursorGroup.getString(i))) existsGroup = true;
         } while (cursorGroup.moveToNext());
       }
       if (!exists && !existsGroup) {
         if (activeWindow == 0) {
           ContentValues values = new ContentValues();
           values.put("name", newName);
           db.update("Controllers", values, "mac='" + deviceMac + "'", null);
           name = newName;
         } else {
           ContentValues values = new ContentValues();
           values.put(GROUPS[activeWindow], newName);
           db.update("Controllers", values, "mac='" + deviceMac + "'", null);
           if (activeWindow == 1) textViewG1.setText(newName.trim());
           if (activeWindow == 2) textViewG2.setText(newName.trim());
           if (activeWindow == 3) textViewG3.setText(newName.trim());
           if (activeWindow == 4) textViewG4.setText(newName.trim());
         }
       }
     }
     db.close();
   }
   updateTitleView();
 }
예제 #2
0
 public String getViewName(int window) {
   String title = "";
   if (window == 0) title = "Aw Lumina";
   else title = "Grupo " + window;
   db = controllersDBH.getWritableDatabase();
   if (db != null) {
     Cursor cursor =
         db.rawQuery(
             "SELECT name, group1, group2, group3, group4 FROM Controllers WHERE mac='"
                 + deviceMac
                 + "'",
             null);
     if (cursor.moveToFirst()) {
       do {
         title = cursor.getString(window);
       } while (cursor.moveToNext());
     }
     db.close();
   }
   return title;
 }
예제 #3
0
 public void updateGroupsNames() {
   if (deviceMac.length() > 0) {
     db = controllersDBH.getWritableDatabase();
     if (db != null) {
       Cursor cursorGroup =
           db.rawQuery(
               "SELECT group1, group2, group3, group4 FROM Controllers WHERE mac='"
                   + deviceMac
                   + "'",
               null);
       if (cursorGroup.moveToFirst()) {
         do {
           textViewG1.setText(cursorGroup.getString(0).trim());
           textViewG2.setText(cursorGroup.getString(1).trim());
           textViewG3.setText(cursorGroup.getString(2).trim());
           textViewG4.setText(cursorGroup.getString(3).trim());
         } while (cursorGroup.moveToNext());
       }
       db.close();
     }
   }
 }