Android Open Source - Dense-sms-sender-for-android Database Handler

• Back to SMS/phone  ↑

From Project

Back to project page Dense-sms-sender-for-android.

License

The source code is released under:

Apache License

Java Source Code

package mrhs.ce.DenseSms;
import java.util.ArrayList;
//from   www  .  jav  a  2 s .  c  o  m
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;


public class DatabaseHandler {
  
  private static  int DATABASE_VERSION=4;
  private static final String DATABASE_NAME = "contactsManager";
  private static final String TABLE_NAME = "contactGroups";
  
  private DbHelper dbHelper;
  private  SQLiteDatabase db;
  
  // Necessary functions (DDL)
  public DatabaseHandler(Context ctx){
    dbHelper=new DbHelper(ctx);
  }
  
  public DatabaseHandler open() throws SQLException{
    db=dbHelper.getWritableDatabase();
    return this;
  }
  
  public void close(){
    dbHelper.close();
  }
  
  // DML functions
  
  public boolean insert(String groupName,String phoneNum,String name){
    
    ContentValues values=new ContentValues();
    values.put("groupName", groupName);
    values.put("phoneNum", phoneNum);
    if(name!=null)
      values.put("name", name);
    try{
      return db.insert(TABLE_NAME, null, values)>0;
    }catch(Exception e){
      e.printStackTrace();
      log("Error inserting values to the databse");
      return false;
    }
  }
  
  public boolean delete(String groupName,String phoneNum){
    return db.delete(TABLE_NAME, "groupName = '"+groupName+"' and phoneNum= '"+phoneNum+"'", null)>0;
  }
  public boolean delete(String groupName){
    return db.delete(TABLE_NAME, "groupName = '"+groupName+"'", null)>0;
  }  
  
  public String getName(String groupName,String phoneNum){
    Cursor cursor=db.query(true, TABLE_NAME,
        new String[]{"phoneNum" ,"name"}, "groupName = '"+groupName+"' and phoneNum= '"+phoneNum+"'", null, null, null, " name desc", null);
    if(cursor != null){
      cursor.moveToFirst();
      return cursor.getString(0);
    }return null;
  }
  
  public Cursor getAllPhoneNums(){
    Cursor cursor=db.query(true, TABLE_NAME,
        new String[]{"phoneNum","name"}, null, null, null, null, "name desc", null);
    
    cursor.moveToFirst();
    return cursor;
  }  
  
  public Cursor getAllGroups(){
    Cursor cursor=db.query(true, TABLE_NAME,
        new String[]{"groupName"}, null, null, null, null, "groupName desc", null);
    cursor.moveToFirst();
    return cursor;
  }
  
  public boolean isFilled(){
    Cursor cursor=db.query(true, TABLE_NAME,
        new String[]{"groupName","phoneNum"}, null, null, null, null, "name desc", null);
    return cursor.moveToFirst();
  }
  
  public boolean groupExists(String groupName){
    Cursor cursor=db.query(true, TABLE_NAME,
        new String[]{"phoneNum"}, "groupName = '"+groupName+"'", null, null, null, " name desc", null);    
    return cursor.moveToFirst();
  }
  
  public ArrayList<String> getGroupList(){
    ArrayList<String> list=new ArrayList<String>();
    Cursor cursor=db.query(true, TABLE_NAME,
        new String[]{"groupName"}, null, null, null, null, "groupName desc", null);
    if(cursor.moveToFirst()){      
      do{
        list.add(cursor.getString(0));
      }while(cursor.moveToNext());
    }
      
    return list;
  }
  public ArrayList<String> getPhoneList(String groupName){
    ArrayList<String> list=new ArrayList<String>();
    Cursor cursor=db.query(true, TABLE_NAME,
        new String[]{"phoneNum" ,"name"}, "groupName = '"+
            groupName+"'", null, null, null, " name desc", null);
    if(cursor.moveToFirst()){      
      do{
        list.add(cursor.getString(0));
      }while(cursor.moveToNext());
    }
      
    return list;
  }
  
  public ArrayList<String> getNameList(String groupName){
    ArrayList<String> list=new ArrayList<String>();
    Cursor cursor=db.query(true, TABLE_NAME,
        new String[]{"phoneNum" ,"name"}, "groupName = '"+
            groupName+"'", null, null, null, " name desc", null);
    if(cursor.moveToFirst()){      
      do{
        list.add(cursor.getString(1));
      }while(cursor.moveToNext());
    }
      
    return list;
  }

  private static class DbHelper extends SQLiteOpenHelper{
          
    public DbHelper(Context context){
      super(context, DATABASE_NAME, null, DATABASE_VERSION);
      log("The database has been initialized");
    }
  
    @Override
    public void onCreate(SQLiteDatabase db) {
      // TODO Auto-generated method stub
      String CREATE_DATABASE="CREATE TABLE "+TABLE_NAME+ 
          " ( groupName text,phoneNum varchar(13), name text, primary key(groupName,phoneNum))";
      db.execSQL(CREATE_DATABASE);
      log("Databse schematic has been craeted");
    }
  
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
      // TODO Auto-generated method stub
      db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME);
      onCreate(db);
    }  
    
  }
  private static void log(String message){
    Log.d("DbHelper",message);
  }
}

Java Source Code List

• Back to SMS/phone  ↑