Sql Lite Update Recycler Data Android

======================adepter Class========== Autocall Recoder----------
public class RecyclerAdapter extends RecyclerView.Adapter<RecyclerAdapter.ViewHolder> {

    static List<DatabaseModel> dbList;
    static Context context;
    public String btnn = "Update";
    private  Button btn_edit;
    public DatabaseHelpher db;
    private String id;


    RecyclerAdapter(Context context, List<DatabaseModel> dbList ){
        this.dbList = new ArrayList<DatabaseModel>();
        this.context = context;
        this.dbList = dbList;

    }

    @Override    public RecyclerAdapter.ViewHolder onCreateViewHolder(ViewGroup parent, int viewType) {

        View itemLayoutView = LayoutInflater.from(parent.getContext()).inflate(R.layout.recyclear_item_template, null);

        // create ViewHolder
        ViewHolder viewHolder = new ViewHolder(itemLayoutView);
        return viewHolder;
    }

    @Override    public void onBindViewHolder(final RecyclerAdapter.ViewHolder holder, final int position) {

        holder.name.setText(dbList.get(position).getTitle());
        holder.id = dbList.get(position).getId();


        holder.itemView.setOnClickListener(new View.OnClickListener() {
            @Override            public void onClick(View view) {
              // Toast.makeText(context,.get(position).toString(),Toast.LENGTH_LONG).show();
           //     Toast.makeText(context, "name:"+ dbList.get(position).getId() , Toast.LENGTH_SHORT).show();
                 id = String.valueOf(dbList.get(position).getId());
                String title =dbList.get(position).getTitle();
                String msg =dbList.get(position).getMsg();

             /*   db = new DatabaseHelpher(context);                db.updateContact(id,title,msg);*/


                String btnn  = "Update";
                Intent in=new Intent(context,Update_Template_Item.class);
                in.putExtra("action",btnn);
                in.putExtra("id",id);
                in.putExtra("title",title);
                in.putExtra("msg",msg);
             //   Toast.makeText(context, "ID:"+id , Toast.LENGTH_SHORT).show();
                context.startActivity(in);

             //   Toast.makeText(RecyclerAdapter.context, "you have clicked Row " + getAdapterPosition(), Toast.LENGTH_LONG).show();


            }
        });

       holder.btn_edit.setOnClickListener(new View.OnClickListener() {
            @Override            public void onClick(View view) {

                id = String.valueOf(dbList.get(position).getId());


                db = new DatabaseHelpher(context);
                db.delete_table_template(Integer.parseInt(id));

                Intent in=new Intent(context,MainActivity.class);
                
                context.startActivity(in);

            }
        });



    }

    @Override    public int getItemCount() {
        return dbList.size();
    }

    public static class ViewHolder extends RecyclerView.ViewHolder  {


        private final Button btn_edit;
        private final EditText edt_title;
        public TextView name;
        public Integer id ;
        private Fragment fragment;


        public ViewHolder(View itemLayoutView) {
            super(itemLayoutView);

            name = (TextView) itemLayoutView.findViewById(R.id.title_display);
            btn_edit = (Button) itemLayoutView.findViewById(R.id.btn_del);
            edt_title = (EditText) itemLayoutView.findViewById(R.id.edt_title);



            btn_edit.setOnClickListener(new View.OnClickListener() {
                @Override                public void onClick(View view) {
/*
                    String btnn  = "Update";                    Intent in=new Intent(context,Update_Template_Item.class);                    in.putExtra("action",btnn);                    in.putExtra("id",id);

                    context.startActivity(in);*/
                }
            });


        }


    }
}


=============== Activity================


   getSupportActionBar().setDisplayHomeAsUpEnabled(true);

        /*Intent in = getIntent();        Template = in.getStringExtra("Template");*/

        init();

    }
    public void init(){

        edt_title = (EditText) findViewById(R.id.edt_title);
        edt_msg = (EditText) findViewById(R.id.edt_msg);
        btn_add = (Button) findViewById(R.id.btn_add);
        rv_Template = (RecyclerView) findViewById(R.id.rv_Template);

/*        if (action.equals("Add"))        {            btn_add.setText("ADD");
        }*/
        /*        else  if (action.equals("Update"))        {
            btn_add.setText("UPDATE ");            //-----------DISPLAY-------------------------------------------
            helpher = new DatabaseHelpher(Template_msg.this);            dbList = new ArrayList<DatabaseModel>();            dbList = helpher.getDataFromDB();
            if (dbList.size() > 0) {
                edt_title.setText(title);                edt_msg.setText(msg);
            }

            //------------------------------------------------------
        }*/

        btn_add.setOnClickListener(new View.OnClickListener() {
            @Override            public void onClick(View view) {





                if (edt_title.length() > 0 && edt_msg.length() > 0 ) {

                    Intent in = new Intent(getApplicationContext(), MainActivity.class);

                    String title = edt_title.getText().toString();
                    String msg = edt_msg.getText().toString();

                    helpher = new DatabaseHelpher(Template_msg.this);

                        helpher.insertIntoDB(title,msg);
                        Toast.makeText(Template_msg.this, "Inserted..", Toast.LENGTH_LONG).show();

                    startActivity(in);

                } else {
                    if (edt_title.length() <= 0) {
                        edt_title.requestFocus();
                        edt_title.setError("Enter Title Name");

                    } else if (edt_msg.length() <= 0) {
                        edt_msg.requestFocus();
                        edt_msg.setError("Enter Msg");
                    }
                }

            }
        });
        helpher = new DatabaseHelpher(this);
        dbList = new ArrayList<DatabaseModel>();
        dbList = helpher.getDataFromDB();

        rv_Template.setHasFixedSize(true);
        mLayoutManager = new LinearLayoutManager(this);
        rv_Template.setLayoutManager(mLayoutManager);

        mAdapter = new RecyclerAdapter(this, dbList);
        rv_Template.setAdapter(mAdapter);


    }

    @Override    public boolean onSupportNavigateUp() {
        onBackPressed();
        return true;
    }


========================helper class -------------




public class DatabaseHelpher extends SQLiteOpenHelper {
    private static final String DATABASE_NAME="autosendmsg";
    private static final int DATABASE_VERSION = 3;
    private static final String TEMPLATE_TABLE = "template";
    private static final String TEMPLATE_SETTING = "template_setting";
    private static final String TBL_CALLS= "calls";

    private SQLiteDatabase mDb;

    private static final String TEMP_TABLE = "create table "+TEMPLATE_TABLE +"(id INTEGER primary key AUTOINCREMENT,title TEXT,msg TEXT)";
    private static final String TEMP_CALL = "create table "+TBL_CALLS +"(id_call INTEGER primary key AUTOINCREMENT,name TEXT,number TEXT,date TEXT,image_call TEXT,image_msg TEXT,sim TEXT,unread TEXT,txtsim TEXT)";
    private static final String TEMP_SETTING = "create table "+TEMPLATE_SETTING +"(api_id INTEGER primary key AUTOINCREMENT,api TEXT)";

    private static final String KEY_ID = "id";


    Context context;
    private String user_name = "sun";

    public DatabaseHelpher(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
        this.context = context;
    }

    @Override    public void onCreate(SQLiteDatabase db) {
        db.execSQL(TEMP_TABLE);
        db.execSQL(TEMP_CALL);
        db.execSQL(TEMP_SETTING);
    }

    @Override    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + TEMPLATE_TABLE);
        db.execSQL("DROP TABLE IF EXISTS " + TBL_CALLS);
        db.execSQL("DROP TABLE IF EXISTS " + TEMPLATE_SETTING);
        // Create tables again        onCreate(db);
    }

    /* Insert into database*/    public void insertIntoDB( String title,String msg){
        Log.d("insert", "before insert");
        // 1. get reference to writable DB        SQLiteDatabase db = this.getWritableDatabase();
        // 2. create ContentValues to add key "column"/value        ContentValues values = new ContentValues();
        values.put("title", title);
        values.put("msg", msg);
        // 3. insert        db.insert(TEMPLATE_TABLE, null, values);
        // 4. close        db.close();
        Toast.makeText(context, "insert value", Toast.LENGTH_LONG);
        Log.i("insert into DB", "After insert");
    }

    /* Retrive  data from database */    public List<DatabaseModel> getDataFromDB(){
        List<DatabaseModel> modelList = new ArrayList<DatabaseModel>();
        String query = "select* from "+TEMPLATE_TABLE ;

        SQLiteDatabase db = this.getWritableDatabase();
        Cursor cursor = db.rawQuery(query,null);

        if (cursor.moveToFirst()){
            do {
                DatabaseModel model = new DatabaseModel();

                model.setId(cursor.getInt(0));
                model.setTitle(cursor.getString(1));
                model.setMsg(cursor.getString(2));

                modelList.add(model);
            }while (cursor.moveToNext());
        }

        Log.d("student data", modelList.toString());
        return modelList;
    }

    // second table=========================
    public void insertIntoDB_call(String name,String number,String date,String image_call,String image_msg,String sim,String unread,String txtsim){
        Log.d("insert", "before insert");

// 1. get reference to writable DB        SQLiteDatabase db = this.getWritableDatabase();

// 2. create ContentValues to add key "column"/value        ContentValues values = new ContentValues();
        values.put("name", name);
        values.put("number", number);
        values.put("date", date);
        values.put("image_call", image_call);
        values.put("image_msg", image_msg);
        values.put("sim", sim);
        values.put("unread", unread);
        values.put("txtsim", txtsim);
// 3. insert        db.insert(TBL_CALLS, null, values);
// 4. close        db.close();
        Toast.makeText(context, "insert value", Toast.LENGTH_LONG);
        Log.i("insert into DB", "After insert");
    }




    public List<get_calls_model> getcallsfromdb(){
        List<get_calls_model> modelList2 = new ArrayList<get_calls_model>();
        String query = "select* from "+ TBL_CALLS ;

        SQLiteDatabase db = this.getWritableDatabase();
        Cursor cursor = db.rawQuery(query,null);

        if (cursor.moveToFirst()){
            do {
                get_calls_model model = new get_calls_model();

                model.setId_call(cursor.getInt(0));
                model.setName(cursor.getString(1));
                model.setNumber(cursor.getString(2));
                model.setDate(cursor.getString(3));
                model.setImage_call(cursor.getString(4));
                model.setImage_msg(cursor.getString(5));
                model.setSim(cursor.getString(6));
                model.setTxtsim(cursor.getString(8));


                modelList2.add(model);
            }while (cursor.moveToNext());
        }

        Log.d("student data", modelList2.toString());

        return modelList2;
    }

    //============
    /* Retrive  data from database */    public List<DatabaseModel> getDataFromDB_spin(){
        List<DatabaseModel> modelList = new ArrayList<DatabaseModel>();
        String query = "select* from "+TEMPLATE_TABLE ;

        SQLiteDatabase db = this.getWritableDatabase();
        Cursor cursor = db.rawQuery(query,null);

        if (cursor.moveToFirst()){
            do {
                DatabaseModel model = new DatabaseModel();
               // model.setId(cursor.getInt(0));                model.setTitle(cursor.getString(1));
                modelList.add(model);
            }while (cursor.moveToNext());
        }

        Log.d("student data", modelList.toString());

        return modelList;
    }
//=========================  UNRESADpublic int getcallsfromdb_unread(String unread){
    List<get_calls_model> modelList2 = new ArrayList<get_calls_model>();
    String query = "select * from "+ TBL_CALLS +" where unread = '"+unread+"'" ;

    int i=0;
    SQLiteDatabase db = this.getWritableDatabase();
    Cursor cursor = db.rawQuery(query,null);

    if (cursor.moveToFirst()){
        do {
            get_calls_model model = new get_calls_model();

            model.setId_call(cursor.getInt(0));
            model.setName(cursor.getString(1));
            model.setNumber(cursor.getString(2));
            model.setDate(cursor.getString(3));
            model.setImage_call(cursor.getString(4));
            model.setImage_msg(cursor.getString(5));
            model.setSim(cursor.getString(6));
            model.setUnread(cursor.getString(7));
            i++;

            modelList2.add(model);
        }while (cursor.moveToNext());
    }

    Log.d("student data", modelList2.toString());

    return i;
}

    public void updateContact2(String unread)
    {
        int i=1;
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues values = new ContentValues();
        String query = "update  "+ TBL_CALLS +"  set unread = '"+unread+"' where unread = '"+i+"'" ;
        values.put("unread", unread);
        Cursor cursor = db.rawQuery(query,null);
        if (cursor.moveToFirst()){

        } while (cursor.moveToNext());


    }
    //===============================

    public void updateEdittext(String edt_msg,String txt_title)
    {
        int i=1;
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues values = new ContentValues();
        String query = "update  "+ TEMPLATE_TABLE +"  set msg = '"+edt_msg+"' where title = '"+txt_title+"'" ;
        values.put("msg", edt_msg);
        Cursor cursor = db.rawQuery(query,null);
        if (cursor.moveToFirst()){

        } while (cursor.moveToNext());


    }
    //============================
    public void delete_table_template(int id){

        SQLiteDatabase db = this.getWritableDatabase();
        db.delete(TEMPLATE_TABLE, KEY_ID + " = ?", new String[] { Integer.toString(id) });
        db.close();
    }


    public int updateContact(int id,String title,String msg)
    {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues values = new ContentValues();

        values.put(KEY_ID, id);
        values.put("title", title);
        values.put("msg", msg);
        // updating row        return db.update(TEMPLATE_TABLE, values, KEY_ID + " = ?", new String[] { String.valueOf(id) });

    }


    public List<String> getAllNames(){
        List<String> labels = new ArrayList<String>();
        labels.add("Deafault");

        String selectQuery = "SELECT  * FROM " + TEMPLATE_TABLE;
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery(selectQuery, null);
        if (cursor.moveToFirst()) {
            do {
                labels.add(cursor.getString(1));
            } while (cursor.moveToNext());
        }

        cursor.close();
        db.close();
        return labels;
    }



    public String getMsg(String title) {
        String message ="";
        String selectQuery="SELECT msg FROM "+ TEMPLATE_TABLE+" where title = '"+title+"'";

        SQLiteDatabase db = this.getReadableDatabase();
        Cursor c = db.rawQuery(selectQuery, null);
        if (c.moveToFirst()) {
            do {
                message = c.getString(c.getColumnIndex("msg"));
            } while (c.moveToNext());
        }

        // TODO Auto-generated method stub
        return message;

    }


    /* Insert into database*/    public void insertIntoDB_setting(String api){
        Log.d("insert", "before insert");
        // 1. get reference to writable DB        SQLiteDatabase db = this.getWritableDatabase();
        // 2. create ContentValues to add key "column"/value        ContentValues values = new ContentValues();
        values.put("api", api);
        // 3. insert        db.insert(TEMPLATE_SETTING, null, values);
        // 4. close        db.close();
        Toast.makeText(context, "insert value", Toast.LENGTH_LONG);
        Log.i("insert into DB", "After insert");
    }


































Comments











Post a Comment



















Popular posts from this blog









retrofil gjstatus lanuage





















   implementation 'com.squareup.retrofit2:retrofit:2.5.0'      implementation 'com.squareup.retrofit2:converter-gson:2.5.0'      implementation 'com.squareup.okhttp3:logging-interceptor:3.12.1'   public class ApiClient {       public static String BASE_URL = "https://sktechnocastt.000webhostapp.com/";      private static Retrofit retrofit = null;       public static Retrofit getClient(Context context) {          if (retrofit == null) {               HttpLoggingInterceptor interceptor = new HttpLoggingInterceptor();              interceptor.setLevel(HttpLoggingInterceptor.Level.BODY);               OkHttpClient httpClient = new OkHttpClient.Builder()                      .connectTimeout(30, TimeUnit.SECONDS)                    ...








Read more










form object





















  form object   <HTML>                      <HEAD>                                <TITLE>Form Object Example</TITLE>                      </HEAD>                      <BODY>   <FORM name="form1" action = "PromptBox.html" method = "POST">                                             Enter your name: <INPUT name = "FName"><BR>                                ...








Read more










Login Preference in android create class





















    ==========login page       LoginPreference loginpreference = new LoginPreference(getApplicationContext()); loginpreference.set_login_value( user_id , user_name , P_referralcode );     ===========create class     package com.example.mactech.spinevent;  import android.content.Context; import android.content.Intent; import android.content.SharedPreferences;  import java.util.HashMap;  /**  * Created by mactech on 5/17/2018.  */ public class LoginPreference  {      SharedPreferences pref ;     SharedPreferences.Editor editor ;     Context _context ;     int PRIVATE_MODE = 0 ;      // All Shared Preferences Keys     private static final String IS_USER_LOGIN = "IsUserLoggedIn" ;      private static final String PREFER_NAME = "LoginPreference" ;     public static String user_id = "u_id" ;     public static String user_name = "u_name" ;     public static String P_referralcode = "user_referal_generate" ;        public LoginPreference(Context...








Read more