Sqllite Insert Record

=======Sqllite--Database Halper=========

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");
    }


}


==================


 


helpher = new DatabaseHelpher(context);




helpher.insertIntoDB_call("mayur", incomingNumber, Todaydattime, img, img2, img3,"1","sim");


 














============ GsmAllaram Data recycler view  get data=================




helpher1 = new DatabaseHelpher(getActivity());
dbList = new ArrayList<DatabaseModel1>();
dbList = (ArrayList<DatabaseModel1>) helpher1.getDataFromDB1(username);


mRecyclerView = (RecyclerView)view.findViewById(R.id.recycleview);

mRecyclerView.setHasFixedSize(true);

// use a linear layout managermLayoutManager = new LinearLayoutManager(getActivity());
mRecyclerView.setLayoutManager(mLayoutManager);

// specify an adapter (see also next example)mAdapter = new RecyclerAdapter1(getActivity(), dbList);
mRecyclerView.setAdapter(mAdapter);



//------------------------------------------------------



public class DatabaseModel1 {


    private String username;
    private String name;
    private String time_date1;
    private String imgg;
    private int id;

    public String getImgg() {
        return imgg;
    }

    public void setImgg(String imgg) {
        this.imgg = imgg;
    }

    public String getTime_date1() {
        return time_date1;
    }

    public void setTime_date1(String time_date1) {
        this.time_date1 = time_date1;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }


    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }


}
 


 


---------------------------adepter class


 



public class RecyclerAdapter1 extends RecyclerView.Adapter<RecyclerAdapter1.ViewHolder> {

    static List<DatabaseModel1> dbList;
    static Context context;
    public String btnn = "Update";
    private Bitmap bitmap;

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


    }

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

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

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

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

       // holder.uname.setText(dbList.get(position).getUsername());        holder.name.setText(dbList.get(position).getName());
        holder.date_time.setText(dbList.get(position).getTime_date1());
        String imgg1=(dbList.get(position).getImgg());

        StringToBitMap(imgg1);
        holder.image1.setImageBitmap(bitmap);

        holder.id = dbList.get(position).getId();
    }


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

    public static class ViewHolder extends RecyclerView.ViewHolder  {



        public TextView name;
        public TextView uname;
        public TextView date_time;
        public ImageView image1;
        public Integer id ;


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

         //   uname = (TextView) itemLayoutView.findViewById(R.id.rvname1);            name = (TextView) itemLayoutView.findViewById(R.id.rvname1);
            date_time = (TextView) itemLayoutView.findViewById(R.id.date_time);
            image1 = (ImageView) itemLayoutView.findViewById(R.id.image1);



        }


   }
    public Bitmap StringToBitMap(String image){
        try{
            byte [] encodeByte= Base64.decode(image,Base64.DEFAULT);
            bitmap= BitmapFactory.decodeByteArray(encodeByte, 0, encodeByte.length);
            return bitmap;
        }catch(Exception e){
            e.getMessage();
            return null;
        }
    }


}
===================================






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

String name = et_name.getText().toString();
String no = et_number.getText().toString();

helpher = new DatabaseHelpher(AddNewHost.this);




helpher.updateContact(idd, name, no);
 



































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