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

Поділитися
Вставка
  • Опубліковано 9 лис 2024

КОМЕНТАРІ • 101

  • @vamsikrishnaodela2639
    @vamsikrishnaodela2639 24 дні тому

    🎯 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
    @JavaGuides  3 роки тому +13

    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
      @funcoding1797 3 роки тому

      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
      @jagadeesh8751 2 роки тому +1

      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
    @nml4546 2 роки тому +3

    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
    @neeraj91mathur 5 місяців тому

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

    • @pkmkb-69
      @pkmkb-69 5 місяців тому

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

  • @shamsularefinsajib7778
    @shamsularefinsajib7778 Рік тому

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

  • @kushek3208
    @kushek3208 8 місяців тому

    Very useful video thanks a lot🙏

  • @Lboards130
    @Lboards130 Рік тому +1

    Thanks for the clip, it was very helpful.

  • @karunakarverma
    @karunakarverma 2 роки тому +1

    You are awesome 😎 you created lifetime reference.

  • @BKYADAV-zm7yv
    @BKYADAV-zm7yv 2 роки тому

    Huge respect from my side sir ❤️

  • @Malarselvi.M
    @Malarselvi.M 10 місяців тому +1

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

  • @ammaraziz5734
    @ammaraziz5734 2 місяці тому

    Thank you.

  • @pylypiukantonio2215
    @pylypiukantonio2215 Рік тому

    Thank you.Helped me a lot

  • @brayannkouam9097
    @brayannkouam9097 Рік тому

    than you master .well explained tutorial your are a boss

  • @karthikravikumar-cq6df
    @karthikravikumar-cq6df Рік тому

    the best of all

  • @paulovinicius9940
    @paulovinicius9940 3 роки тому +1

    Very good as always!

  • @fsoldierdeth
    @fsoldierdeth Рік тому

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

  • @dgonx017_
    @dgonx017_ 2 роки тому +1

    Best tutorial, new sub

  • @Musfimurshadi
    @Musfimurshadi 9 місяців тому

    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?

  • @Musfimurshadi
    @Musfimurshadi 9 місяців тому

    very good

  • @sachkosachbolnagalathhaiky9938

    thank you brother amazing

  • @dadasajad8741
    @dadasajad8741 2 роки тому

    amazing work brother. thank you very much!

  • @tanmay.k8525
    @tanmay.k8525 Рік тому

    Wow, thanks dude.

  • @jagadeesh8751
    @jagadeesh8751 2 роки тому +1

    very clear. thanks broooooooo

  • @thabtiguenidi2960
    @thabtiguenidi2960 Рік тому +1

    👍

  • @gariktadevosyan764
    @gariktadevosyan764 Рік тому

    Thank you bro, very helpful.

  • @abinayaelangovan8585
    @abinayaelangovan8585 2 роки тому +1

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

  • @thaminduKavinda
    @thaminduKavinda Рік тому

    Thanks for the video

  • @Azure-d8d
    @Azure-d8d 8 місяців тому

    Thankyou bro❤

  • @TechnicalYarana
    @TechnicalYarana 3 місяці тому

    can i use this project in android studio

  • @samuelquentacarvajal9910
    @samuelquentacarvajal9910 3 роки тому

    very good :)
    "saludos desde bolivia "

  • @mistermiaumiau2134
    @mistermiaumiau2134 8 місяців тому

    very good video!

  • @janithsahasra3971
    @janithsahasra3971 Рік тому

    thanks a log it's really helpfull

  • @remiimartinnn
    @remiimartinnn Рік тому

    Thanks

  • @makarikevin
    @makarikevin 2 роки тому

    Great tutorial

  • @little-by-little-one-trave1770

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

  • @delightful730
    @delightful730 2 роки тому

    please do with postgreseSql

  • @feminaazmi3753
    @feminaazmi3753 2 роки тому

    Really helpful. Thank You :)

  • @subamsarkar_
    @subamsarkar_ 2 роки тому +2

    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
      @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
      @little-by-little-one-trave1770 Рік тому +2

      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
      @malfunkshungo Рік тому

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

    • @adityacr7407
      @adityacr7407 4 місяці тому

      ​@@malfunkshungo mine is not working. Please help

    • @adityacr7407
      @adityacr7407 4 місяці тому

      Done . thanks a lot

  • @dineshsv4186
    @dineshsv4186 3 роки тому

    Thank you its working

  • @arunpitchaimani7713
    @arunpitchaimani7713 3 роки тому

    Please create spring boot and graphql playlist videos

  • @UddhikaIshara
    @UddhikaIshara 11 місяців тому

    Thank you very much

  • @cdlijia
    @cdlijia Рік тому

    学习了。

  • @karthikk5278
    @karthikk5278 3 роки тому

    Thank you

  • @soundharn8257
    @soundharn8257 Рік тому

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

  • @sajithsukumaran99
    @sajithsukumaran99 3 роки тому +1

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

    • @paulovinicius9940
      @paulovinicius9940 3 роки тому +1

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

    • @rickhunter8216
      @rickhunter8216 Рік тому

      @@paulovinicius9940 CORRECT.

  • @AJEETKUMAR-dk2kv
    @AJEETKUMAR-dk2kv 2 роки тому

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

    • @AJEETKUMAR-dk2kv
      @AJEETKUMAR-dk2kv 2 роки тому

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

    • @AJEETKUMAR-dk2kv
      @AJEETKUMAR-dk2kv 2 роки тому

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

    • @rickhunter8216
      @rickhunter8216 Рік тому

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

  • @mariocs23
    @mariocs23 2 роки тому

    King

  • @dilaragoral106
    @dilaragoral106 2 роки тому

    best!!

  • @fookoboy9623
    @fookoboy9623 2 роки тому

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

  • @vinayakhorambali5463
    @vinayakhorambali5463 2 роки тому

    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
    @utkarshguruji8894 7 місяців тому

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

  • @yawamoako7811
    @yawamoako7811 3 роки тому

    Great

  • @adityacr7407
    @adityacr7407 4 місяці тому

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

  • @andrejpetnuch2125
    @andrejpetnuch2125 3 роки тому +1

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

    • @maxime045
      @maxime045 2 роки тому

      You configured the application.properties ?

    • @rickhunter8216
      @rickhunter8216 Рік тому

      @@maxime045 THAT IS CORRECT.

  • @josephmctigue4494
    @josephmctigue4494 Рік тому

    where is link to your finished code?

  • @mohamedamaan133
    @mohamedamaan133 4 місяці тому

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

  • @rahuldubey1724
    @rahuldubey1724 2 роки тому

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

  • @anantpratapsingh9067
    @anantpratapsingh9067 2 роки тому

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

    • @subamsarkar_
      @subamsarkar_ 2 роки тому +1

      You can find that in his Github Repo

    • @anantpratapsingh9067
      @anantpratapsingh9067 2 роки тому

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

    • @subamsarkar_
      @subamsarkar_ 2 роки тому

      @@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
      @anantpratapsingh9067 2 роки тому

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

    • @anantpratapsingh9067
      @anantpratapsingh9067 2 роки тому

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

  • @sahilsharma8691
    @sahilsharma8691 2 роки тому

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

    • @N7000nn
      @N7000nn 2 роки тому

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

  • @ravindrakawale5161
    @ravindrakawale5161 3 роки тому

    can we create springboot project in intellij like eclipse

    • @rickhunter8216
      @rickhunter8216 Рік тому

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

  • @reverseflash2800
    @reverseflash2800 3 роки тому

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

    • @JavaGuides
      @JavaGuides  3 роки тому +1

      free community edition version se kam chal jayega.

  • @rickhunter8216
    @rickhunter8216 Рік тому

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

    • @aniketdey8449
      @aniketdey8449 Рік тому

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

    • @prajwalnakure
      @prajwalnakure 10 місяців тому

      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.

  • @rishimohanagnihotri517
    @rishimohanagnihotri517 2 роки тому

    What does @crosaorigin annotation do?

    • @rickhunter8216
      @rickhunter8216 Рік тому

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

  • @chandrasekar3992
    @chandrasekar3992 Рік тому

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

  • @yarik83men51
    @yarik83men51 2 роки тому

    +++

  • @BinKonChuot
    @BinKonChuot 7 місяців тому

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

    • @JavaGuides
      @JavaGuides  7 місяців тому

      OMG, you want controller, service, repository then watch another video: ua-cam.com/video/yybOzbOLegE/v-deo.htmlsi=JrR5T1VmaKIkEM32

  • @subratmishra91
    @subratmishra91 2 роки тому

    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
    @raja90rocks 2 роки тому

    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
      @N7000nn 2 роки тому

      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
    @omkarkumbhar2001 Рік тому

    Thank You