SQLite + Android - Update Table Data (Book Library App) | Part 4

🏆 My Online Courses
⭐Discount Coupon: LAUNCH-STEVDZA-SAN
stevdza-san.com
🐱‍👤 Wanna become a member? Join!
/ @stevdzasan
📸 Instagram
/ stevdza_san
We are going to create a Book Library application. Our application will have all the necessary functionality which every app with database should have. That includes CRUD, or Create, Read, Update and Delete functions. Also I'm going to teach you how to add Recyclerview and display data from our SQLite database in it. We are going to add some animations as well.
Project Files: github.com/ste...
Part 1 (Create Database Schema) - • SQLite + Android - Cre...
Part 2 (Insert Data in Database Table) - • SQLite + Android - Ins...
Part 3 (Display Data in Recyclerview) - • SQLite + Android - Dis...
----------
Part 5 (Delete Table Data) - • SQLite + Android - Del...
Part 6 (Animate Recyclerview) - • SQLite + Android - Ani...
One of the main principles of SQL databases is the schema: a formal declaration of how the database is organized. The schema is reflected in the SQL statements that you use to create your database. You may find it helpful to create a companion class, known as a contract class, which explicitly specifies the layout of your schema in a systematic and self-documenting way.
A contract class is a container for constants that define names for URIs, tables, and columns. The contract class allows you to use the same constants across all the other classes in the same package. This lets you change a column name in one place and have it propagate throughout your code.

[@HausCoding]

If you update data but not change anything. Add code before db.updateData(); in file UpdateActivity.java title=title_input.getText().toString().trim(); author=author_input.getText().toString().trim(); pages=pages_input.getText().toString().trim();

[@andrifirmansaputra409]

Thanks bro 👍

[@HausCoding]

@@rizqinrizwan9388 You're welcome

[@HausCoding]

@@andrifirmansaputra409 yeah youre welcome

[@nancy7092]

OMG! thankyou so much :")))

[@theblaze8643]

thanks :D

[@mazenbinsalem]

Hi Stevdza, Thanx a lot for your awesome, short, fast, clear and useful tutorials,. Keep it up! However @1:31 on MyViewHolder inner class I have used ConstraintLayout for mainLayout instead of LinearLayout as it was the reason why my app crashes whenever I start the app while any data are available on the database. Also, on 10:41 on UpdateActivity you add 3 rows of code after MyDataBaseHelper db.. as following : title = title_input.getText().toString().trim(); author = author_input.getText().toString().trim(); pages = pages_input.getText().toString().trim(); db.update... this code is add but not mentioned. Also, activity_update.xml

[@alanpintor9009]

At minute 2:24, my parameter "int position" does not change to "final int position" and I am getting an error when running the app. Error: java.lang.NullPointerException: Attempt to invoke virtual method 'void android.widget.TextView.setText(java.lang.CharSequence)' on a null object reference Help, please!

[@alanpintor9009]

Solution: For the error message "...null object reference" I corrected my findViewById() reference. For the parameter error, I replace View.OnClickListener() for lambdas

[@FinalTie]

@@alanpintor9009 hey bro I have the same error can you tell me how you corrected it

[@centurionzo1228]

I have the same problem, i could not solved it

[@centurionzo1228]

My app just crashs, I couldn't manage to solve it

[@wheepup8452]

When I select an item in the recyclerView and UpdateActivity is opened it never loads any data. The code is the same. Please help

[@assemabujahal625]

Thanks to you I finished my project 💚💚💚

[@TheTejasDalvi]

when I click on any card , getting all the edittexts empty ,what I suppose to do? Changes in my code- I have made one books class and all data init to use search functionality. And I'm using { Books obj; obj.get(position); string.valueof(obj.getid); } instead of { string.valueof(id.get(position)); } . And I created methods like getid in books class. is this cause of my problem? I coded upto 5:45

[@centurionzo1228]

Hello there, i having problems, for some reason my int position stay in red and don't actomatically change to Final int position, is also don't open the app, it's just don't work

[@minhuyk6vd]

Thanks to you I finished my test ^^

[@StevdzaSan]

Glad to hear that! :)

[@jhazerandrade4120]

How to navigate the database helper class? in the 10:40 - 10:41 seems like magic so fast can't keep up

[@vibhathakur5751]

Unable to add refresh functionality

[@alanpintor9009]

I missed the code change you magically made in minutes 10:40 to 10:41. That was too fast man! lol 😆 I needed to watch the video many times to catch it.

[@StevdzaSan]

You need to stay sharp and focused. 😎

[@funzone9462]

Nice Search option and alphabet a- z list view . Long click to edit data and onclick open Next activity and show details with title , author/description and number . Then user can easily able to access .data

[@StevdzaSan]

I havent added search option in this project, but in some future video I'll do that

[@HereYouGOsino]

is it hard to implement search functionality in this ?

[@shepard_t]

Hi Stevdza-San, thanks for the awesome tutorial. I would like to know what the getAndSetIntentData method would look like if the input is a spinner and I want to change to another spinner item. Many thanks!

[@wheepup8452]

Instead of pressing the recycler view to edit have a button (since it's only 1 person). I did everything the same. The only difference is that I call the updateData function in a different activity. The one that contains the recycler View and the edit Button. Since the onClick is in a different activity (the one that has the button) I didn't do the intents in the CustomAdapter, but in the Activity. they are the same without 'holder' and 'position'. like so: Height = getIntent().getStringExtra("Height"); Now when I enter the info and press update the app crushes. Any ideas? I'm new at coding so I apologise if I didn't explain i very well

[@hunsendrake2535]

is it possible to update only in an specific column?

[@mahararahma]

Hi bro thanks fo the tutorial🙌🏻 it really help alot Send much love for u

[@StevdzaSan]

I'm glad to help!

[@janettaylor260]

Hi Stev, unfortunately as of February 2022 this does not work as getposition is deprecated. Please can you do an update? Thanks

[@StevdzaSan]

My suggestion is to switch to ROOM library. I have a playlist for that as well.

[@roshanm420]

Very useful tutorial thank you sir

[@ankonsarkar9657]

Ho no ... i missed to show Edittext Data getting... 10:40 min update_button.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { //And only then we call this try (MyDatabaseHelper myDB = new MyDatabaseHelper(UpdateActivity.this)) { title = title_input.getText().toString().trim(); author = author_input.getText().toString().trim(); pages = pages_input.getText().toString().trim(); myDB.updateData(id, title, author, pages); } } });

[@thecompilerbro]

Thanks a lot. Now it's updating on clicking the Update button.

[@Waleed_Al-Haidary]

I did everything as explained, just couldn't figure out why the strings such as "title", "author", "pages" has green underline, the app crash when when I click on the item name for the screen that recall the details of the item for update/delete?? any ideas folks.

[@StevdzaSan]

Download the project files which I uploaded on Github and compare with your code.

[@Waleed_Al-Haidary]

​@@StevdzaSan Thank you for your support, I did compared your files on github with my files and found my mistakes, THANKS AGAIN.

[@deveshsingh4214]

from 10:40 to 10:41 ... update_button.setOnClickListener{...} the code changes. This would be causing issues... BTY Its 1 year Old...😂😅

[@juanenriquez2798]

is there a code for me to follow where i could add a button as a counter for the books entered and display the number as well?

[@alexnewcomer475]

At 11:47 onBindViewHolder method is shown and it has been changed since the last time we saw it with the override on click removed and nowhere to be seen. I try to recreate the code you show on the screen and get errors. And when I run my program the values don't show as updated please advise. Thanks.

[@StevdzaSan]

Feel free to download project files and check the code

[@skanerkodowkreskowychqr3794]

Is IT possibile to download all three parts? Update button doesnt work😢

[@cjdrix]

Hello sir, can you help me again? When i click the data in main activity and i want to update the data, it only shows toast message no data.

[@prathamchoreria5674]

any solution to this?

[@HabiburRahman-xs9gb]

very helpful and well explained

[@christianreydoctolero3986]

what is the version of android studio and jdk you are using thank you?

[@papermaker107]

how would you implement update if you arent using auto-incremented id's??

[@shathaalnahdi4823]

Thank you so much 👍🏻

[@vibhathakur5751]

Is there any way to add refresh functionality by editing Android. Manifest file

[@hariprasath4883]

Can I have two fragment class share one layout.xml file??... because both their views add and edit are same so can I reuse it?? Is it possible?

[@miguelangelmunozoscategui8655]

as the onActivityResult would do in a fragment what you explain in minute 12.18 regards

[@tanmoyghosh3103]

At 2:11 when i am going to start the new intent it is showing me an error in calling the intent...please help sir

[@tanmoyghosh3103]

Surrended with array initilisation

[@kazukisenpai2405]

Using arrayList may better

[@MohsenMashkour]

I have done everything but when i press the update button i just see the toast message and nothing is changed in the main activity.

[@reshukumari4429]

Mine2

[@alfidharmawan9115]

See at 10:41, he added new assignment for the string, based on edittext. Maybe you missed that, cause thats my problem too

[@karthi-rt]

I have updated data but there is no update in my data they still remains same

[@gatdet]

Any solution?

[@ShakeelAhmad-sc9gv]

You can get the text from input and then update

[@ShakeelAhmad-sc9gv]

If you don't get new text from input then old data will be updated... because new data is not get that is used in video.. hope you understand

[@meh646]

My bui just speedrunning them tutorials

[@puch9830]

onactivityresult isnt working...any help...i work with fragmetns

[@MdRakibulIslamrockpak]

Greate video, thank you

[@dmitrypobedinski2255]

Hello. This tutorial doesn't work in 2021? A studio 2020.3.1 Jdk 11.0.10

[@sohambtw]

It says no data when i click on a data to edit it

[@Another0neTime]

Excellent

[@phoenixcode8034]

hi Stevdza-San thank you so much for this tutorial , please make a mysql too pleaseee

[@StevdzaSan]

Definitely in the future. Stay tuned 👍

[@HyperActive94]

lol you skipped a whole part you added in the code...

[@nonetoro]

It didnt show any book information since tutorial part3, even add new book data. Anyone knows？

[@curiouslamb8532]

@Sahil Bhandari *Update: add this line inside the onClick method of your Add Button in the MainActivity.java startActivityForResult(intent,1);* I think the problem shows when you press back button from the smartphone navigation itself after adding new record. Pressing back button gets you back to your previous recycler view which is not updated yet. But try pressing the backbutton from the appbar and you will be redirected to an updated recyclerview content. Maybe destroying the main activity after clicking addbutton and relaunching it after clicking save button would fix it. My personal band aid solution is I created an intent in the save button which redirects to the new MainActivity that has updated recyclerview content.

[@marcalestruchgarcia4568]

Hey, why "pages" is initially an integer, but you are able to update it as a string on MyDatabaseHelper.java?

[@mahmoudkhattab4153]

Dont forget at 10.42 your escape this

[@h.r.60]

make a google maps api tutorial please!

[@StevdzaSan]

I will plan that in the future

[@pltsm3970]

Hi sir On Update I just coded the same as yours When i wanna update value it Toasts me successful update but my data does not change even i Restart the app. Please help me

[@aleks2147]

I think he made a mistake. Inside the onClick method of the button update you need to use the TextView.getText() method before calling myDB.updateData (...) to actually get the new updated text

[@SlenderMan4466]

too fast

[@ramazandemir4730]

when im writing this line Intent intent = new Intent(context, UpdateActivity.class); at OnClick method under CustomAdapter class i get this error: Do not treat position as fixed; only use immediately and call `holder.getAdapterPosition()` to look it up later

[@FinalTie]

holder.mainLayout.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { Intent intent = new Intent(context, Update.class); intent.putExtra("id", String.valueOf(person_id.get(holder.getAdapterPosition()))); intent.putExtra("name", String.valueOf(person_name.get(holder.getAdapterPosition()))); intent.putExtra("phone", String.valueOf(person_phone.get(holder.getAdapterPosition()))); intent.putExtra("email", String.valueOf(person_email.get(holder.getAdapterPosition()))); intent.putExtra("location", String.valueOf(person_location.get(holder.getAdapterPosition()))); intent.putExtra("birthday", String.valueOf(person_birthday.get(holder.getAdapterPosition()))); intent.putExtra("hobby", String.valueOf(person_hobby.get(holder.getAdapterPosition()))); intent.putExtra("gender", String.valueOf(person_gender.get(holder.getAdapterPosition()))); } }); hey bro I have the same error can you tell me how you corrected it

[@phlong10102]

@@FinalTie i same bro