Read One Record from SQLite Android Helper

-
This blog is in continuity with my previous two posts which was related to creation of a database helper class and insertion of new data entry into the table. After creating database in android and open the connection we had to add entries into the database. But, as we are already done with the insertion of records into the table. So, now it's time to search for the added record.

So, here we will use PreferenceInfo POJO for assigning retrieved values to the object.

in order to retrieve a stored record into database we must need to provide an identity value which will search the record into table against that id.
public PreferenceInfo getUser(int id){

As I have already mentioned in my previous two blogs; we must need to get a readabledatabase object because here we only need to read a database.

SQLiteDatabase db=null;
// 1. get reference to readable DB
try{
db = this.getReadableDatabase();
}catch (Exception e){
Toast.makeText(currentContext, "database cannot be opened", Toast.LENGTH_LONG);
}

Now like the database we must need to initialize the cursor. Cursor interface provides random read-write access to the result set returned by a database query. So, now we must need to build query:
Cursor cursor =
db.query(REGISTER_TABLE, // a. table
COLUMNS, // b. column names
SECURITY_NUMBER +" = ?", // c. selections
new String[] { String.valueOf(id) }, // d. selections args
null, // e. group by
null, // f. having
null, // g. order by
null); // h. limit

Now, we must need to check for the cursor, if results will be returned then cursor will be populated else it will remain null.
if (cursor != null)

after validating the cursor, we must need to move the cursor to the first row. This method will return false if the cursor is empty. Here, we are retrieving only one record because we know that for each identity only one record exist into the table.
cursor.moveToFirst();

Now we must need to populate the data from table into the POJO and then return the object into that method.
PreferenceInfo preferenceInfo = new PreferenceInfo();

Now we will get the values from the zero-based index of the target column and will set into the relevant property of POJO using the setters.
preferenceInfo.setSecurityNumber(Integer.parseInt(cursor.getString(0)));
preferenceInfo.setEmail(cursor.getString(1));
preferenceInfo.setPassword(cursor.getString(2));
preferenceInfo.setUserName(cursor.getString(3));
preferenceInfo.setMobileNumber(cursor.getString(4));
preferenceInfo.setKeyMessage(cursor.getString(5));

After complete transformation of cursor to object, we will return the object back to the method.
return preferenceInfo;


If you find it helpful kindly click the donate button on the top of page. Also added an attachment of the files
Now, the updated DatabaseHelper file and PreferenceInfo.java file

Comments

Post a Comment

Popular posts from this blog

DDOS (Distributed Denial of Service) Attack in Java

-
We often hear about the word DOS attack on a site, and few people often think like DOS only means Disk Operating System. But, here DOS is something big, and we use it to crash and operational site by consuming the quote of daily or monthly or yearly requests of a site. Here I would like to share a basic program using RMI based bots that will be helpful for reading purpose only. My intention is not to develop hacker but just to give an idea of using RMI in JAVA. First we have created an interface that will be concreted in it's implementation later. But, the main purpose behind creating this interface is just for RMI as the look up functionality of RMI needs an interface instead of complete implementation. import java.rmi.*; // DDOSService Interface // Interface for a RMI service that will actually attack on a target machine public interface DDOSService extends java.rmi.Remote { public String attack ( ) throws RemoteException; } Now this time is just to pro...
Read more

First Formula 1 Car

-
I have seen so many students in my life as I also do some voluntarily advisory service for IT students.  Not, only this but have also tried to promote the work of those students, where I think the work in not extraordinary but, they have the skill-set to do something beyond the thoughts. Well, Pakistan is considered to be the country lives under the threats of terrorist and the people here always talk about the stuff which is not healthy for anyone including themselves. But, if this tail can be considered true then why different countries on the globe, hire the people from Pakistan and India. As everyone is aware that the people here are talented but unfortunately due to project funding issues and the growing country problems people have started migrating to different lands where they can find peace. As the first statement was not a rumor and it's a bitter reality but along with that the people are talented and always try to do something innovated which can't be expect...
Read more

Maven + Struts2 + Spring + Hibernate + Struts2-Convention-Plugin

-
Image
After spending so many days and nights and days again I finally be able to achieve the basic Architecture. Well, the basic architecture was quite simple and you will be able to get a lot of tutorials online about it but, probably they have few things missing (i.e. Maven or sometimes Struts2-Convention-Plugin). Reason behind choosing this structure is to make an easy expandable application structure with an isolation in between layers. Reason Behind: Maven is just used for dependency management of libraries and easy deployment. Struts2  is used for UI. Spring for service layer, as we all know we can easily change implementation which will be helpful for us to entertain the change request. Hibernate for ORM that will play with the database. Directory Structure: Don't worry about such a big directory tree. One by one I will tell you each and everything about it. Before starting everything we will start telling you about the pom that will be required to setup the ...
Read more