public class MyDBHandler extends SQLiteOpenHelper { private static final int DATABASE_VERSION = 1; private static final String DATABASE_Name = "Kami.db"; public static final String TABLE_RejectList = "RejectList"; public static final String COLUMN_NUMBER = "Number"; public MyDBHandler(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) { super(context, DATABASE_Name, factory, DATABASE_VERSION); } @Override public void onCreate(SQLiteDatabase db) { String query = "CREATE TABLE "+TABLE_RejectList+"("+ COLUMN_NUMBER+" TEXT PRIMARY KEY "+");"; db.execSQL(query); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.execSQL("DROP TABLE IF EXISTS "+TABLE_RejectList); onCreate(db); } public void addNumber(Numbers Number) { ContentValues values=new ContentValues(); values.put(COLUMN_NUMBER,Number.getNumber()); SQLiteDatabase db = getWritableDatabase(); db.insert(TABLE_RejectList, null, values); db.close(); } public void deleteNumber(String Number) { SQLiteDatabase db=getWritableDatabase(); db.execSQL("DELETE FROM" + TABLE_RejectList + "WHERE" + COLUMN_NUMBER + "=\"" + Number + "\";"); db.close(); } public String showNumbers() { SQLiteDatabase db = getWritableDatabase(); String query="SELECT Number FROM "+TABLE_RejectList+" WHERE 1;"; String Number =""; Cursor c = db.rawQuery(query,null); c.moveToFirst(); while(!c.isAfterLast()) { if(c.getString(c.getColumnIndex("Number"))!=null) { Number += c.getString(c.getColumnIndex("Number")); Number += "\n"; } } db.close(); return Number; }
public class ViewNumbers extends AppCompatActivity { MyDBHandler dbHandler; TextView tv; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_view_numbers); dbHandler=new MyDBHandler(this,null,null,1); tv=(TextView) findViewById(R.id.txtShowNumbers); String Numbers = dbHandler.showNumbers(); tv.setText(Numbers); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip