Spring Boot CRUD Operations with MySQL using IntelliJ IDEA | CRUD Operation using REST API in Java

In this video, we will build Spring Boot CRUD REST API Project using IntelliJ IDEA as our IDE. We will use the Postman client to test the REST APIs.
We will use Spring Data JPA to develop a repository layer and MySQL database at the backend.
Get source code and read the blog post at www.javaguides.net/2021/10/sp...
GitHub link: github.com/RameshMF/React-Hoo...
#springboot #IntelliJIDEA #postman
My Top 10+Udemy Courses (Bestseller Courses):
1. Spring 6 & Spring Boot 3 for Beginners (Includes 5 Projects):
www.udemy.com/course/learn-sp...
2. Building Real-Time REST APIs with Spring Boot - Blog App:
www.udemy.com/course/building...
3. Building Microservices with Spring Boot and Spring Cloud:
www.udemy.com/course/building...
4. Testing Spring Boot App with JUnit, Mockito & Testcontainers:
www.udemy.com/course/testing-...
5. Spring Boot 3 Thymeleaf REAL-TIME Web Application - Blog App:
www.udemy.com/course/spring-b...
6. Master Spring Data JPA with Hibernate:
www.udemy.com/course/master-s...
7. Spring Boot + Apache Kafka Course:
www.udemy.com/course/spring-b...
8. Spring Boot 3 + RabbitMQ Course:
www.udemy.com/course/spring-b...
9. Learn Thymeleaf with Spring Boot 3:
www.udemy.com/course/learn-th...
Check all my Udemy courses and discount coupons:
www.javaguides.net/p/my-udemy...
Visit My Top Java Guides Blog: www.javaguides.net/

[@JavaGuides]

Guys, Intellij idea is great IDE so go ahead and use free community addition for building spring boot projects. If you are new Intellij idea then check out intellij idea playlist on this channel.

[@funcoding1797]

IntellijIDEA Ultimate Edition is much more attractive and better, especially in the field of completing the codes .. with a lot of plugins e.g Codota as well SST or eclipse and is free for one year...😍 Tnx a lot bro... you're the best...

[@jagadeesh8751]

bro, In my code , compiler complains ResourceNotFoundException is not handled. you didnot used "throws" keyword in getById method. how it is working for you bro ??

[@nml4546]

Very good was I got past the database problem. For some reason, building the project from the downloaded Springboot zip file, I could not get past a database problem. I spent a couple of days researching and trying things to no avail. I finally decided tp build the project in the traditional manner, i,e, from scratch (but including SpringInitializer) and the needed dependencies. Then I just followed the view and everything worked as expected.

[@dadasajad8741]

amazing work brother. thank you very much!

[@Lboards130]

Thanks for the clip, it was very helpful.

[@pylypiukantonio2215]

Thank you.Helped me a lot

[@shamsularefinsajib7778]

Thanks so much, I am new to java spring boot, i found it useful

[@gariktadevosyan764]

Thank you bro, very helpful.

[@paulovinicius9940]

Very good as always!

[@feminaazmi3753]

Really helpful. Thank You :)

[@BKYADAV-zm7yv]

Huge respect from my side sir ❤️

[@fsoldierdeth]

love u man, thank u for that it really helped me a lot believe me

[@jagadeesh8751]

very clear. thanks broooooooo

[@tanmay.k8525]

Wow, thanks dude.

[@kushek3208]

Very useful video thanks a lot🙏

[@brayannkouam9097]

than you master .well explained tutorial your are a boss

[@karunakarverma]

You are awesome 😎 you created lifetime reference.

[@sachkosachbolnagalathhaiky9938]

thank you brother amazing

[@janithsahasra3971]

thanks a log it's really helpfull

[@dineshsv4186]

Thank you its working

[@thaminduKavinda]

Thanks for the video

[@neeraj91mathur]

Very crisp and to the point tutorial. Great job brother, this was helpful 👍

[@pkmkb-69]

How to update this in XAMPP any idea? I mean how to update tables in XAMPP after fetching APIs

[@user-tm2kc3kp5l]

Thankyou bro❤

[@UddhikaIshara]

Thank you very much

[@makarikevin]

Great tutorial

[@samuelquentacarvajal9910]

very good :) "saludos desde bolivia "

[@mistermiaumiau2134]

very good video!

[@karthikravikumar-cq6df]

the best of all

[@dgonx017_]

Best tutorial, new sub

[@omkarkumbhar2001]

Thank You

[@karthikk5278]

Thank you

[@abinayaelangovan8585]

ResourceNotFoundException is not working.. even in the demo shown in video, the customised error message is not getting printed

[@user-zj3mi9ps9g]

very good

[@cdlijia]

学习了。

[@dilaragoral106]

best!!

[@remiimartinnn]

Thanks

[@vinayakhorambali5463]

hello i need a code for postmaping where if i have to save a data in my data base and if any of the field say "xyz" already exist in it then it should return me "field "xyz" already exists"... please help

[@utkarshguruji8894]

33:16 --> at line number 33 when I used Long instead of long , it is giving 404 error . Can anyone explain why ?

[@rahuldubey1724]

24:58 bro mera sara values that is first name, last name and email id sb null show kr rha hai..please help

[@soundharn8257]

While inserting data inro table employee 'Column name set 'is not listing the column names not listing in suggestions😢

[@yawamoako7811]

Great

[@adityacr7407]

Can anyone help? Table is not created in my ems database

[@little-by-little-one-trave1770]

Good video thanks. According to mysql convention table name should be singular.

[@fookoboy9623]

if its showing web service is not started 8080 is busy then in application change the port number server.port=9090

[@user-zj3mi9ps9g]

Can you please share 3 or 4 small project using OOPS concept, Springboot, Java legacy idea ? With explaination in your video please ? If you already have, can you leave the link as a reply here please?

[@arunpitchaimani7713]

Please create spring boot and graphql playlist videos

[@user-xh2yr2do9j]

Jii this is amazing learning video.. I expect you to do project in intellij idea and postman and the outputs in excel..Hope you see back in the next video with what I expect before 😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊

[@josephmctigue4494]

where is link to your finished code?

[@mariocs23]

King

[@thabtiguenidi2960]

👍

[@delightful730]

please do with postgreseSql

[@subamsarkar_]

Hi @Java Guides. I am not able to create the table. I did same coding as shown. And I am not getting any error in the build console. But the table is not getting created. I also changed the mysql dialect to my local MySQL version.

[@little-by-little-one-trave1770]

Hi any solution I am also facing the same issue. I am using mysql 8.

[@little-by-little-one-trave1770]

I used this it worked spring.jpa.hibernate.ddl-auto=update spring.datasource.url=jdbc:mysql://${MYSQL_HOST:localhost}:3306/ems spring.datasource.username=root spring.datasource.password=password spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.jpa.show-sql: true

[@malfunkshungo]

@@little-by-little-one-trave1770 Thanks for the update. Mine also worked with this.

[@adityacr7407]

​@@malfunkshungo mine is not working. Please help

[@adityacr7407]

Done . thanks a lot

[@sajithsukumaran99]

The first two IDs are always repeating...do u know what might be the problem..? Pls suggest

[@paulovinicius9940]

You copied and forgot to change the values in the commandLine method.

[@rickhunter8216]

@@paulovinicius9940 CORRECT.

[@mohamedamaan133]

Authentication required showing when testing via Postman. but i did correctly. can you give a solution. how to test it

[@mohamedamaan133]

403 Forbidden

[@sahilsharma8691]

I am not getting the .set in list in employee.setFirstName(); What can I do?

[@N7000nn]

You need to add lombock configuration in your Employee class. Above the class type @Setter and that works like setMethod of any field you have. The same goes for @Getter, @ToString etc..

[@andrejpetnuch2125]

when i use @Entity in sringboot, table is not created. Where is the problem?

[@maxime045]

You configured the application.properties ?

[@rickhunter8216]

@@maxime045 THAT IS CORRECT.

[@anantpratapsingh9067]

at 8:29 you printed spring.datasource.url , from where we can get this link and all other syntax ?

[@subamsarkar_]

You can find that in his Github Repo

[@anantpratapsingh9067]

@@subamsarkar_ धन्यवाद भाई ।

[@subamsarkar_]

@@anantpratapsingh9067 Bhai are you able to build the project ? I am half way through the video. Did everything same. No error in the console but table is not getting created.

[@anantpratapsingh9067]

@@subamsarkar_ आपने jpa dependency add किया था

[@anantpratapsingh9067]

किया ही होगा नहीं तो error आ जाता

[@reverseflash2800]

IntelliJ idea free version se kam chal jaayega yaa pro version required hai

[@JavaGuides]

free community edition version se kam chal jayega.

[@ravindrakawale5161]

can we create springboot project in intellij like eclipse

[@rickhunter8216]

SPRING TOOLS SUITE (STS) IS A ECLIPSE IDE FOR SPRING.

[@rishimohanagnihotri517]

What does @crosaorigin annotation do?

[@rickhunter8216]

IT ALLOWS THAT GOOGLE CHROME OR MOZILLA OR EDGE DON'S BLOCK YOU WHEN YOU USE POSTMAN.

[@AJEETKUMAR-dk2kv]

Hello sir, I'm using eclipse IDE for project....

[@AJEETKUMAR-dk2kv]

I'm not able to run it on postman it's always showing error not found...

[@AJEETKUMAR-dk2kv]

Do I need to link on MySQL before postman? Coz I haven't done yet...

[@rickhunter8216]

@@AJEETKUMAR-dk2kv YOU NEED CONFIGURE THE APPLICATION. PROPERTIES FILE AND TYPE THE MYSQL CONNECTION.

[@rickhunter8216]

IF YOU ARE USING MYSQL DATABASE, SO YOU DON'T NEED HARDCODE WITH COMMAND RUNNER. IT CAN GENERATE CONFUSION.

[@aniketdey8449]

Didn't get you bro, can you explain. And are you able to create the table from the code?

[@prajwalnakure]

Yes, once you create the createEmployee() method ...u don't need the Command Runner interface. You can safely delete that , or else it will generate those two employees whenever we run the main class.

[@chandrasekar3992]

Text is very small, Can't see properly , It's wasting my time

[@BinKonChuot]

omg, dont write code that, A project need full have controller, service, repo and model, you not have service?

[@JavaGuides]

OMG, you want controller, service, repository then watch another video: kzbin.info/www/bejne/r6rFgK2YhLGYnacsi=JrR5T1VmaKIkEM32

[@yarik83men51]

+++

[@subratmishra91]

java.lang.ClassCastException: class net.javaguides.springboot.model.Employee cannot be cast to class org.springframework.boot.context.properties.bind.BindResult (net.javaguides.springboot.model.Employee and org.springframework.boot.context.properties.bind.BindResult are in unnamed module of loader 'app')

[@raja90rocks]

Hi JavaGuides, employee.setFirstName , LastName , email - can't be added facing issues . how to solve ? import model.Employee; import repository.EmployeeRepository; @SpringBootApplication public class SpringbootBackendApplication implements CommandLineRunner{ public static void main(String[] args) { SpringApplication.run(SpringbootBackendApplication.class, args); } @Autowired private EmployeeRepository employeeRepository; @Override public void run(String... args) throws Exception { Employee employee=new Employee(); employee.setFirstName -----------------------------> faced issues can't set the value } }

[@N7000nn]

You need to add lombock configuration in your Employee class. Above the class type @Setter and that works like setMethod of any field you have. The same goes for @Getter, @ToString etc..