19/08/2016

Sqlite database

package com.main.database;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBadapter extends SQLiteOpenHelper{
    private static final String DATABASE_NAME = "test";
    private static final int DATABASE_VERSION = 2;
    private static final String API_CONFIG_TABLE = "CREATE TABLE tablename(id INTEGER PRIMARY KEY  NOT NULL  UNIQUE, test1 VARCHAR, test2 VARCHAR);";


    public DBadapter(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(API_CONFIG_TABLE);

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS tablename");

        onCreate(db);
    }
}
-------------------------------
public class DBmethods {
    private static final String DATABASE_TABLE = "test.sqlite";
    SQLiteDatabase sdb;
    Context sctx;
    DBadapter sdbhelper;

    public DBmethods(Context ctx) {
        this.sctx = ctx;
    }

    public DBmethods open() throws SQLException {
        sdbhelper = new DBadapter(sctx);
        sdb = sdbhelper.getWritableDatabase();
        return this;
    }

    public void close() {
        sdbhelper.close();
    }
/*-----------------INSERT METHOD-------------------------*/
    public boolean insertdetails(Beanclass beanclass) {
        open();
        boolean sucess = true;
        try {
            String query = "INSERT INTO tablename(test1,test2)VALUES(\""
                    + beanclass.gettest1 + "\",\""
                    + beanclass.gettest2 + "\')";
            Log.d("QUERY===>",query);
            sdb.execSQL(query);
        } catch (Exception e) {
            close();
            sucess = false;
            e.printStackTrace();
        }
        close();
        return sucess;
    }

/*-----------------SELECT METHOD-------------------------*/
   public String getvalue() {
        open();
        String result="";
        try {
            String query = "SELECT test2 from tablename";
            Log.d("QUERY", query);
            Cursor cursor = sdb.rawQuery(query, null);
            if (cursor != null && cursor.getCount() > 0 && cursor.moveToFirst()) {
                cursor.moveToFirst();
                // mcu = new HashMap<String, String>();
                try
                {
                    int _test2 = cursor.getColumnIndexOrThrow("test2");
                    result=cursor.getString(_test2 );
                } catch (Exception e) {
                    e.printStackTrace();
                }
            } else {
                Log.d("Table - version", "null");
            }
            if (cursor != null && !cursor.isClosed()) {
                cursor.close();
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        close();
        return result;
    }
public ArrayList<Bean> get_list(){
        ArrayList<Bean> value_list = new ArrayList<Bean>();
        open();
        try {
            String query = "SELECT * from querytable";
            Log.d("QUERY", query);
            Cursor cursor = sdb.rawQuery(query, null);
            if (cursor!= null && cursor.getCount() > 0){
                cursor.moveToFirst();
                int _Title = cursor.getColumnIndexOrThrow
                value_list.add(new Bean(cursor.getString(_Title)));
                while (cursor.moveToNext()) {
                    _Title = cursor.getColumnIndexOrThrow("Title");
                    value_list.add(new Bean(cursor.getString(_Title)));
                }
            }
            if (cursor != null && !cursor.isClosed()) {
                cursor.close();
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
        close();
        return value_list;
    }


 public void deletmethod_table() {
        open();
        String query = "delete FROM tablename";
        Log.d("QUERY", query);
        sdb.execSQL(query);
        close();
    }
}







26/02/2016

Realm Using value Insert 

Class Name : Sampledb.class
package com.main.android.databasemodels;
public class Sampledb extends RealmObject {
 @PrimaryKey
 private String id;
 private String name;
 public String getId() {
    return id;
}
 public void setId(String id) {
   this.id= id;
}
public String getName() {
    return name;
}
public void setName(String name) {
    this.name= name;
}
}
Class Name: Mainactivity
public class Mainactivity extends AppCompatActivity{
 Realm realm;
 @Override
  protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_sample);
    realm = Realm.getDefaultInstance();
    removeExamlisttable();
    realm.beginTransaction();
   for(int i=0;i<arraylistres.length();i++){
    //Create ExamList Realm Object    
Sampledb sampledb= realm.createObject(Sampledb.class);
    sampledb.setId(arraylistres.get(i).getId());
   sampledb.setName(arraylistres.get(i).getName());   }
  realm.commitTransaction();
 }
private void removeSampledbtable(){
    try {
        realm.beginTransaction();
        realm.clear(sampledb.class);
    }catch (Exception e){
        e.printStackTrace(); 
    }finally {
        realm.commitTransaction();
    }
} 
// Find All value 
Sampledb sampledb=realm.where(Sampledb.class).findAll);
}

06/01/2016

Listview Using Custom Adapter

public class Mainactivity extends FragmentActivity{
      private ArrayList<Places> list = new ArrayList<Places>();
      private PlaceListAdapter mPlaceListAdapter;
private ListView placelistview;
       @Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.nearbydreserlistview_layout);
               placelistview = (ListView)findViewById(R.id.placelistview);
              list.add(new Places("a"));
              list.add(new Places("b"));
              list.add(new Places("c"));
              list.add(new Places("d"));
              mPlaceListAdapter = new PlaceListAdapter(context, list);
    placelistview.setAdapter(mPlaceListAdapter);
       }
      public class PlaceListAdapter extends BaseAdapter {
private Context mContext;
private ArrayList<Places> mplaceList;
private LayoutInflater mLayoutInflater = null;

public PlaceListAdapter(Context context, ArrayList<Places> list) {
mContext = context;
mplaceList = list;
mLayoutInflater = (LayoutInflater)            mContext.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
}
@Override
public int getCount() {
return mplaceList.size();
}
@Override
public Object getItem(int pos) {
return mplaceList.get(pos);
}
@Override
public long getItemId(int position) {
return position;
}
@Override
public View getView(final int position, View convertView, ViewGroup parent) {
try {
final ListViewHolder viewHolder;
if (convertView == null) {
LayoutInflater li = (LayoutInflater) mContext.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
convertView = li.inflate(R.layout.placelistadapter_layout, parent,false);
viewHolder = new ListViewHolder(convertView);
convertView.setTag(viewHolder);
} else {
viewHolder = (ListViewHolder) convertView.getTag();
}
viewHolder.name.setText(mplaceList.get(position).getName());
} catch (Exception e) {
e.printStackTrace();
}
return convertView;
}
}
class ListViewHolder {
   public TextView name;
   public ListViewHolder(View base){
    super();
    try {
    name= (TextView) base.findViewById(R.id.txt_name);
    }catch(Exception e){e.printStackTrace();}
   }
}
}