Android Open Source - help.moto59.ru Db Helper






From Project

Back to project page help.moto59.ru.

License

The source code is released under:

GNU General Public License

If you think the Android project help.moto59.ru listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

package ru.moto59.help;
/* w  ww . j a v  a  2 s  . c o  m*/
import java.util.Calendar;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

  class DBHelper extends SQLiteOpenHelper {

    public DBHelper(Context context) {
      // ??????????? ???????????
      super(context, "helpmoto59ruDB", null, 1);
    }

    public String getPhone() {
      SQLiteDatabase db = this.getWritableDatabase();
      Cursor c = db.query("phone", null, "_id=1", null, null, null, null);
      
      if (c.moveToFirst()) {
            int idx = c.getColumnIndex("phone");
            String phone = c.getString(idx);
            return phone;
    }
      
      return "";
    }

    public boolean needToSplashRules() {
      SQLiteDatabase db = this.getWritableDatabase();
      Cursor c = db.query("rules", null, "_id=1", null, null, null, null);
      
      if (c.moveToFirst()) {
            int idx = c.getColumnIndex("rules");
            int rules = c.getInt(idx);
            if (rules>0) { return true; }
            else {return false;}
    }
      
      return false;
    }
    
    
    
    @Override
    public void onCreate(SQLiteDatabase db) {
      
      ContentValues cv = new ContentValues();

      // ????? ???????? ??? ???????? SMS
      db.execSQL("create table phone ("
              + "_id integer primary key," 
              + "phone text"
              + ");");
      
      // ????????????, ??? ??????? ???????? ? ??????? ? _id=1
      cv.put("_id", 1);
      cv.put("phone", "9194886172"); // ??? "+7" !!!
      db.insert("phone", null, cv);  
      
      // ?????????? ?? ??????? ??? ???????
      db.execSQL("create table rules ("
              + "_id integer primary key," 
              + "rules int"
              + ");");
      
      // ????????????, ??? ???????? ? ??????? ? _id=1
      cv.clear();
      cv.put("_id", 1);
      cv.put("rules", 1); 
      db.insert("rules", null, cv);  
      
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
  }




Java Source Code List

ru.moto59.help.AnotherMsgActivity.java
ru.moto59.help.DbHelper.java
ru.moto59.help.MainActivity.java
ru.moto59.help.ThreadSendSMS.java