package com.amarcade.applicada.kamiproject; import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; /** * Created by Mansoor on 17/03/2016. */ 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 + "\";"); } public String showNumbers() { SQLiteDatabase db = getWritableDatabase(); String Number = ""; String query="SELECT * FROM"+TABLE_RejectList+"WHERE"+COLUMN_NUMBER+"=\""+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; } }
String query = "CREATE TABLE "+TABLE_RejectList+"("+ COLUMN_NUMBER+"TEXT PRIMARY KEY);";
COLUMN_NUMBER
"TEXT"
String query = "CREATE TABLE "+TABLE_RejectList+"("+ COLUMN_NUMBER+" TEXT PRIMARY KEY);";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)