title: Multi-table database SQLite android
body: <p>I'm new with database (SQLite) and I'm trying to do a multi-table database in android. Each table has the same rows (id, name , ph_number). Every tables store a "contact" object.</p>
  
  <p>When I want to store a contact in one table with the method addContactDatos(Contact contact, int partido), it's stored in every tables not just in the one I want. How can I solve it?</p>
  
  <p>This is the Handler:</p>
  
  <pre><code>public class DatabaseHandler extends SQLiteOpenHelper {
  
  // Database Version
  private static final int DATABASE_VERSION = 1;
  
  // Database Name
  private static final String DATABASE_NAME = "contactsManager";
  
  // Contacts Tables  names
  private static final String TABLE_PRIMERO = "contacts";
  private static final String TABLE_SEGUNDO = "contacts";
  private static final String TABLE_TERCERO = "contacts";  
  private static final String TABLE_CUARTO = "contacts";
  
  // Contacts Table Columns names
  private static final String KEY_ID = "id";
  private static final String KEY_NAME = "name";
  private static final String KEY_PH_NO = "phone_number";
  
  int oldVersion=1;
  
  public DatabaseHandler(Context context) {
      super(context, DATABASE_NAME, null, DATABASE_VERSION);
  }
  
  // Creating Tables
  @Override
  public void onCreate(SQLiteDatabase db) {
  
      String CREATE_CONTACTS_TABLE1 = "CREATE TABLE_PRIMERO " + TABLE_PRIMERO + "("
              + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT,"
              + KEY_PH_NO + " TEXT" + ")";
      db.execSQL(CREATE_CONTACTS_TABLE1);
  
  
      String CREATE_CONTACTS_TABLE2 = "CREATE TABLE_SEGUNDO " + TABLE_SEGUNDO + "("
              + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT,"
              + KEY_PH_NO + " TEXT" + ")";
      db.execSQL(CREATE_CONTACTS_TABLE2);
  
  
      String CREATE_CONTACTS_TABLE3 = "CREATE TABLE_TERCERO " + TABLE_TERCERO + "("
              + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT,"
              + KEY_PH_NO + " TEXT" + ")";
      db.execSQL(CREATE_CONTACTS_TABLE3);
  
  
      String CREATE_CONTACTS_TABLE4 = "CREATE TABLE_CUARTO " + TABLE_CUARTO + "("
              + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT,"
              + KEY_PH_NO + " TEXT" + ")";
      db.execSQL(CREATE_CONTACTS_TABLE4);    
  }
  
  // Upgrading database
  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
      // Drop older table if existed
      db.execSQL("DROP TABLE IF EXISTS " + TABLE_PRIMERO);
      db.execSQL("DROP TABLE IF EXISTS " + TABLE_SEGUNDO);
      db.execSQL("DROP TABLE IF EXISTS " + TABLE_TERCERO);
      db.execSQL("DROP TABLE IF EXISTS " + TABLE_CUARTO);
  
      // Create tables again
      onCreate(db);
  }
  
  public void addContactDatos(Contact contact, int partido) {
  
      SQLiteDatabase db = this.getWritableDatabase();
  
      // Inserting Row
      if (partido == 1) {
          ContentValues values = new ContentValues();
          values.put(KEY_NAME, contact.getName()); // Contact Name
          values.put(KEY_PH_NO, contact.getPhoneNumber()); // Contact Phone Number
  
          db.insert(TABLE_PRIMERO, null, values);
          db.close(); // Closing database connection
          Log.d("Entra","MAL");
      }
  
   // Inserting Row
      if (partido == 2) {
           ContentValues values = new ContentValues();
           values.put(KEY_NAME, contact.getName()); // Contact Name
           values.put(KEY_PH_NO, contact.getPhoneNumber()); // Contact Phone Number
          db.insert(TABLE_SEGUNDO, null, values);
          db.close(); // Closing database connection
          Log.d("Entra","2");
                }
  
   // Inserting Row
      if (partido == 3) {
           ContentValues values = new ContentValues();
           values.put(KEY_NAME, contact.getName()); // Contact Name
           values.put(KEY_PH_NO, contact.getPhoneNumber()); // Contact Phone Number
          db.insert(TABLE_TERCERO, null, values);
          db.close(); // Closing database connection
          Log.d("Entra","MAL");
      }
  
   // Inserting Row
      if (partido == 4) {
          ContentValues values = new ContentValues();
          values.put(KEY_NAME, contact.getName()); // Contact Name
          values.put(KEY_PH_NO, contact.getPhoneNumber()); // Contact Phone Number
          db.insert(TABLE_CUARTO, null, values);
          db.close(); // Closing database connection
          Log.d("Entra","MAL");
      }
  
  
  
  }
  
  
  // Getting All Contacts
  public List&lt;Contact&gt; getAllContacts(int partido) {
  
     List&lt;Contact&gt; contactList = new ArrayList&lt;Contact&gt;();
     String selectQuery="";
  // Select All Query
     SQLiteDatabase db = this.getWritableDatabase();
     Cursor cursor = db.rawQuery(selectQuery, null); 
  
     switch (partido){
      case 1:
          selectQuery = "SELECT  * FROM " + TABLE_PRIMERO;  
  
           // looping through all rows and adding to list
           if (cursor.moveToFirst()) {
               do {
                   Contact contact = new Contact();
                   contact.setID(Integer.parseInt(cursor.getString(0)));
                   contact.setName(cursor.getString(1));
                   contact.setPhoneNumber(cursor.getString(2));
                   // Adding contact to list
                   contactList.add(contact);
               } while (cursor.moveToNext());
           }
      break;
  
      case 2:
          selectQuery = "SELECT  * FROM " + TABLE_SEGUNDO;   
  
           // looping through all rows and adding to list
           if (cursor.moveToFirst()) {
               do {
                   Contact contact = new Contact();
                   contact.setID(Integer.parseInt(cursor.getString(0)));
                   contact.setName(cursor.getString(1));
                   contact.setPhoneNumber(cursor.getString(2));
                   // Adding contact to list
                   contactList.add(contact);
               } while (cursor.moveToNext());
           }
          break;
  
      case 3:
          selectQuery = "SELECT  * FROM " + TABLE_TERCERO;   
  
           // looping through all rows and adding to list
           if (cursor.moveToFirst()) {
               do {
                   Contact contact = new Contact();
                   contact.setID(Integer.parseInt(cursor.getString(0)));
                   contact.setName(cursor.getString(1));
                   contact.setPhoneNumber(cursor.getString(2));
                   // Adding contact to list
                   contactList.add(contact);
               } while (cursor.moveToNext());
           }
          break;
  
      case 4:
          selectQuery = "SELECT  * FROM " + TABLE_CUARTO;   
  
  
           // looping through all rows and adding to list
           if (cursor.moveToFirst()) {
               do {
                   Contact contact = new Contact();
                   contact.setID(Integer.parseInt(cursor.getString(0)));
                   contact.setName(cursor.getString(1));
                   contact.setPhoneNumber(cursor.getString(2));
                   // Adding contact to list
                   contactList.add(contact);
               } while (cursor.moveToNext());
           }
          break;
  
    }
  
  
     // return contact list
     return contactList;
  }
  
  public void deleteDB() {
  
      SQLiteDatabase db = this.getWritableDatabase();
      db.delete(TABLE_PRIMERO, null, null);
      db.delete(TABLE_SEGUNDO, null, null);
      db.delete(TABLE_TERCERO, null, null);
      db.delete(TABLE_CUARTO, null, null);
  
  }
  </code></pre>
  
  <p>And this is the object model contact:
      public class Contact {</p>
  
  <pre><code> //private variables
  int _id;
  String _name;
  String _phone_number;
  
  // Empty constructor
  public Contact(){
  
  }
  // constructor
  public Contact(int id, String name, String _phone_number){
      this._id = id;
      this._name = name;
      this._phone_number = _phone_number;
  }
  
  // constructor
  public Contact(String name, String _phone_number){
      this._name = name;
      this._phone_number = _phone_number;
  }
  // getting ID
  public int getID(){
      return this._id;
  }
  
  // setting id
  public void setID(int id){
      this._id = id;
  }
  
  // getting name
  public String getName(){
      return this._name;
  }
  
  // setting name
  public void setName(String name){
      this._name = name;
  }
  
  // getting phone number
  public String getPhoneNumber(){
      return this._phone_number;
  }
  
  // setting phone number
  public void setPhoneNumber(String phone_number){
      this._phone_number = phone_number;
  }
  }
  </code></pre>
  
  <p>Is ther any way to do wat I want . I would really appreciate a little help.
  Thank you very much.</p>