StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19263141
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-10-09T04:28:50.770
FavoriteCount
0
LastActivityDate
2013-10-09T04:28:50.770
LastEditDate
LastEditorUserId
0
OwnerUserId
1374416
ParentId
19263028
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
There are various way in populating a database. What I do is I create an <code>insert(ObjectType objectName)</code> in the DBAdapter Class. That being said, I create an object class and for this example, I'm going to use Authorized Personnel <pre><code>public class AuthorizedPersonnelClass { private String _id; private String Last_Name; private String Middle_Name; private String First_Name; private String Store_ID; private String Status; private String New_Personnel; //of course insert your 2 constructors and getter setter methods here } </code></pre> In my DBAdapter, I'll create the <code>insert(AuthorizedPersonnelClass authorizedPersonnel)</code> method to handle the data insertions: <pre><code>public long addPersonnel(AuthorizedPersonnelClass authorizedPersonnel){ ContentValues values = new ContentValues(); values.put(AUTHORIZEDPERSONNEL_ID, authorizedPersonnel.get_id()); values.put(L_NAME_AUTHORIZED_PERSONNEL, authorizedPersonnel.getLast_Name()); values.put(M_NAME_AUTHORIZED_PERSONNEL, authorizedPersonnel.getMiddle_Name()); values.put(F_NAME_AUTHORIZED_PERSONNEL, authorizedPersonnel.getFirst_Name()); values.put(STATUS, authorizedPersonnel.getStatus()); values.put(STORE_ID, authorizedPersonnel.getStore_ID()); values.put(NEW, authorizedPersonnel.getNew_Personnel()); return this.mDB.insert(TABLE_AUTHORIZED_PERSONNEL, null, values); } </code></pre> And from there, let's say I want to populate entries in my <code>onCreate()</code> function or in a button call, I'll just do as such: <pre><code>//instantiate a global variable for the DBAdapter DBAdapter db = new DBAdapter(this); //then if you want to insert db.insert(new AuthorizedPersonnelClass( /*insert variables here*/ )); </code></pre> Of course these values may be hard coded or user input (just use EditTexts and extract the Strings and use them there). Here, I used the <code>ContentValues</code> example because it's easier for beginners to use as opposed to doing a rawQuery Insert statement which may get confusing.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPopulating SQLite Database
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USRazgriz
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COThank you very much Razgriz. It is really helpful. Can I have an explanation of why should we use these different classes ? Is it for increasing performance of the application ?
 singulars
 PostPostId
 PO
 UserUserId
 USRose18

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.