8:38 - Layout 18:20 - Data Model 22:02 - Button Click Listeners 32:07 - SQLite Open Helper Class 40:58 - Create New Tables with onCreate Method 58:25 - SELECT * FROM table 1:12:00 - Set Data In a ListView 1:19:37 - Delete a Record
I'm not usually one to comment on videos, but this is by far the best coding teacher I've ever seen on youtube. What I like most is that he shows you how to use the documentation as a guide for development, because no one has an encyclopedic knowledge base of code.
Yeah, hes beter than most of the cluster f@$%s out there...BUT. as good as he is, what pisses me off about his tutorials is when he forgets to go into some essential details about the documentation and how different sections of it apply to different SDK versions or API levels
@@mohamedmire8646 From my experience, a "trained proffessor" is rarely equal to a trained teacher in their pedagogical approach. In fact, most professors have no training at all in pedagogics and tend to just monotonously read some high level facts off of their screen without explaining the base concepts. Sometimes they don't even make and update their slides themselves. And university students are usually expected to learn those basic things in their own time or in tutoriums led by older students. So in other words: this guy is better than most not just on YT because he has both the talent and the wish to teach. :)
I've just completed my 19min and all works perfect. I'll watch & follow along this vid repeatedly for 3 times and believe you me, I'll build my first Booking app from this course. Lots of appreciation from Kenya... You are a great tutor...👏👏👏👏👏👏👏👏👏
Normally I spend my time rifling through 10 minute videos but this was well worth taking the time to sit down and watch in full. Thanks so much! Very helpful!
This is amazing. I've been trying to figure out SQL databases but all other tutorials have been lackluster and confusing. This is the first one that has made sense. Thank you!!!
If you experience the db is not in the same path, you can use this code to get the right path to the db in the console. String dbPath = getDatabasePath("bar_rater.db").getAbsolutePath(); System.out.println(dbPath); . Great video thx!
9:06 Part I - Layout 18:59 Part II - Data Model 22:35 Part III - Button Click Listeners 32:36 Part IV - SQLite Open Helper Class 41:27 Part V - Create New Tables with the OnCreate Method 58:54 Part VI - Pull Data from Database (Select * From Table) 1:12:31 Part VII - Set Data in a ListView 1:20:07 Part VIII - Delete a Record 1:26:46 Challenge
Came here to learn about SQLite, and learned about a lot of cool features for refactoring and debugging in Android Studio. Great teacher and great video!
9:08 Layout 18:51 Data Model 22:34 Button Click Listeners 32:37 SQLite Open Helper Class 41:28 Create New Tables with onCreate Method 58:44 SELECT * FROM table @ - Set Data In a ListView @ - Delete a Record
26:54 You have used tools:text = "View All" (This will show the text only in Design window) You have to use android:text = "View All" (This will show "View All" at runtime)
Hey guys, first of all I would like to say that it was a very intuitive video. Thank you. Secondly, I did everything according to the video but the app crashed (probably when entering data into the database) Did anyone else experience this ?
I did everything also. All was working until I got to the point of changing the View All button to show the list instead of the Toast msg. And as a newbie, trying to figure out what went wrong is very difficult.
@@maryannadelman4438 Hey Mary, so, my problem was at the point where we insert the SQL statement into the code . I had left out a comma or something and expected the debugger to pick up on it but it wasn't so it was just crashing .Either than that it worked fine for me. Try to check and compare your code line by line to the original code.
I think the hardest part for a newbie is the first adding. The app was crashing and i didnt get anything on the terminal. I was thinking about the emulator and the switch component is obsolate etc. I know it part of the journey but the code what he writes at 29:00 is here. CustomerModel customerModel = new CustomerModel(-1,et_name.getText().toString(),Integer.parseInt(et_age.getText().toString()),sw_activeCustomer.isChecked()); U guys all doing a nice job here.
Very good video. Really like how you talk through your thought process when using classes that require inputs and making it clear what the current goal is.
Great teacher and tutorial! One of the very few that don't rush things and show you exactly where you are in the code and why you are doing something. I actually laughed with voice on the context (this) part xD Even "funny" videos only make me blow air out of my nose but this was good! Thank you!
At 1:06:18, the professor uses a ternary operator, I would assume to demonstrate the syntax which may be unfamiliar to some people. To add a little bit of clarity on how Java types work, the == operator already returns a boolean value, so x == 1 already returns true or false, no ternary operator needed. While I'm sure the professor is aware, I'd just like to point it out for the people who are still learning Java.
That felling when you watch this video with a cup of coffee having 23+ years of software development experience and understanding what is SQLite. Relaxed.
Great teaching style. I'm a newbie and so far this has helped tremendously. However, I've followed everything exactly and it was working just fine until I got to the last section about changing the View All button to show the list instead of the Toast msg. "ArrayAdapter" is yellowed out and now the app crashes when clicking "view all". Any idea why this would be the case? I'm running Bumblebee version.
i did everything the same as in the video, but after some point that app stopped working as in: it does launch in android studio, it says that the app launched successfully, but on my phone the app dosnt launch, like it crashes instantly, but i have no idea what i did wrong. i checked the code and it seems to be exactly the same as in the video.
Hi, i am up to 1:11:56 on the video when I go to list the entries in the database on the emulator window, it only shows the 1st record. I opened the database using DB Browser SQLite and there are about 20 records in the database. any ideas? kevin rea
not bad. it was getting worse by the end. on 1:23:46 you say, "View view is the ListView", which is not correct, but then later you say that "parent" is ListView so *View view* is the exact item that we click, and *AdapterView parent* is ListView the way you implemented it so ID is incremented every time you click "add" wasn't shown too, which makes no sense for the last part
Very new to android apps and databases, my question is, if I follow what you have done in the above video, and leave out the delete function, can anyone update, add to the same database or is that strictly when you add to db, it only goes to your phone? If I wanted to do a 'universal' db that anyone can add to it, what do I do? Thank you, and also, great video, easy to follow.
Hi Prof I am starter with android. i want to develop an app for sale prodects and i want the user to browse the products offline. i am using remote sql server and i know that i have to use Sqlite for offline work. my difficulties on how to make sync between remote sql server and SQlite. could you please help me on this point
Since "Database" is the Vocab then i am thinking of Android with Like a Cloud Storage in Backpack, but running it on Android? Or at least Viewing, then Powerbank and Solar Panel etc. Ways of Having Voltage. If we Explore on Adventure, Database Storage becomes Important is why, i imagine an Adventure in Future.
Database by Wifi, Bluetooth, if something like PSP(Ad-Hoc)? Or if just "wired wireless"(making wire wireless connection even if can connect by wire like L.A.N)?
"primary key auto increment cannot be used with INTEGER" i tried to use floating point and get this message in the logcat so how to do for floating point?
8:38 - Layout
18:20 - Data Model
22:02 - Button Click Listeners
32:07 - SQLite Open Helper Class
40:58 - Create New Tables with onCreate Method
58:25 - SELECT * FROM table
1:12:00 - Set Data In a ListView
1:19:37 - Delete a Record
Thanks
Thanks man 👍
Thank you very much! I was intimidated by the hour and a half of runtime
Thanks
life saver, thank you very much
I'm not usually one to comment on videos, but this is by far the best coding teacher I've ever seen on youtube. What I like most is that he shows you how to use the documentation as a guide for development, because no one has an encyclopedic knowledge base of code.
Yeah, hes beter than most of the cluster f@$%s out there...BUT. as good as he is, what pisses me off about his tutorials is when he forgets to go into some essential details about the documentation and how different sections of it apply to different SDK versions or API levels
because this is a university preffossor, not just a freelancer RUclipsrs.
He's trainined prof.
@@mohamedmire8646 From my experience, a "trained proffessor" is rarely equal to a trained teacher in their pedagogical approach. In fact, most professors have no training at all in pedagogics and tend to just monotonously read some high level facts off of their screen without explaining the base concepts. Sometimes they don't even make and update their slides themselves. And university students are usually expected to learn those basic things in their own time or in tutoriums led by older students.
So in other words: this guy is better than most not just on YT because he has both the talent and the wish to teach. :)
44:20 "Refactor -> Extract" is now called "Refactor -> Introduce Constant"
also works with 'ctrl + alt + c'
I've just completed my 19min and all works perfect.
I'll watch & follow along this vid repeatedly for 3 times and believe you me, I'll build my first Booking app from this course.
Lots of appreciation from Kenya...
You are a great tutor...👏👏👏👏👏👏👏👏👏
so many clever people on this planet, but not so many be able to share or deliver their knowledge to others like this one, thank you, sir
Went from nothing to everything in an incredibly comprehensive and cohesive manner. Incredible lecture even today; Thank you!
Normally I spend my time rifling through 10 minute videos but this was well worth taking the time to sit down and watch in full.
Thanks so much! Very helpful!
This is the best Android Studio Java tutorial I've seen yet. I'm halfway through developing my first app and I've just learned so much. Boom
This is amazing. I've been trying to figure out SQL databases but all other tutorials have been lackluster and confusing. This is the first one that has made sense. Thank you!!!
If you experience the db is not in the same path, you can use this code to get the right path to the db in the console.
String dbPath = getDatabasePath("bar_rater.db").getAbsolutePath();
System.out.println(dbPath); . Great video thx!
Thank you man, you saved a lot of my time
9:06 Part I - Layout
18:59 Part II - Data Model
22:35 Part III - Button Click Listeners
32:36 Part IV - SQLite Open Helper Class
41:27 Part V - Create New Tables with the OnCreate Method
58:54 Part VI - Pull Data from Database (Select * From Table)
1:12:31 Part VII - Set Data in a ListView
1:20:07 Part VIII - Delete a Record
1:26:46 Challenge
This one makes more sense
Came here to learn about SQLite, and learned about a lot of cool features for refactoring and debugging in Android Studio. Great teacher and great video!
I took his class when I attended GCU. He was great.
One of the best video on RUclips for android sqlite database..
9:08 Layout
18:51 Data Model
22:34 Button Click Listeners
32:37 SQLite Open Helper Class
41:28 Create New Tables with onCreate Method
58:44 SELECT * FROM table
@ - Set Data In a ListView
@ - Delete a Record
Thank you. This tutorial is worth our time. It provides the basic of SQLite with easy-to-follow instructions.
Exclusive video that helped to understand where other videos failed
Good job
GOD bless
As a desktop programmer this video helps me so much to switch to android apps.
Wonderful. Best teacher I've ever seen on RUclips.
26:54
You have used tools:text = "View All" (This will show the text only in Design window)
You have to use android:text = "View All" (This will show "View All" at runtime)
Hey guys, first of all I would like to say that it was a very intuitive video. Thank you. Secondly, I did everything according to the video but the app crashed (probably when entering data into the database) Did anyone else experience this ?
I did everything also. All was working until I got to the point of changing the View All button to show the list instead of the Toast msg. And as a newbie, trying to figure out what went wrong is very difficult.
@@maryannadelman4438 Hey Mary, so, my problem was at the point where we insert the SQL statement into the code . I had left out a comma or something and expected the debugger to pick up on it but it wasn't so it was just crashing .Either than that it worked fine for me. Try to check and compare your code line by line to the original code.
similar problem, had to make spaces inside commas when creating new table
Hello, feeling lucky to found you. You are teaching so professionally like nothing is vague and the concept is also building. Please keep it up :)
One of the best formal way to do this task.
Thank you..
I am so glad that I found this video, the best teacher I found so far!
I think the hardest part for a newbie is the first adding. The app was crashing and i didnt get anything on the terminal. I was thinking about the emulator and the switch component is obsolate etc. I know it part of the journey but the code what he writes at 29:00 is here.
CustomerModel customerModel = new CustomerModel(-1,et_name.getText().toString(),Integer.parseInt(et_age.getText().toString()),sw_activeCustomer.isChecked());
U guys all doing a nice job here.
Amazing tutorial as always. Your materials helped me tremendously with several of my university classes. Thank you a thousand times!
WOw! today only I was told in class that we would start sqlite(in python) tomorrow and this appeared I hope this would be helpful for it 🤞🤞
Very good video. Really like how you talk through your thought process when using classes that require inputs and making it clear what the current goal is.
Thank you very much, your teaching skills are amazing. This is one of the best android tutorials I have ever seen.
This tutorial is amazing andget he's really good at teaching
better and more straighforward than my uni teacher, thanks a bunch
Excellent tutorial. A bit incomplete w/o search and update but still extremely informative. Thank you!
this guy is good at teaching people. very nice 🤗🤗
Commenting so I can get back to it tomorrow. ( 58:47 ) Awesome tutorial so far!
Thank you Prof. Sluiter for this excellent tutorial.
Great teacher and tutorial! One of the very few that don't rush things and show you exactly where you are in the code and why you are doing something. I actually laughed with voice on the context (this) part xD Even "funny" videos only make me blow air out of my nose but this was good! Thank you!
What a great teacher. I loved this tutorial ❤ Thanks a lot, Professor Sluiter!
Thanks awesome tutorial, the good thing that you are showing how to use documentation added to that the clear explication
Thank you for all the quality content you produce. You probably contributed more than my teachers toward obtaining my degree.
Thank you for your time. It's great and understandable content. Much better than my lecturer 👩🏫 👨🏫 🧑🏫
Excellent tutorial. It has a very good focus in Code Standards like no other videos. Good job. Thanks.
You explain everything you are doing, Excellent Professor!
You are a great person. I needed it and I found it! So thankful for your job!!!
Big fan of Professor Sluiter.
What a great teacher! All understood, all worked well! Fantastic!!!
It would be very helpful if someone adds the timestamp🙂
At 1:06:18, the professor uses a ternary operator, I would assume to demonstrate the syntax which may be unfamiliar to some people. To add a little bit of clarity on how Java types work, the == operator already returns a boolean value, so x == 1 already returns true or false, no ternary operator needed. While I'm sure the professor is aware, I'd just like to point it out for the people who are still learning Java.
True, ternary operator is not necessary here.
thanks Sir at 16:14 for buttons you could use "Chaining"
My deleteOne function has a problem it keeps crashing whenever I attempt to delete something in my database though I follow all your instructions
Best explanation ever.
Really nice tutorial format. Thank you, very clear explanations!
Best Tutorial Ever !!!!!!!!!!!!!!!!!!!!!!!!!!
thanks very much sir please can u show us how to remove CustomerModel from list view and share search and add image as well
Very detailed...i loved every bit of it. Thanks guys
I just binge watch freecodecamp, but I learn a lot.
android studio has it's own database inspector
If you are reading this God bless you and have a wonderful day and stay safe ❤️🥰
Thank You 😊
im not going to give you like but thanks :)
Thank you ba HA SHAM AHAYAH same to you ba HA SHAM YASHAYAH
Same applies to You dear, the feelings are mutual, Jumma Mubarak ❤
Sir can u make one video on payroll management system with database connectivity. your concent are really amazing.I want to learn more...
Great video, thank you! Can you make a video where you show how to implement the search function for the database in the app? :)
That felling when you watch this video with a cup of coffee having 23+ years of software development experience and understanding what is SQLite. Relaxed.
Mind blowing tutorial
TOP CLASS TEACHER!!! Thank you Sir!
48:50 getWritable()
51:25 insert
1:00:54 select *
best tutorial ever
Great teaching style. I'm a newbie and so far this has helped tremendously. However, I've followed everything exactly and it was working just fine until I got to the last section about changing the View All button to show the list instead of the Toast msg. "ArrayAdapter" is yellowed out and now the app crashes when clicking "view all". Any idea why this would be the case? I'm running Bumblebee version.
now I understand a lot of fundamental things, thanks a lot, by the way: You rock!
love the way you teach sir #BestTeacherHaveEverSeen
I have a quick question;
Is it a must to install XAMPP for AndroidStudio to be complete?
Thanks a lot Mr. Sluiter for this very usefull video. Is the code of the program available to download?
Keep up the amazing work my friend!
Thanks very much, awesome tutorial
Thank you so much for providing such cool valuable content.
PLEASE...
even if I do not fill anything, it send the data, how can I do not accept if the fields are empty?
I'm Brazilian, sorry for any mistake.
Add NOT NULL after data type when creating the table
Wow, this was a beautiful one!
hi thanks due to your excellent video , but in btn_viewAll.setOnClickListener ((v) → { how to write forward Arrow symbol ?
Great ! Thanks from Brazil!
Awesome tutorial, thank you so much for this!
Thanks for teaching us
this is a great tuto but there is a little mistake. Maybe due to video recorder.
i did everything the same as in the video,
but after some point that app stopped working as in:
it does launch in android studio, it says that the app launched successfully,
but on my phone the app dosnt launch, like it crashes instantly,
but i have no idea what i did wrong.
i checked the code and it seems to be exactly the same as in the video.
Hi, i am up to 1:11:56 on the video
when I go to list the entries in the database on the emulator window, it only shows the 1st record.
I opened the database using DB Browser SQLite and there are about 20 records in the database.
any ideas?
kevin rea
Where can I find the video about Room that he is talking about at the end ?
not bad. it was getting worse by the end. on 1:23:46 you say, "View view is the ListView", which is not correct, but then later you say that "parent" is ListView
so *View view* is the exact item that we click, and *AdapterView parent* is ListView
the way you implemented it so ID is incremented every time you click "add" wasn't shown too, which makes no sense for the last part
CUSTOMER_TABLE + " (" + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT.
Very new to android apps and databases, my question is, if I follow what you have done in the above video, and leave out the delete function, can anyone update, add to the same database or is that strictly when you add to db, it only goes to your phone? If I wanted to do a 'universal' db that anyone can add to it, what do I do? Thank you, and also, great video, easy to follow.
it is very important tutorial i appreciate u
Thank you very much. Great Video. Looking forward to watch awesome content like this.
Hi Prof
I am starter with android.
i want to develop an app for sale prodects and i want the user to browse the products offline.
i am using remote sql server and i know that i have to use Sqlite for offline work.
my difficulties on how to make sync between remote sql server and SQlite.
could you please help me on this point
Love you freecodecamp
How can i search to particular matches Strings? (not only full matches)
amazing , but i think ViewList btn feature is useless after enhance the code at the end :)
Is it possible that when a checkbox for example is not checked instead of showing false to not show that entity at all.
Amazing! It was very useful! Thank you so much!
Since "Database" is the Vocab then i am thinking of Android with Like a Cloud Storage in Backpack, but running it on Android? Or at least Viewing, then Powerbank and Solar Panel etc. Ways of Having Voltage. If we Explore on Adventure, Database Storage becomes Important is why, i imagine an Adventure in Future.
Database by Wifi, Bluetooth, if something like PSP(Ad-Hoc)? Or if just "wired wireless"(making wire wireless connection even if can connect by wire like L.A.N)?
hello at 56:46 i couldnt find my file? is there anyone could help me to find the file that i created.Thanks
Nice explanation
26:44 he add the button text name in tools atttribute of xml it is onlty visible in the xml layout not in application
thank you man it was really good
this is what i am trying to do..
creating an app that can refer data from a database..
meaning loaded from hard disk..
not from RAM
@57:02 i only have two files instead of three .db and .db-journal instead of 1.".db", 2. " .db-shm", and "db-wal"
"primary key auto increment cannot be used with INTEGER" i tried to use floating point and get this message in the logcat so how to do for floating point?
Thanks a lot!
It worked amazing