#Sqlite database in android how to#

So let's create a new method will be also a public method and it will return nothing so void. Step 10) Now we want to shows all the data. Note: Just give double line break to the last column so that next data is printed, it is printed after line break So the index of ID will be 0, index of the name will be 1, index of the surname will be 2 and index of marks will be 3. first was ID, the second was name, third was a surname and fourth was marks. And if you remember our table was containing four columns. So the index of the column starts from zero. And In order to append the result, we will write the name of our columns and then the index of the column. Step 9) Then we are going to get the result and we will store it in the buffer. Step 8) If there is no result then we are going to show arrow and return, otherwise if there is some other result then we are going to create some string buffer and then we are going to display this data, so we are going to create and instance of string buffer and then we are going to get all the data one by one using this RES object and how we can do it? we can use a while loop and as a condition of this while loop we can take this RES object and we can call a method move to next. From this get all data, by querying to the database. This is the result count we are getting, if this is equal to 0, then it means that there is no data available for us. If we call this 'res' object and we can get the count of the lines. And we are going to save it as cursor because it returns as an object of the cursor. So we will use the instance of our database helper class which is 'mydDb'. Step 7) Now we are going to get all data using this function which we have just created get all data. Let's create a method, it will be a public method which will take no argument and in here we can call the object of our view all button and we can call set on click listener, set on click listener and inside this we will create a new on click listener and when this button is clicked we want to perform some action. Step 6) And now once we have casted our button we can use the button object to call set on click listener. java class and in here, first of all, we will create the variable for view all button and also we will cast this button. Step 5) Now we are going to our main activity.

#Sqlite database in android how to#

Read Here About How to insert data into SQLite database in Android

So you can see here we are querying the database and the result we are storing it in the cursor instance and using this we have an access to our data. This cursor class is the interface which provides the random read-write access to your result okay. Note:В (*) asterisk stands for all fromВ table.ДЄnd now we just need to return the instance of the cursor which is RES. The table an argument which we are going to pass it as null for now. So this is a simple query we going to write And if you know how to query SQLite database, you may know how to query all the data from the table. Step 4) Then we will create an instance of our curser class and name it as, for examples, 'rest' for result and then we will take an instance of our database and call a raw query on this database so raw query. Step 3) Now weвЂ™re going to create the instance of database class just as we have done in the previous tutorial. This curser will show some error so you just need to press alt+enter to import the class which is curser class. So we are going to go to our database helper class and inside this database helper class we are going to create a new method and this method we are going to call as get all data which will be a public method and its going to return a class or an instance of a class called curser. Step 2) Now once our button is created what weвЂ™re going to do is we re going to create a method to get all the table data. So we change the text as view all and the button ID also IвЂ™m going to change as button. Step 1) First of all weвЂ™re going to take a button and this button we are going to use to view all data. Please follow the steps below in order to get all data from SQLite database table and show it on your Android: Before starting this Tutorial you should know