Databases
StackOverflow2013
Postsdbo
POwhere to put the file from sqlitedatabase in our app
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POwhere to put the file from sqlitedatabase in our app
    primarykey
    data
    text
    <p>I created one app for database which contains a student table and 3 fields in it, but I don't know how to add the file in the app to the <code>sqlite database</code>.</p> <p><strong>database helper:</strong></p> <pre><code> public class DatabaseHelper extends SQLiteOpenHelper { public static final String DATA_BASE="Mydatabase.db"; public static final String TABLE_NAME="Student"; public static final int DATABASE_VERSION =1; public DatabaseHelper(Context context) { super(context, DATA_BASE, null, DATABASE_VERSION); } @Override public void onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE " + TABLE_NAME + "(Name TEXT, AGE NUMERIC, ADDRESS TEXT)"); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { } } </code></pre> <hr> <p><strong>main activity:</strong></p> <pre><code>public class DatabaseHelper extends SQLiteOpenHelper { public static final String DATA_BASE="Mydatabase.db"; public static final String TABLE_NAME="Student"; public static final int DATABASE_VERSION =1; public DatabaseHelper(Context context) { super(context, DATA_BASE, null, DATABASE_VERSION); } @Override public void onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE " + TABLE_NAME + "(Name TEXT, AGE NUMERIC, ADDRESS TEXT)"); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { } } </code></pre> <hr> <p><strong>display activity:</strong></p> <pre><code> public class DisplayActivity extends Activity { private ArrayList&lt;String&gt; arrayList = new ArrayList&lt;String&gt;(); private SQLiteDatabase Mydatabase; ListView listView; EditText enter; @Override public void onCreate(Bundle b) { super.onCreate(b); setContentView(R.layout.display); listView=(ListView)findViewById(R.id.listView); //OpenAndQueryDatabase try { DatabaseHelper db = new DatabaseHelper(this); //Open the database Mydatabase = db.getWritableDatabase(); Cursor c = Mydatabase.rawQuery( "SELECT * FROM Student", null); if (c != null ) { if (c.moveToFirst()) { do { String Name = c.getString( c.getColumnIndex("Name")); int age = c.getInt( c.getColumnIndex("AGE")); String address = c.getString( c.getColumnIndex("ADDRESS")); arrayList.add("Name : " + Name +"\n"+ "Age : " +age +"\n"+ "Address : " + address+"\n"); }while (c.moveToNext()); } } } catch (SQLiteException se ) { } finally { if (Mydatabase != null) Mydatabase.close(); } //displayResultList listView.setAdapter(new ArrayAdapter&lt;String&gt;(this, android.R.layout.simple_list_item_1, arrayList)); } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSam
    1. USaravind varma
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POwhere to put the file from sqlitedatabase in our app
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COI'm not quite clear on what you want... Your code shows you are creating an empty database... Yet you say you want to copy a file... Did you create the DB outside of your app and now want to load it and use it in your app?
      singulars
      1. POwhere to put the file from sqlitedatabase in our app
      1. USBarak
    2. COno...i created my app..and i want to view it in sqlitedatabase.i inserted the data in emmulator when the app is run..and i get all the data entered in another page in list view.....now i want to see the data entered in SQLite database
      singulars
      1. POwhere to put the file from sqlitedatabase in our app
      1. USaravind varma
 

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