Databases
StackOverflow2013
Postsdbo
POhow to compare database insert values with other values
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POhow to compare database insert values with other values
    primarykey
    data
    text
    <p>below is my code i follow this link <a href="https://stackoverflow.com/questions/17269318/how-to-compare-values-with-database-values">how to compare values with database values</a> and customize my code i just want to display only thats name in database which user insert in database but is show my error in helper class in getAllApps method The method getString(int) in the type Cursor is not applicable for the arguments (String)</p> <pre><code> import android.database.sqlite.SQLiteOpenHelper; public class DatabaseHandler extends SQLiteOpenHelper { // All Static variables // Database Version private static final int DATABASE_VERSION = 1; // Database Name private static final String DATABASE_NAME = "contactsManager"; // Contacts table name private static final String TABLE_CONTACTS = "contacts"; // Contacts Table Columns names private static final String KEY_ID = "id"; private static final String KEY_NAME = "name"; //private static final String KEY_PH_NO = "phone_number"; public DatabaseHandler(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); } // Creating Tables @Override public void onCreate(SQLiteDatabase db) { // String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "("+ KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT,"+ KEY_PH_NO + " TEXT" + ")"; String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "("+ KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT" + " UNIQUE " + ")"; db.execSQL(CREATE_CONTACTS_TABLE); } // Upgrading database @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // Drop older table if existed db.execSQL("DROP TABLE IF EXISTS " + TABLE_CONTACTS); // Create tables again onCreate(db); } /** * All CRUD(Create, Read, Update, Delete) Operations */ // Adding new contact void addContact(Contact contact) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(KEY_NAME, contact.getName()); // Contact Name // values.put(KEY_PH_NO, contact.getPhoneNumber()); // Contact Phone // Inserting Row db.insert(TABLE_CONTACTS, null, values); db.close(); // Closing database connection } // Getting single contact Contact getContact(int id) { SQLiteDatabase db = this.getReadableDatabase(); Cursor cursor = db.query(TABLE_CONTACTS, new String[] { KEY_ID, KEY_NAME }, KEY_ID + "=?", new String[] { String.valueOf(id) }, null, null, null, null); if (cursor != null) cursor.moveToFirst(); Contact contact = new Contact(Integer.parseInt(cursor.getString(0)), cursor.getString(1)); // return contact return contact; } // Getting All Contacts public List&lt;Contact&gt; getAllContacts() { List&lt;Contact&gt; contactList = new ArrayList&lt;Contact&gt;(); // Select All Query String selectQuery = "SELECT * FROM " + TABLE_CONTACTS; SQLiteDatabase db = this.getWritableDatabase(); Cursor cursor = db.rawQuery(selectQuery, null); // looping through all rows and adding to list if (cursor.moveToFirst()) { do { Contact contact = new Contact(); contact.setID(Integer.parseInt(cursor.getString(0))); contact.setName(cursor.getString(1)); //contact.setPhoneNumber(cursor.getString(2)); // Adding contact to list contactList.add(contact); } while (cursor.moveToNext()); } // return contact list return contactList; } // Updating single contact public int updateContact(Contact contact) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(KEY_NAME, contact.getName()); // values.put(KEY_PH_NO, contact.getPhoneNumber()); // updating row return db.update(TABLE_CONTACTS, values, KEY_ID + " = ?", new String[] { String.valueOf(contact.getID()) }); } // Deleting single contact public void deleteContact(Contact contact) { SQLiteDatabase db = this.getWritableDatabase(); db.delete(TABLE_CONTACTS, KEY_ID + " = ?", new String[] { String.valueOf(contact.getID()) }); db.close(); } public int deleteContact() { try { SQLiteDatabase db = this.getWritableDatabase(); return db.delete(TABLE_CONTACTS, null, null); } catch (Exception e) { e.printStackTrace(); } return 0; } // Getting contacts Count public int getContactsCount() { String countQuery = "SELECT * FROM " + TABLE_CONTACTS; SQLiteDatabase db = this.getReadableDatabase(); Cursor cursor = db.rawQuery(countQuery, null); cursor.close(); // return count return cursor.getCount(); } public ArrayList&lt;String&gt; getAllApps() { String selectQuery = "SELECT * FROM table"; ArrayList&lt;String&gt; apps = new ArrayList&lt;String&gt;(); SQLiteDatabase db = this.getWritableDatabase(); Cursor cursor = db.rawQuery(selectQuery, null); // looping through all rows and adding to list if (cursor.moveToFirst()) { do { apps.add(cursor.getString( KEY_NAME)); } while (cursor.moveToNext()); } // return list return apps; } } </code></pre> <p>And My activity Class</p> <pre><code>public class PlayStoreApps extends Activity implements OnItemClickListener { /* whether or not to include system apps */ private static final boolean INCLUDE_SYSTEM_APPS = false; DatabaseHandler db; private ListView mAppsList; private AppListAdapter mAdapter; private List&lt;App&gt; mApps; String APKFilePath = "mnt/sdcard/foldername/"; /** Called when the activity is first created. */ @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.games); db = new DatabaseHandler(this); Button AddMore = (Button) findViewById(R.id.AddMore); AddMore.setOnClickListener(new OnClickListener() { public void onClick(View view) { // Intent intent = new Intent(FunActivity.this, // SdcardAPkMgr.class); // startActivity(intent); } }); mAppsList = (ListView) findViewById(R.id.appslist); mAppsList.setOnItemClickListener(this); mApps = loadInstalledApps(INCLUDE_SYSTEM_APPS); mAdapter = new AppListAdapter(getApplicationContext()); mAdapter.setListItems(mApps); mAppsList.setAdapter(mAdapter); new LoadIconsTask().execute(mApps.toArray(new App[] {})); } public void onItemClick(AdapterView&lt;?&gt; parent, View view, int position, long id) { final App app = (App) parent.getItemAtPosition(position); AlertDialog.Builder builder = new AlertDialog.Builder(this); String msg = app.getTitle() + "\n\n" + "Version " + app.getVersionName() + " (" + app.getVersionCode() + ")" + (app.getDescription() != null ? ("\n\n" + app .getDescription()) : ""); builder.setMessage(msg) .setCancelable(true) .setTitle(app.getTitle()) .setIcon(mAdapter.getIcons().get(app.getPackageName())) .setPositiveButton("Launch", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int id) { // start the app by invoking its launch intent Intent i = getPackageManager() .getLaunchIntentForPackage( app.getPackageName()); try { if (i != null) { startActivity(i); } else { i = new Intent(app.getPackageName()); startActivity(i); } } catch (ActivityNotFoundException err) { Toast.makeText(PlayStoreApps.this, "Error launching app", Toast.LENGTH_SHORT).show(); } } }) .setNegativeButton("Cancel", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int id) { dialog.cancel(); } }); AlertDialog dialog = builder.create(); dialog.show(); } private List&lt;App&gt; loadInstalledApps(boolean includeSysApps) { List&lt;App&gt; apps = new ArrayList&lt;App&gt;(); // the package manager contains the information about all installed apps PackageManager packageManager = getPackageManager(); List&lt;PackageInfo&gt; packs = packageManager.getInstalledPackages(0); // PackageManager.GET_META_DATA for (int i = 0; i &lt; packs.size(); i++) { PackageInfo p = packs.get(i); ApplicationInfo applicationInfo = p.applicationInfo; String name = packageManager.getApplicationLabel(applicationInfo) .toString(); List arraylist = db.getAllApps(); if (arraylist.contains(p.packageName)) { App app = new App(); app.setTitle(p.applicationInfo.loadLabel(packageManager) .toString()); app.setPackageName(p.packageName); app.setVersionName(p.versionName); app.setVersionCode(p.versionCode); CharSequence description = p.applicationInfo .loadDescription(packageManager); app.setDescription(description != null ? description.toString() : ""); apps.add(app); // } } } return apps; } /** * An asynchronous task to load the icons of the installed applications. */ private class LoadIconsTask extends AsyncTask&lt;App, Void, Void&gt; { @Override protected Void doInBackground(App... apps) { Map&lt;String, Drawable&gt; icons = new HashMap&lt;String, Drawable&gt;(); PackageManager manager = getApplicationContext() .getPackageManager(); for (App app : apps) { String pkgName = app.getPackageName(); Drawable ico = null; try { Intent i = manager.getLaunchIntentForPackage(pkgName); if (i != null) { ico = manager.getActivityIcon(i); } } catch (NameNotFoundException e) { Log.e("ERROR", "Unable to find icon for package '" + pkgName + "': " + e.getMessage()); } icons.put(app.getPackageName(), ico); } mAdapter.setIcons(icons); return null; } @Override protected void onPostExecute(Void result) { mAdapter.notifyDataSetChanged(); } } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USNice Guy
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTDuplicate
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POhow to compare database insert values with other values
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POhow to compare database insert values with other values
      1. This table or related slice is empty.
      1. VTClose
    3. VO
      singulars
      1. POhow to compare database insert values with other values
      1. This table or related slice is empty.
      1. VTClose
    1. COi just wants to display only thats apps namme in list view which are present in database
      singulars
      1. POhow to compare database insert values with other values
      1. USNice Guy
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload