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

[@vamsikrishnaodela2639]

🎯 Key points for quick navigation: 00:00:00 *🚀 Introduction to Spring Boot CRUD Project with IntelliJ IDEA* - Overview of creating a Spring Boot CRUD application, - Using IntelliJ IDEA, MySQL, and Postman for development and testing, - Utilizing Spring Data JPA and Hibernate for the repository layer. 00:01:24 *🛠️ Setting up Project with Spring Initializr* - Using Spring Initializr to create a Spring Boot project, - Selecting Maven project, Java language, and Spring Boot version 2.5.5, - Adding necessary dependencies: Spring Web, Spring Data JPA, MySQL JDBC driver, and Lombok. 00:05:05 *⚙️ Importing and Configuring the Project in IntelliJ IDEA* - Importing the project into IntelliJ IDEA, - Setting up package structure: model, controller, repository, and exception packages, - Configuring MySQL database connection in `application.properties`. 00:07:01 *🗃️ Database Setup and Entity Creation* - Creating a database in MySQL server, - Configuring database connection properties, - Creating a JPA entity for the `Employee` table with Lombok annotations and entity mappings. 00:16:06 *📊 Employee Repository and Custom Exception* - Creating Spring Data JPA repository for CRUD operations, - Implementing a `ResourceNotFoundException` for handling non-existent records, - Using `@ResponseStatus` to manage HTTP response status. 00:19:56 *🧩 Developing REST Controller for CRUD Operations* - Building REST endpoints for `Employee` operations, - Implementing GET endpoint to retrieve all employees, - Testing GET request using Postman and outlining request mappings. 00:25:08 *✨ Creating and Testing Add Employee API* - Developing POST request handler to add a new employee, - Setting up and using Postman to send POST requests with JSON payload, - Validating functionality by adding records to the database. 00:30:22 *📦 Fetching Objects from Database* - Discusses the procedure to retrieve an employee object using the `findById` method, - Explains handling a scenario where a record with a specific ID doesn't exist using a custom exception, - Demonstrates how to return a response entity upon successful data retrieval. 00:33:27 *🛠️ Testing Get Employee API* - Shows how to use Postman to test the GET API endpoint, - Explains passing an employee ID in the URL to fetch data, - Validates the response to confirm API functionality. 00:34:25 *🔄 Building Update Employee API* - Details the creation of an update method using response entity, - Describes fetching, updating, and saving employee data, - Introduces the PUT mapping annotation for updating resources. 00:40:38 *🧪 Testing Update Employee API* - Demonstrates using Postman for testing the update employee API, - Illustrates updating employee details and validating the response, - Shows how to ensure data consistency post-update with a GET call. 00:43:23 *🗑️ Building Delete Employee API* - Explains the process of creating a delete employee method, - Provides a check for employee existence before deletion, - Discusses returning no content status upon successful deletion. 00:46:12 *🧹 Testing Delete Employee API* - Describes testing the DELETE API using Postman, - Highlights verifying deletion through a GET request check, - Confirms successful deletion with HTTP status code 204. Made with HARPA AI

[@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.

[@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

[@shamsularefinsajib7778]

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

[@Lboards130]

Thanks for the clip, it was very helpful.

[@karunakarverma]

You are awesome 😎 you created lifetime reference.

[@BKYADAV-zm7yv]

Huge respect from my side sir ❤️

[@dadasajad8741]

amazing work brother. thank you very much!

[@paulovinicius9940]

Very good as always!

[@fsoldierdeth]

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

[@Malarselvi.M]

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 😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊

[@kushek3208]

Very useful video thanks a lot🙏

[@pylypiukantonio2215]

Thank you.Helped me a lot

[@brayannkouam9097]

than you master .well explained tutorial your are a boss

[@dgonx017_]

Best tutorial, new sub

[@jagadeesh8751]

very clear. thanks broooooooo

[@gariktadevosyan764]

Thank you bro, very helpful.

[@feminaazmi3753]

Really helpful. Thank You :)

[@karthikravikumar-cq6df]

the best of all

[@samuelquentacarvajal9910]

very good :) "saludos desde bolivia "

[@tanmay.k8525]

Wow, thanks dude.

[@sachkosachbolnagalathhaiky9938]

thank you brother amazing

[@utkarshguruji8894]

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

[@janithsahasra3971]

thanks a log it's really helpfull

[@makarikevin]

Great tutorial

[@thaminduKavinda]

Thanks for the video

[@mistermiaumiau2134]

very good video!

[@rahuldubey1724]

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

[@Musfimurshadi]

very good

[@dineshsv4186]

Thank you its working

[@Azure-d8d]

Thankyou bro❤

[@abinayaelangovan8585]

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

[@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 आ जाता

[@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

[@soundharn8257]

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

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

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

[@Musfimurshadi]

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?

[@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

[@TechnicalYarana]

can i use this project in android studio

[@ammaraziz5734]

Thank you.

[@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.

[@fookoboy9623]

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

[@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.

[@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.

[@adityacr7407]

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

[@mohamedamaan133]

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

[@mohamedamaan133]

403 Forbidden

[@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.

[@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..

[@dilaragoral106]

best!!

[@josephmctigue4494]

where is link to your finished code?

[@arunpitchaimani7713]

Please create spring boot and graphql playlist videos

[@delightful730]

please do with postgreseSql

[@karthikk5278]

Thank you

[@reverseflash2800]

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

[@JavaGuides]

free community edition version se kam chal jayega.

[@rishimohan1408]

What does @crosaorigin annotation do?

[@rickhunter8216]

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

[@UddhikaIshara]

Thank you very much

[@ravindrakawale5161]

can we create springboot project in intellij like eclipse

[@rickhunter8216]

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

[@yawamoako7811]

Great

[@cdlijia]

学习了。

[@remiimartinnn]

Thanks

[@mariocs23]

King

[@thabtiguenidi2960]

👍

[@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..

[@omkarkumbhar2001]

Thank You