Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
swdev:android:database_sqlite [2018/04/30 09:04]
smayr [Database Utils] 		swdev:android:database_sqlite [2018/05/02 20:30] (current)
smayr [Database Utils]
Line 1: Line 1:
 = Database: SQLite = = Database: SQLite =
 ==== DB Connector ==== ==== DB Connector ====
-Download the appropriate Java database connector: +When using the built-in ''android.database.sqlite'' library, there is not need to add an additional database connector. 
-  * [[https://github.com/xerial/sqlite-jdbc|Download JDBC Connector library]]. +
-  * Extract JAR file to some folder. +
-  * Add JAR file as module: ''app'', right-click then ''New'' > ''Module'', then select 'Import .JAR/.AAR Package', and find JAR file. +
-  * JAR package should be now listed under the project Gradle Scripts: ''build.gradle (sqlite-jdbc-3.20.0)''. +
-  * If there is an error including the JAR package, try the following: +
-    * In ''settings.gradle (Project Settings)'', add references to the sqlite-jdbc: <code bash> +
-include ':app' +
-include ':sqlite-jdbc-3.20.0' +
-</code> +
-  * Sync project (File > Sync Project with Gradle Files). +
-  * Add ''sqlite-jdbc'' module as dependency to ''app'' module: +
-    * Right-click on the ''app'' module folder, and select "Open Module Settings" (F4). +
-    * In the top left navigation pane of the "Project Structure" window, go to category "Modules" and select tab "Dependencies". +
-    * Click on the green plus (+), and select 'Module Dependencies'. Select the ''sqlite-jdbc'' module. +
-    * Click OK, and close all the opened windows. A synchronization process should take place once more. +
-  * If there is an error including the JAR package, try the following: +
-    * In ''build.gradle (Module:app)'', add references to compile ''sqlite-jdbc'' under dependencies: <code bash> +
-dependencies { +
-  //... +
-  compile project(':sqlite-jdbc-3.20.0') +
-} +
-</code> +
-  * If succesfull, under the ''app'' module folder there should be a ''sqlite-jdbc'' module folder. +
-  * Include the classes required in your code.+
  
  
Line 246: Line 222:
         //String selection = DbContract.TeamEntry.COL_NAME + " = ?";         //String selection = DbContract.TeamEntry.COL_NAME + " = ?";
         //String[] selectionArgs = { "My Team" };         //String[] selectionArgs = { "My Team" };
 +        String selection = null;         // no filters
 +        String[] selectionArgs = null;   // no filters
  
         // How you want the results sorted in the resulting Cursor         // How you want the results sorted in the resulting Cursor
Line 254: Line 232:
                 DbContract.TeamEntry.TABLE_NAME,   // The table to query                 DbContract.TeamEntry.TABLE_NAME,   // The table to query
                 projection,             // The array of columns to return (pass null to get all)                 projection,             // The array of columns to return (pass null to get all)
-                //selection,              // The columns for the WHERE clause +                selection,              // The columns for the WHERE clause 
-                null, +                selectionArgs,          // The values for the WHERE clause
-                //selectionArgs,          // The values for the WHERE clause +
-                null,+
                 null,                   // don't group the rows                 null,                   // don't group the rows
                 null,                   // don't filter by row groups                 null,                   // don't filter by row groups
Line 294: Line 270:
         //String selection = DbContract.TeamEntry.COL_NAME + " = ?";         //String selection = DbContract.TeamEntry.COL_NAME + " = ?";
         //String[] selectionArgs = { "My Team" };         //String[] selectionArgs = { "My Team" };
 +        String selection = null;         // no filters
 +        String[] selectionArgs = null;   // no filters
  
         // How you want the results sorted in the resulting Cursor         // How you want the results sorted in the resulting Cursor
Line 303: Line 281:
                 projection,             // The array of columns to return (pass null to get all)                 projection,             // The array of columns to return (pass null to get all)
                 //selection,              // The columns for the WHERE clause                 //selection,              // The columns for the WHERE clause
-                null, 
                 //selectionArgs,          // The values for the WHERE clause                 //selectionArgs,          // The values for the WHERE clause
-                null, 
                 null,                   // don't group the rows                 null,                   // don't group the rows
                 null,                   // don't filter by row groups                 null,                   // don't filter by row groups
Line 408: Line 384:
  
                 Intent showRubricActivity = new Intent(getApplicationContext(), RobotRubricActivity.class);                 Intent showRubricActivity = new Intent(getApplicationContext(), RobotRubricActivity.class);
-                showRubricActivity.putExtra("com.voirtech.roboticsleague.TEAM_ID", (position+1)+""); +                showRubricActivity.putExtra("com.acme.roboticsleague.TEAM_ID", (position+1)+""); 
-                showRubricActivity.putExtra("com.voirtech.roboticsleague.TEAM_INDEX", position);+                showRubricActivity.putExtra("com.acme.roboticsleague.TEAM_INDEX", position);
                 startActivity(showRubricActivity);                 startActivity(showRubricActivity);
             }             }
Line 519: Line 495:
   * [[https://developer.android.com/training/data-storage/sqlite|Data Storage: SQLite]]   * [[https://developer.android.com/training/data-storage/sqlite|Data Storage: SQLite]]
   * [[https://developer.android.com/training/data-storage/room|Data Storage: Room]]   * [[https://developer.android.com/training/data-storage/room|Data Storage: Room]]
 +  * [[https://dzone.com/articles/create-a-database-android-application-in-android-s|Create a database Android application]]
swdev/android/database_sqlite.1525093463.txt.gz · Last modified: 2018/04/30 09:04 by smayr
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International


  • Show page
  • Old revisions
  • Backlinks
  • Recent Changes
  • Media Manager
  • Sitemap