Spring Boot CRUD Tutorial with IntelliJ IDEA, MySQL, JPA, Hibernate, Thymeleaf and Bootstrap
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- In this Spring Boot video tutorial, you will learn how to use IntelliJ IDEA for developing a Java web application based on Spring framework in which you will learn to implement the User module with CRUD operations (Create, Retrieve, Update & Delete).
Technologies: Spring Boot Web, Spring Data JPA & Hibernate, MySQL Database, Thymeleaf, HTML5 & Bootstrap, JUnit 5 & AssertJ, Spring Data JPA Test.
Software programs: Java Development Kit (OpenJDK), IntelliJ IDEA Ultimate, MySQL Community Server, MySQL Workbench
Spring Boot E-Commerce Ultimate Course: www.udemy.com/... - Code Real-life Shopping Website with Java and Spring Boot. Full-stack Development. Hands-on Practices. Job-ready Skills.
Timestamps
0:08 - What you will learn
0:53 - User Interface Design - Manage Users
1:49 - Overview Class Diagram
3:57 - Create and Set Up Spring Boot Project
10:38 - Configure Datasource Properties
12:52 - Code Home Page
22:40 - Use Bootstrap for Project
28:57 - Code Data Access Layer for User Module
38:27 - Code Unit Tests for Data Access Layer
56:07 - Code Users Listing Page
1:09:35 - Code Add User Function
1:32:39 - Code Edit/Update User Function
1:43:26 - Code Delete User Function
Get the sample project on GitHub: github.com/codejava-official/spring-boot-crud-intellij/
THANKS.
THANKS.
I dont always comment on TH-cam, but your video is so good for me to understand the basic of thymeleaf and spring boot. I like that you don't edit your contents where there is an error which help others to learn how to resolve those errors. Kudos.
Glad to hear that. I love your comment.
@@CodeJava Thank you for your work. However, the font size is way too small. Please zoom in.
I spent days working on similar tutorials on TH-cam and all of them failed to explain enough to get it actually working. This tutorial was easy to follow and informative and most importantly I was able to finish the whole thing without having to debug it. The most important thing you did here that others failed to do was actually test the database connection before writing hundreds of lines of code only to have it fail when tested. Thanks so much for this video. I learned a lot.
I'm happy that you found this video helpful. Watch more my videos: th-cam.com/users/codejava
Dude you saved my life. Had a project for school and had no idea how to do anything. Watched other tutorials on youtube but they haven't really helped me
glad it helped.
Cảm ơn anh. Hướng dẫn rất chi tiết. Nghe giọng đọc biết ngay anh là người Việt Nam rồi :D hihi
really love Sifu Ha's style. I have followed a couple Sifu Ha's tutorials. Not only learned java, also picked up Sifu's accent. :D
Glad you like them!
Man, u helped me a lot bcoz i was struggling to understand the purposes of those annotations, repository, context etc, i had confusion to tell u the truth but now i understand. Thank man, may God bless you
Glad it helped!
Thank you so much for a great tutorial! Had to re-make the test to be sustainible, but all in all, a really good guide. Thank you and keep up the great work.
Glad it was helpful!
set the @Rollback to true, you will be able to repeat the tests
@timestamp 19:51 if you cannot find compiler.automake.allow.when.app.running, its because they moved it in newer versions of IntelliJ IDEA...Head over to Settings>Advanced Settings then check "Allow auto-make to start even is developed application is running"...it should be under the Compiler section
Great! Thanks for sharing the tip.
Thanks!!
There is no word can represent my appreciation to your great great tutorial. Thank you so much bro!
You're very welcome!
Cảm ơn anh, vì những video rất rất chất lượng ạ, vừa chi tiết vừa dễ hiểu
ko có gì em. A rất vui vì em thấy video này hữu ích.
@@CodeJava Em đang cố gắng theo backend Java spring boot. Hi vọng anh sẽ ra nhiều video chất lượng hơn nữa ạ
for my whole life this will be my 1st youtube comment history ,you save me a on this man , thanks a lot
glad you found this video helpful. Watch more about Spring Boot: th-cam.com/video/zDc63OHY_v8/w-d-xo.html
Thank you, keep going your videous are really helpful, I keep referencing back this video again and again whenever I forget how to set up my mysql.
Great to hear that! You're welcome.
My instructor was never teach me like this, that's why I didn't know How to use Test method, but when I watched your video, It was really helpful and understandable .
I would say Thank you very much. Can you please make one Micro-Services video also?
Glad to hear that. I'll publish videos about microservices in near future.
This is absolutely thorough. I followed from start to finish building the application. Everything worked as you demonstrated. I thank you very much,
Glad it helped!
This is first time I am commenting of TH-cam. I want commend you on this video. This is really good and I learned a lot from you video. Thank you.
Glad it was helpful!
I wish you share the source code , it's really hard to go back and find the specific things.
What a nice video this was! You just saved my time and my project for college. There is just one thing I want to know, because when you do update of user, in my case it does insert of new user, it can't find existing user to merge new data on it, it just inserts new one (which will crash if I dont change email, if it doesnt crash it will create another user). Thanks a lot!
Glad to hear you found this tutorial helpful. Make sure that you put id field in the form, so it will know when to merge and update the data.
@@CodeJava Nice! That worked out. But what about JSP files, If I decide to use them instead of HTML, how I can start using it at this point and can I convert HTML ones to JSP ones?
Hello! I did everything like you and all the things work properly expect for one: when I use 'edit' -> instead of correcting the entry, it's create another one, and even it falls with an error (cause for the same e-mail on the edit page) id continue counts
make sure you have Id of the user in edit form, as an hidden field. So it will update the user's details - not create a new one.
@@CodeJava i got this after open tag
this helps me a lot. tysm
@@rzinnatov This was a year ago, but did the fix work for you? I confirmed that I had the tag @CodeJava mentioned, but in the users.html file, the two hyperlink tags cannot resolve the id in the expression: ${user.id}. I've burned many hours on this issue. Any suggestions?
Hi Nam,
I am enrolled to your course at udemy.
Would you have a tutorial that uses postman/end points?
I am working on a backend project that requires no thymeleaf where i have to demonstrate the use of postman.
Hi Brian. I published some tutorials that use Postman on my blog here: www.codejava.net/rest-api
Also on this channel: th-cam.com/video/XLQxfpDmqbM/w-d-xo.html
Thanks for your great tutorial! It helped me more than 10+ hours courses
Glad it helped! If you want to learn more, consider taking my online course here: www.udemy.com/course/spring-boot-e-commerce-ultimate/?referralCode=3A24FAC7220029CEDFD6
This video is so good and straight forward. Nice one. I have a question = why do you use GetMapping for Updating and Deleting, why not use PutMapping and also DeleteMapping?
it's because hyperlinks cannot send PUT & DELETE requests. It can send GET requests only. If you wish to, you have to write some additional Javascript code for that.
Love and Respect for your contribution Dear Sir - From India
thank you :)
Indeed very useful. Thanks a million and keep coding!
Glad it helped!
Hi, you are doing great videos. I wanted to ask can you add security for this, with roles I mean user can have multiple roles. So when we want add new user or update user also we could give some role for that user. Thanks!
Yes, check this video: th-cam.com/video/p18O0hSmQyM/w-d-xo.html
Thank you for this tutorial, all explained clearly. I coded along with your video, it took me 2-3 day so I can digest your explanations 😄☕ confidence booster.
Do you have another video like this, but using custom queries in the UserRepository?
Glad you enjoyed this video.
Thank you very much, hope the channel grows more and more
Hope so!
Agradecido desde America Latina por este excelente tutorial.
You're welcome :)
I found this video so helpfull, thank u so mucho for making it. Also, u can help me with something? I'm having trouble trying to configure my database, I can use mysql, so Im trying with an Oracle 18c database, but I really dont know how to configure it, can you explain it to me? Or recommend another of your tutorials where you work with an oracle database?
can you check this video th-cam.com/video/ea0HhETxOIs/w-d-xo.html ?
and this one: th-cam.com/video/CCqVKz6RRLs/w-d-xo.html
thanks a lot, i could get clarified all the process, just i have a doubt, how i can implement "findBy" in a costum field, lets say : find by email
just declare a method in the repository interface, something like: Option findByEmail(String email); and Spring Data JPA will generate the SQL statement accordingly.
This was good. Thank you.
Hopefully, one day you would come up with a full project. Or, may be some clone of a web application.
Event if it could be around 6-8 hours long, I believe people would still happy to follow.
There are so many projects like that but with MERN. But I don't see any good Java/Spring full stack project out there.
you can learn developing a full, complete functional e-commerce website in my course here: www.udemy.com/course/spring-boot-e-commerce-ultimate
YOU ARE SUCH A LIFESAVER.
glad it helped :)
This tutorial is godlike bro! Thanks!!!
Glad it helped! Welcome :)
Thanks for your video, that's help me a lot with my project. But there is something that bother me, that the browser seem to not recognise the bootstrap CSS file directory so i can't click on it to check whether or not if the browser could find the bootstrap file. I'm trying to resolve that but the IDE can recognise the file path so i don't know where the problem is ?
Thanks
make sure you tell Spring Security check statics resources by adding this code:
public void configure(WebSecurity web) throws Exception {
web.ignoring().antMatchers("/images/**", "/js/**", "/webjars/**");
}
Great tutorial for me as a beginner in Springboot. Thank you
Glad it was helpful!
Thanks bro it worked ,i have learnt a lot from this tutorial .
Please do more springboot apps
Sure I will. Glad you found this tutorial helpful. Learn more: www.udemy.com/course/spring-boot-e-commerce-ultimate/?referralCode=3A24FAC7220029CEDFD6
Thanks for this video, because this is the best tutorial i can find
Glad it helped!
Thanks a lot for such an informative tutorial. I encountered a bug, the edit functionality is adding a different user with a different userId altogether so its not updating. Kindly look into it
make sure you put a hidden field for user ID in the edit form.
Great tuto. explained in a way anyone can understand, but i came a across a problem
java: bad operand types for binary operator '=='
first type: long
second type:
The Delete part
if (count == null || count == 0)
use Long instead of long for the variable count.
Hello Nam, I hope you are ok? Nam what do you prefer Spring Tool or IntelliJ? Thx a lot
I like both STS and IntelliJ. Which IDE does not matter much.
@@CodeJavaPlease, think of my java shirt as soon as you sell it. Thanks
Rất hay ạ, cảm ơn anh
ko có gì em. Anh có khóa học này: www.udemy.com/course/spring-boot-e-commerce-ultimate
Hi - thank you very much for the Video! Unfortunately I have a Problem with the thymeleaf Expressions in the trainee_form.html - I always get the "cannot resolve" Message. For Example when i call the object th:object="${trainee} or when i call the filed th:field="*{email} - Do you have a solution for this Problem? I spent the last 2 Days trying to figure out a solution but cant find anything...
I think you should follow this tutorial first: th-cam.com/video/-IMvhBWwQrc/w-d-xo.html
cảm ơn anh nha , nghe giọng nói tiếng anh là biết ngay anh là người VN rùi !
You are welcome ☺️
Thanks from Russia!
Welcome! Greetings from Vietnam :)
hello nam since you master these topics very well, you can create a video on how to create a CRUD in Spring boot with upload and update of images please, it would help us a lot to those of us who just started
I have this video which is somewhat close to what you need: th-cam.com/video/-Xf_fbKQit8/w-d-xo.html
If you want to learn full CRUD with images, I recommend you take my course on Udemy: www.udemy.com/course/spring-boot-e-commerce-ultimate
Thanks for the lesson . I really learned alot
Glad it was helpful!
When I run my Auto Configuration file it doesn't work in Spring-Boot app. There is an error "Error starting ApplicationContext....". How can I fix it?
show me the error in detailed
Is it possible to create a CRUD web application in (jsp, servlet) format in IntelliJ IDEA Community Edition , have been looking for this? Any tips or tutorial on this?
check out my written article: www.codejava.net/coding/jsp-servlet-jdbc-mysql-create-read-update-delete-crud-example
Mate you saved my life, Thanks a lot!
Glad it helped!
usefull tutorial thank you bro👍👍👍
glad it help. Check out all of my Spring Boot videos here: th-cam.com/video/zDc63OHY_v8/w-d-xo.html
Thank You So much for the Video. It helped a lot. The Id is printing 1 and then 3. 2 is not printing
You're welcome! It's because the record id 2 was deleted.
@@CodeJava Yes. I've checked my code yesterday. I've got it. Thank You.
Thank you, it has been a great help, greetings from Mexico!
Glad it helped! Greetings from Vietnam :)
Can this be followed and complete using the Comunity edition of InteliJ ?
No, you must use the Ultimate edition for developing Spring projects.
Thank you very much for this helpful project!
Glad it was helpful!
Nice tutorial, can you give me the plugins you use in intellij ? thankyou!
Oh, I don't use any external plugins.
Could u make a CRUD Web Services App with Spring and React JS or Angular ?
yes, will be in future :)
Great tutorial. Thank you so much for this!
Glad it was helpful!
Thank u so much, I benefited a lot.
Glad it helped
Muchas gracias por compartir tu conocimiento mi amigo!!!
de nada.
8:21 How do you have a database tab? There is none when I am working. Is it Ultimate only?
yes, the Ultimate edition has more tools
I dont have the option to add scehmas after connecting to the db, what is the problem?
what do you mean you don't see? Just put the following attribute in the application.properties file:
spring.jpa.hibernate.ddl-auto=update
If ever you have time, could you explain how to save data in uppercase from the user form to the database.
I don't understand what you mean. Why 'uppercase'? Could you explain?
@@CodeJava HI, Thanks for coming back to me and sorry for the vagueness of my question. What I mean is when we save i.e First name let's say "Tina" it is saved in database table as "Tina". How would I code on the application to save on the database "TINA". Very much appreciated if ever you have time.
I thank you very much. I'm having a headache when learning about spring boot. But when I see your video like a drowning man grabs a float :D when Udemy has a certain discount I will buy your course :D. By the way, I am a Vietnamese too.
Great to hear that. I just created a discount coupon for my course here: www.udemy.com/course/spring-boot-e-commerce-ultimate/?couponCode=SPRINGF
Wait to see you in my course :)
@@CodeJava Thanks for your support I bought your course. Hopefully in the future, you can expand more courses such as Design pattern in Java, Microservices. I really hope that will be happen.
@@realtimeactivities7794 Thanks, I'm going to publish more courses in 2022.
Assertions.assertThat(saveduser).isNotNull();is not working in my intelijj that is assertThat is not correct what shall I do
did you try to import the Assertions class from assertj package? AssertJ comes with Spring Boot test by default.
34:50 i am following urs, but my at this 34:50 time the way you load program after clicking crudrepositary doest show in my computer, that accept dialogue box doesnot appear please help
did you hold down Ctrl while clicking on the name?
@@CodeJava thankyou pressing ctrl solves
Hey! A good job! I just have a problem with editting users. When I change some fields f.e. firstname, lastname and tap the "Save" button some error happened (duplicate account). But when i changed just e-mail everything was good and app create a new person. Can u help or explain this problem?
Make sure you have id of the user as a hidden field.
@@CodeJava Oh, yes! I found that! Thanks!
does this work on intellij community edition? or should i buy it
it works on IntelliJ ultimate edition only. You can use ultimate edition freely in 30-minute sessions.
Hi. I watch your spring boot ecommerce tutorial on udemy. Its very educative.
Could you also share how to add dto in the project?
Glad you found this video helpful. Kindly check this video in which you'll see how to create DTOs: th-cam.com/video/y6R3reU1vWE/w-d-xo.html
Question regarding to the UPDATE (PUT) method,if the passed ID is wrong or does not exist,Spring/Hibernate will create a new Record.How to deal with this this?
so you need to check the existence of the record by ID, before showing the edit form.
@@CodeJava Yes ,thats ok . If we are using DTOS and using some kind of mapper (Custom mapper, Dozer ,Mapstruct ),How is it the more clean way to transform the DTO to an entity when performing and update using the Found entity? Because we will need to update the found entity with DTO values ,except the id ,because the DTO does not have any id set inside the request body , the ID is comming from the Path variable. It will be great if you can make a short video showing the cleanest and more elegant way. The most videos on TH-cam ommit this things,this is real World apps have to deal with all the time . Thanks !!
Thank you so much bro, you're only the best!
You're welcome!
im using jsp instead of html files and im not able to see database items in my jsp page what would you recommend me? where do i make wrong?
If you're using JSP, you need to have tomcat-embed-jasper dependency. Kindly follow this tutorial: www.codejava.net/frameworks/spring-boot/how-to-create-a-spring-boot-web-application-spring-mvc-with-jsp-thymeleaf#JSP
Great Tutorial!
Glad it was helpful!
Có khoá dạy ở Hà Nội không thầy ơi.
anh ko dạy trực tiếp em ạ. Em có thể tìm học khóa của anh trên Udemy tại đây: www.udemy.com/user/namhaminh/
thank you so much, it's very helpful for me
Glad it helped!
In my show home page method around 22:45 the main controller wont print to console. Any ideas?
that means the handler method was not called. Did the home page get displayed?
@@CodeJava Yes it did
Can you show all the plugins need to do this project?
I just use IntelliJ Ultimate edition.
Great tutorial thank you ❤❤
You’re welcome 😊
hi , i have a problem in data base the table is not created on my sql i have tried a lot to solve this problem but it's not working , what should i do ?
did you set hibernate.ddl-auto=update? refer to this guide: www.codejava.net/frameworks/hibernate/hibernate-forward-engineering-create-tables-from-entity-classes
Máy em dùng sql sever express, port 1433, em làm như anh xong lúc run nó báo lỗi java.lang.NullPointerException: Cannot invoke "org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(java.sql.SQLException, String)" because the return value of "org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.sqlExceptionHelper()" is null... thì phải sửa như nào ạ@@
có khả năng là phiên bản JDBC driver cho SQL server chưa phù hợp với version của Hibernet hoặc version của SQL Server. Em thử kiểm tra và dùng phiên bản khác xem.
Anh ơi cho em hỏi phần JUnit testAddNew ạ. Em bị NullPointerException ở đối tượng Repo và bắt buộc phải dùng Try Catch để pass Test, anh có thể giải thích tại sao không ạ ?
cho anh xem code test class của em thì mới biết được.
@@CodeJava Em fix được rồi ạ
@hoanguchuy7120 fix sao z người ae, chỉ mình với
good job anh ơi !!!
thank you :)
Hi , i would like to thank you immensely for the helpful videos you're providing !
do you have an idea on how to implement CRUD operations on cascade ?
yes, watch this video: th-cam.com/video/ctwRpskAeIU/w-d-xo.html
@@CodeJava thank you so much for the fast reply , Subscribed ~ !!!
wouldn't you know it it can be done with Spring Data MongoDB ?
@@Naitokalmah yes, it's possible with Spring Data MongoDB. I'll publish some videos for that.
@@CodeJava looking forward to it , notifications bell is ON !
@@CodeJava please share his udemy course link
Hi, Thank you soo much for this. When i run the first test case, i get this error "Field 'id' doesn't have a default value". Even though i follow all your steps. Please help
make sure the id column in table has auto increment enabled.
@@CodeJava Thank you! i noticed yours did this automatically and i needed to drop and recreate my table. How did you do this automatically
@@MyMojoSoDopeNights set property hibernate.ddl-auto=update in application.properties
@@CodeJava did that but still didn’t work. It’s okay. I don’t want to take too much of your time. Thank you so much for this amazing video again
Good tuto. Please sir can your show how to insert data in twoo table with thymeleaf.
check this video: th-cam.com/video/ctwRpskAeIU/w-d-xo.html
thanks so much for this tutorial,
You are so welcome!
When i tried to add org.webjars as gr.oupid, for bootstrap , it says no dependency present and also webjars-locator-core is not present also.How can i add bootstrap then?
it's because of IntelliJ doesn't update automatically. You need to reload Maven build file for the changes to take effect.
Very good
Thanks
Very well done. Thanks.
Glad you liked it!
my program when editing a row creates a new one instead of editing the one that the id belongs to. How can I fix it? From what I've noticed, my code doesn't go through the catch
perhaps you're missing a hidden field for ID in the edit form. Without that, it always creates a new row.
can u provide the github link? and also when I try to update "There was an unexpected error (type=Internal Server Error, status=500).
An error happened during template parsing (template: "class path resource " this error occurring .
I guess you specify wrong name for the view returned from the handler method. Anyway, I couldn't help further without full exception/error.
in my case hibernate:create table..... is not show in my console like yours in 36:45 and i think because of this the varchar in mysql is still 225 even though i have specified 45 and also not checking the NN in mysql
did you set the property show_sql = true in the application properties file?
@@CodeJava yes, everthing worked just that hybernate doesnot show in consol
@@kathlung7366Did you figure out the issue? I am having the same issue and my show_sql is also set to true. The length I have specified or anything else is being applied.
@@Erick-eb2mzno Erick but without that also my final program works, wby?
Chào thầy, thank thầy ạ!
ko có gì em ạ.
43:48 Java HotSpot(TM) 64-Bit Server VM warning: Sharing is only supported for boot loader classes because bootstrap classpath has been appended. Can you help me?
kindly check the solution in this StackOverflow thread: stackoverflow.com/questions/54205486/how-to-avoid-sharing-is-only-supported-for-boot-loader-classes-because-bootstra
thank you @@CodeJava
Yêu anh nhất đấy
cảm ơn em
Can you please tell where I can find that Database Dialog pop-up window I cant able to find it?
It's available in Ultimate edition only. Do you use IntelliJ Ultimate?
Thank you for your video but my maven cant recognize webjar I dont know whats going on
I got it worked by adding dependency manually
Glad to hear that.
Thank you so much for your reply. I got a weird problem, last night after I added boolean enabled in the User class it works fine. But today I running this program again it gives me
org.springframework.orm.jpa.JpaSystemException: Null value was assigned to a property [class com.mywebapp.myapp.user.User.enabled] of primitive type Error. I dont know what is going on.
chú làm hướng dẫn làm RDBMS CRUD được ko ạ?
chau xem video nay nhe: th-cam.com/video/1pA64-foiz8/w-d-xo.html
very helpful tutorial thank you bro
Glad it helped
Hello I tried to follow this tutorial but was not able to add anything to the database. In your video, when you write the tests to adduser or getallusers it automatically adds it for you. But for me it does not even when I re-run the application
Please Help!!
did you specify spring.jpa.hibernate.ddl-auto=update in the application.properties file?
Do you have the github link?
I'm getting the below error while starting the spring boot application
java.sql.SQLException: Access denied for user 'User'@'localhost' (using password: YES)
I don't have exact code, but you can find similar one in this article: www.codejava.net/frameworks/spring/spring-mvc-spring-data-jpa-hibernate-crud-example
Regarding the error, it means you're using wrong username or password of MySQL. Check for that.